public ReturnValue AddUpdate(ECG model) { ReturnValue resoult = dalECG.Search(model.EmployeeID,model.YearMonth); if (!resoult.ErrorFlag) { return resoult; } if (resoult.Count > 0) { resoult = dalECG.Update(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的心电图信息", "1", model.TERMINAL_CD); } } else { resoult = dalECG.Add(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的心电图信息", "1", model.TERMINAL_CD); } } return resoult; }
public ReturnValue Add(ECG model) { SqlParameter[] parameters = { 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("@ECGNo", SqlDbType.NVarChar,10), new SqlParameter("@ClinicalDiagnosis", SqlDbType.NVarChar,256), new SqlParameter("@UsedDrugs", SqlDbType.NVarChar,256), new SqlParameter("@SummaryHistory", SqlDbType.NVarChar,256), new SqlParameter("@SummaryBody", SqlDbType.NVarChar,256), new SqlParameter("@PatientSituation", SqlDbType.NVarChar,1), new SqlParameter("@MedicalAdvice", SqlDbType.NVarChar,1024), new SqlParameter("@ECG", SqlDbType.Image), new SqlParameter("@Physicians", SqlDbType.NVarChar,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.ECGNo; parameters[5].Value = model.ClinicalDiagnosis; parameters[6].Value = model.UsedDrugs; parameters[7].Value = model.SummaryHistory; parameters[8].Value = model.SummaryBody; parameters[9].Value = model.PatientSituation; parameters[10].Value = model.MedicalAdvice; if (model.ECGImage == null) { parameters[11].Value = DBNull.Value; } else { parameters[11].Value = model.ECGImage; } parameters[12].Value = model.Physicians; return SqlHelper.ExecuteSql(Add_SQL, parameters); }
public ReturnValue AddUpdateECG(ECG model) { BLL_ECG bll = new BLL_ECG(); return bll.AddUpdate(model); }
public ReturnValue Update(ECG model) { OleDbParameter[] parametersUpdate = { new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12), new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar), new OleDbParameter("@ECGNo", OleDbType.VarWChar,10), new OleDbParameter("@ClinicalDiagnosis", OleDbType.LongVarWChar), new OleDbParameter("@UsedDrugs", OleDbType.LongVarWChar), new OleDbParameter("@SummaryHistory", OleDbType.LongVarWChar), new OleDbParameter("@SummaryBody", OleDbType.LongVarWChar), new OleDbParameter("@PatientSituation", OleDbType.VarWChar,1), new OleDbParameter("@MedicalAdvice", OleDbType.LongVarWChar), new OleDbParameter("@ECG", OleDbType.LongVarBinary), 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.ECGNo; parametersUpdate[3].Value = model.ClinicalDiagnosis; parametersUpdate[4].Value = model.UsedDrugs; parametersUpdate[5].Value = model.SummaryHistory; parametersUpdate[6].Value = model.SummaryBody; parametersUpdate[7].Value = model.PatientSituation; parametersUpdate[8].Value = model.MedicalAdvice; if (model.ECGImage == null) { parametersUpdate[9].Value = DBNull.Value; } else { parametersUpdate[9].Value = model.ECGImage; } parametersUpdate[10].Value = model.Physicians; parametersUpdate[11].Value = model.EmployeeID; parametersUpdate[12].Value = model.YearMonth; return OleDbHelper.ExecuteSql(Update_SQL, parametersUpdate); }