public ReturnValue AddUpdate(Biochemistry model) { ReturnValue resoult = dalBiochemistry.Search(model.EmployeeID,model.YearMonth); if (!resoult.ErrorFlag) { return resoult; } if (resoult.Count > 0) { resoult = dalBiochemistry.Update(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID+" 的生化检验信息", "1", model.TERMINAL_CD); } } else { resoult = dalBiochemistry.Add(model); if (resoult.ErrorFlag) { BLL_Log.AddLog(model.UPDATER_ID + " 添加了用户 " + model.EmployeeID+" 的生化检验信息", "1", model.TERMINAL_CD); } } return resoult; }
public ReturnValue Add(Biochemistry model) { SqlParameter[] parameters = { new SqlParameter("@UPDATER_ID", SqlDbType.NVarChar,12), new SqlParameter("@TERMINAL_CD", SqlDbType.NVarChar,256), new SqlParameter("@EmployeeID", SqlDbType.NVarChar,256), new SqlParameter("@YearMonth", SqlDbType.NVarChar,6), new SqlParameter("@HYNo", SqlDbType.NVarChar,10), new SqlParameter("@HYDr", SqlDbType.NVarChar,50), new SqlParameter("@HYTC", SqlDbType.NVarChar,10), new SqlParameter("@HYTG", SqlDbType.NVarChar,10), new SqlParameter("@HYHDLC", SqlDbType.NVarChar,10), new SqlParameter("@HYTBIL", SqlDbType.NVarChar,10), new SqlParameter("@HYDBIL", SqlDbType.NVarChar,10), new SqlParameter("@HYTP", SqlDbType.NVarChar,10), new SqlParameter("@HYALB", SqlDbType.NVarChar,10), new SqlParameter("@HYALT", SqlDbType.NVarChar,10), new SqlParameter("@HYHBsAg", SqlDbType.NVarChar,1), new SqlParameter("@HYHBsAb", SqlDbType.NVarChar,1), new SqlParameter("@HYHBeAg", SqlDbType.NVarChar,1), new SqlParameter("@HYHBeAb", SqlDbType.NVarChar,1), new SqlParameter("@HYHBcAb", SqlDbType.NVarChar,1), new SqlParameter("@HY_GLU", SqlDbType.NVarChar,10), new SqlParameter("@HY_UREA", SqlDbType.NVarChar,10), new SqlParameter("@HY_CR", SqlDbType.NVarChar,10), new SqlParameter("@HY_AFP", SqlDbType.NVarChar,10), new SqlParameter("@HY_CEA", SqlDbType.NVarChar,10)}; 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.HYNo; parameters[5].Value = model.HYDr; parameters[6].Value = model.HYTC; parameters[7].Value = model.HYTG; parameters[8].Value = model.HYHDLC; parameters[9].Value = model.HYTBIL; parameters[10].Value = model.HYDBIL; parameters[11].Value = model.HYTP; parameters[12].Value = model.HYALB; parameters[13].Value = model.HYALT; parameters[14].Value = model.HYHBsAg; parameters[15].Value = model.HYHBsAb; parameters[16].Value = model.HYHBeAg; parameters[17].Value = model.HYHBeAb; parameters[18].Value = model.HYHBcAb; parameters[19].Value = model.HY_GLU; parameters[20].Value = model.HY_UREA; parameters[21].Value = model.HY_CR; parameters[22].Value = model.HY_AFP; parameters[23].Value = model.HY_CEA; return SqlHelper.ExecuteSql(Add_SQL, parameters); }
public ReturnValue Add(Biochemistry model) { OleDbParameter[] parameters = { new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12), new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar), new OleDbParameter("@EmployeeID", OleDbType.LongVarWChar), new OleDbParameter("@YearMonth", OleDbType.VarWChar,6), new OleDbParameter("@HYNo", OleDbType.VarWChar,10), new OleDbParameter("@HYDr", OleDbType.VarWChar,50), new OleDbParameter("@HYTC", OleDbType.VarWChar,50), new OleDbParameter("@HYTG", OleDbType.VarWChar,50), new OleDbParameter("@HYHDLC", OleDbType.VarWChar,50), new OleDbParameter("@HYTBIL", OleDbType.VarWChar,50), new OleDbParameter("@HYDBIL", OleDbType.VarWChar,50), new OleDbParameter("@HYTP", OleDbType.VarWChar,50), new OleDbParameter("@HYALB", OleDbType.VarWChar,50), new OleDbParameter("@HYALT", OleDbType.VarWChar,50), new OleDbParameter("@HYHBsAg", OleDbType.VarWChar,1), new OleDbParameter("@HYHBsAb", OleDbType.VarWChar,1), new OleDbParameter("@HYHBeAg", OleDbType.VarWChar,1), new OleDbParameter("@HYHBeAb", OleDbType.VarWChar,1), new OleDbParameter("@HYHBcAb", OleDbType.VarWChar,1), new OleDbParameter("@HY_GLU", OleDbType.VarWChar,50), new OleDbParameter("@HY_UREA", OleDbType.VarWChar,50), new OleDbParameter("@HY_CR", OleDbType.VarWChar,50), new OleDbParameter("@HY_AFP", OleDbType.VarWChar,50), new OleDbParameter("@HY_CEA", OleDbType.VarWChar,50), new OleDbParameter("@HYLDLC", OleDbType.VarWChar,50), new OleDbParameter("@HYAPOAI", OleDbType.VarWChar,50), new OleDbParameter("@HYAPOB", OleDbType.VarWChar,50), new OleDbParameter("@HYAST", OleDbType.VarWChar,50), new OleDbParameter("@HYGT", OleDbType.VarWChar,50), new OleDbParameter("@HYALP", OleDbType.VarWChar,50), new OleDbParameter("@HYUA", 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.HYNo; parameters[5].Value = model.HYDr; parameters[6].Value = model.HYTC; parameters[7].Value = model.HYTG; parameters[8].Value = model.HYHDLC; parameters[9].Value = model.HYTBIL; parameters[10].Value = model.HYDBIL; parameters[11].Value = model.HYTP; parameters[12].Value = model.HYALB; parameters[13].Value = model.HYALT; parameters[14].Value = model.HYHBsAg; parameters[15].Value = model.HYHBsAb; parameters[16].Value = model.HYHBeAg; parameters[17].Value = model.HYHBeAb; parameters[18].Value = model.HYHBcAb; parameters[19].Value = model.HY_GLU; parameters[20].Value = model.HY_UREA; parameters[21].Value = model.HY_CR; parameters[22].Value = model.HY_AFP; parameters[23].Value = model.HY_CEA; parameters[24].Value = model.HYLDLC; parameters[25].Value = model.HYAPOAI; parameters[26].Value = model.HYAPOB; parameters[27].Value = model.HYAST; parameters[28].Value = model.HYGT; parameters[29].Value = model.HYALP; parameters[30].Value = model.HYUA; return OleDbHelper.ExecuteSql(Add_SQL, parameters); }
public ReturnValue AddUpdateBiochemistry(Biochemistry model) { BLL_Biochemistry bll = new BLL_Biochemistry(); return bll.AddUpdate(model); }