Beispiel #1
0
 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;
 }
Beispiel #2
0
 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);
 }
Beispiel #3
0
 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);
 }
Beispiel #4
0
 public ReturnValue AddUpdateBiochemistry(Biochemistry model)
 {
     BLL_Biochemistry bll = new BLL_Biochemistry();
     return bll.AddUpdate(model);
 }