/// <summary>
/// 添加新的需求Model
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddNewModel(RequirementManage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"insert into RequirementManage (CategoryId,RequirementType,Description,Status,CreateTime,Operator,AccId,RefId,OriginDesc,Terminal,UserVal,Difficult) " +
"Values(@CategoryId,@RequirementType,@Description,@Status,@CreateTime,@Operator,@AccId,@RefId,@OriginDesc,@Terminal,@UserVal,@Difficult);" +
"select @@IDENTITY;");
try
{
return(DapperHelper.ExecuteScalar <int>(strSql.ToString(), new
{
CategoryId = model.CategoryId,
RequirementType = model.RequirementType,
Description = model.Description,
Status = model.Status,
CreateTime = DateTime.Now,
Operator = model.Operator,
AccId = model.AccId,
RefId = model.RefId,
OriginDesc = model.OriginDesc,
Terminal = model.Terminal,
UserVal = model.UserVal,
Difficult = model.Difficult
}));
}
catch (Exception ex)
{
Logger.Error("新增需求信息出错！", ex);
return(0);
}
}
/// <summary>
/// 新增需求
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int AddNewModel(RequirementManage model)
{
RequirementManageDAL dal = new RequirementManageDAL();
return(dal.AddNewModel(model));
}
