public ReturnValue AddUpdate(Surgery model) { ReturnValue resoult = dalSurgery.Search(model.EmployeeID,model.YearMonth); if (!resoult.ErrorFlag) { return resoult; } if (resoult.Count > 0) { resoult = dalSurgery.Update(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的外科信息", "1", model.TERMINAL_CD); } } else { resoult = dalSurgery.Add(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的外科信息", "1", model.TERMINAL_CD); } } return resoult; }
public ReturnValue Add(Surgery model) { OleDbParameter[] parameters = { new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12), new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar), new OleDbParameter("@EmployeeID", OleDbType.VarWChar,18), new OleDbParameter("@YearMonth", OleDbType.VarWChar,6), new OleDbParameter("@Length", OleDbType.VarWChar,8), new OleDbParameter("@Bust", OleDbType.VarWChar,8), new OleDbParameter("@Weight", OleDbType.VarWChar,8), new OleDbParameter("@BadBreath", OleDbType.VarWChar,50), new OleDbParameter("@Skin", OleDbType.VarWChar,128), new OleDbParameter("@Lymphoid", OleDbType.VarWChar,128), new OleDbParameter("@Thyroid", OleDbType.VarWChar,128), new OleDbParameter("@Spine", OleDbType.VarWChar,128), new OleDbParameter("@Limbs", OleDbType.VarWChar,128), new OleDbParameter("@Joint", OleDbType.VarWChar,128), new OleDbParameter("@Flatfoot", OleDbType.VarWChar,128), new OleDbParameter("@Genitourinary", OleDbType.VarWChar,128), new OleDbParameter("@Anal", OleDbType.VarWChar,128), new OleDbParameter("@Hernia", OleDbType.VarWChar,128), new OleDbParameter("@Other", OleDbType.LongVarWChar), new OleDbParameter("@MedicalAdvice", OleDbType.LongVarWChar), new OleDbParameter("@Physicians", OleDbType.VarWChar,50)}; parameters[0].Value = model.UPDATER_ID; parameters[1].Value = model.TERMINAL_CD; parameters[2].Value = model.EmployeeID; parameters[3].Value = model.YearMonth; parameters[4].Value = model.Length; parameters[5].Value = model.Bust; parameters[6].Value = model.Weight; parameters[7].Value = model.BadBreath; parameters[8].Value = model.Skin; parameters[9].Value = model.Lymphoid; parameters[10].Value = model.Thyroid; parameters[11].Value = model.Spine; parameters[12].Value = model.Limbs; parameters[13].Value = model.Joint; parameters[14].Value = model.Flatfoot; parameters[15].Value = model.Genitourinary; parameters[16].Value = model.Anal; parameters[17].Value = model.Hernia; parameters[18].Value = model.Other; parameters[19].Value = model.MedicalAdvice; parameters[20].Value = model.Physicians; return OleDbHelper.ExecuteSql(Add_SQL, parameters); }
public ReturnValue AddUpdateSurgery(Surgery model) { BLL_Surgery bll = new BLL_Surgery(); return bll.AddUpdate(model); }
public ReturnValue Update(Surgery model) { SqlParameter[] parametersUpdate = { new SqlParameter("@UPDATER_ID", SqlDbType.NVarChar,12), new SqlParameter("@TERMINAL_CD", SqlDbType.NVarChar,256), new SqlParameter("@EmployeeID", SqlDbType.NVarChar,18), new SqlParameter("@YearMonth", SqlDbType.NVarChar,6), new SqlParameter("@Length", SqlDbType.NVarChar,8), new SqlParameter("@Bust", SqlDbType.NVarChar,8), new SqlParameter("@Weight", SqlDbType.NVarChar,8), new SqlParameter("@BadBreath", SqlDbType.NVarChar,50), new SqlParameter("@Skin", SqlDbType.NVarChar,128), new SqlParameter("@Lymphoid", SqlDbType.NVarChar,128), new SqlParameter("@Thyroid", SqlDbType.NVarChar,128), new SqlParameter("@Spine", SqlDbType.NVarChar,128), new SqlParameter("@Limbs", SqlDbType.NVarChar,128), new SqlParameter("@Joint", SqlDbType.NVarChar,128), new SqlParameter("@Flatfoot", SqlDbType.NVarChar,128), new SqlParameter("@Genitourinary", SqlDbType.NVarChar,128), new SqlParameter("@Anal", SqlDbType.NVarChar,128), new SqlParameter("@Hernia", SqlDbType.NVarChar,128), new SqlParameter("@Other", SqlDbType.NVarChar,256), new SqlParameter("@MedicalAdvice", SqlDbType.NVarChar,1024), new SqlParameter("@Physicians", SqlDbType.NVarChar,50)}; parametersUpdate[0].Value = model.UPDATER_ID; parametersUpdate[1].Value = model.TERMINAL_CD; parametersUpdate[2].Value = model.EmployeeID; parametersUpdate[3].Value = model.YearMonth; parametersUpdate[4].Value = model.Length; parametersUpdate[5].Value = model.Bust; parametersUpdate[6].Value = model.Weight; parametersUpdate[7].Value = model.BadBreath; parametersUpdate[8].Value = model.Skin; parametersUpdate[9].Value = model.Lymphoid; parametersUpdate[10].Value = model.Thyroid; parametersUpdate[11].Value = model.Spine; parametersUpdate[12].Value = model.Limbs; parametersUpdate[13].Value = model.Joint; parametersUpdate[14].Value = model.Flatfoot; parametersUpdate[15].Value = model.Genitourinary; parametersUpdate[16].Value = model.Anal; parametersUpdate[17].Value = model.Hernia; parametersUpdate[18].Value = model.Other; parametersUpdate[19].Value = model.MedicalAdvice; parametersUpdate[20].Value = model.Physicians; return SqlHelper.ExecuteSql(Update_SQL, parametersUpdate); }