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