DAL/DAL_Biochemistry.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using XTHospital.IDAL;
using XTHospital.DB;
using XTHospital.Model;
using XTHospital.COM;

namespace XTHospital.DAL
{
    public class DAL_Biochemistry : IDAL_Biochemistry
    {
        private string SearchID_SQL = @"Select EmployeeID From Biochemistry
Where EmployeeID=@EmployeeID And YearMonth=@YearMonth";
        private string Add_SQL = @"Insert into Biochemistry(
CREATE_DATETIME,UPDATE_DATETIME,TRANS_STATE,UPDATER_ID,TERMINAL_CD,EmployeeID,YearMoth,HYNo,HYDr,HYTC,HYTG,HYHDLC,HYTBIL,HYDBIL,HYTP,HYALB,HYALT,HYHBsAg,HYHBsAb,HYHBeAg,HYHBeAb,HYHBcAb,HY_GLU,HY_UREA,HY_CR,HY_AFP,HY_CEA)
Values (
'yyyyMMddhhmmss','yyyyMMddhhmmss','1',@UPDATER_ID,@TERMINAL_CD,@EmployeeID,@YearMonth,@HYNo,@HYDr,@HYTC,@HYTG,@HYHDLC,@HYTBIL,@HYDBIL,@HYTP,@HYALB,@HYALT,@HYHBsAg,@HYHBsAb,@HYHBeAg,@HYHBeAb,@HYHBcAb,@HY_GLU,@HY_UREA,@HY_CR,@HY_AFP,@HY_CEA)";
        private string Update_SQL = @"Update Biochemistry Set 
UPDATE_DATETIME='yyyyMMddhhmmss',
TRANS_STATE='2',
UPDATER_ID=@UPDATER_ID,
TERMINAL_CD=@TERMINAL_CD,
HYNo=@HYNo,
HYDr=@HYDr,
HYTC=@HYTC,
HYTG=@HYTG,
HYHDLC=@HYHDLC,
HYTBIL=@HYTBIL,
HYDBIL=@HYDBIL,
HYTP=@HYTP,
HYALB=@HYALB,
HYALT=@HYALT,
HYHBsAg=@HYHBsAg,
HYHBsAb=@HYHBsAb,
HYHBeAg=@HYHBeAg,
HYHBeAb=@HYHBeAb,
HYHBcAb=@HYHBcAb,
HY_GLU=@HY_GLU,
HY_UREA=@HY_UREA,
HY_CR=@HY_CR,
HY_AFP=@HY_AFP,
HY_CEA=@HY_CEA
where EmployeeID=@EmployeeID and YearMoth=@YearMonth ";

        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),