public ReturnValue Update(Composition model) { OleDbParameter[] parametersUpdate = { new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12), new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar), new OleDbParameter("@FatType", OleDbType.VarWChar,1), new OleDbParameter("@FatEvaluate", OleDbType.VarWChar,1), new OleDbParameter("@FatTarget", OleDbType.VarWChar), new OleDbParameter("@MuscleTarget", OleDbType.VarWChar), new OleDbParameter("@BodyWeightTarget", OleDbType.VarWChar), new OleDbParameter("@Physicians", OleDbType.VarWChar,50), new OleDbParameter("@EmployeeID", OleDbType.VarWChar,18), new OleDbParameter("@YearMonth", OleDbType.VarWChar,6)}; parametersUpdate[0].Value = model.UPDATER_ID; parametersUpdate[1].Value = model.TERMINAL_CD; parametersUpdate[2].Value = model.FatType; parametersUpdate[3].Value = model.FatEvaluate; parametersUpdate[4].Value = model.FatTarget; parametersUpdate[5].Value = model.MuscleTarget; parametersUpdate[6].Value = model.BodyWeightTarget; parametersUpdate[7].Value = model.Physicians; parametersUpdate[8].Value = model.EmployeeID; parametersUpdate[9].Value = model.YearMonth; return OleDbHelper.ExecuteSql(Update_SQL, parametersUpdate); }
/// <summary> /// AddUpdate /// </summary> /// <param name="model"></param> /// <returns></returns> public ReturnValue AddUpdate(Composition model) { ReturnValue resoult = dalComposition.Search(model.EmployeeID, model.YearMonth); if (!resoult.ErrorFlag) { return resoult; } if (resoult.Count > 0) { resoult = dalComposition.Update(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的体成分信息", "1", model.TERMINAL_CD); } } else { resoult = dalComposition.Add(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的体成分信息", "1", model.TERMINAL_CD); } } return resoult; }