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); }