using WIDESEA_Common.DBHelper;
|
|
namespace WIDESEA_Common.Tools
|
{
|
/// <summary>
|
/// 序号管理帮助类
|
/// </summary>
|
public class IdenxManager
|
{
|
static FreeDB freeDB = new FreeDB();
|
private static object lock_obj = new object();
|
|
/// <summary>
|
/// 获取任务编号
|
/// </summary>
|
/// <returns></returns>
|
public static int GetTaskNo(string numType = "tasknum")
|
{
|
lock (lock_obj)
|
{
|
var oldNo = freeDB.DataBase.Ado.QuerySingle<int>("select taskno from dt_task_number where numtype=@numtype", new { numType });
|
freeDB.DataBase.Ado.ExecuteNonQuery("update dt_task_number set taskno=taskno+1 where numtype=@numtype", new { numType });
|
return oldNo + 1;
|
}
|
}
|
}
|
}
|
