public int Insert(DispatchWorkEntity dispatchWork)
{
int res = 0;
bool flag = false;
try
{
var p = Param(dispatchWork);
flag = (bool)unitOfWork.ProcedureExecute("ptgroup_DispatchWork_Insert", p);
if (flag)
{
res = p.Get <int>("@Id");
}
else
{
res = 0;
}
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
return(res);
}
public bool Update(DispatchWorkEntity dispatchWork)
{
bool res = false;
try
{
var p = Param(dispatchWork, "edit");
res = (bool)unitOfWork.ProcedureExecute("ptgroup_DispatchWork_Update", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
}
private DynamicParameters Param(DispatchWorkEntity dispatchWork, string action = "add")
{
var p = new DynamicParameters();
if (action == "edit")
{
p.Add("@Id", dispatchWork.ID);
p.Add("@ModifiedDate", dispatchWork.ModifiedDate);
}
else
{
p.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
p.Add("@CreatedDate", dispatchWork.CreatedDate);
}
p.Add("@CoefficientsSalary", dispatchWork.CoefficientsSalary);
p.Add("@ParentID", dispatchWork.ParentID);
p.Add("@WorkCode", dispatchWork.WorkCode);
p.Add("@WorkName", dispatchWork.WorkName);
p.Add("@WorkType", dispatchWork.WorkType);
return(p);
}
