DAL/DAL_Bexamination.cs

（开头部分） 5KB

这里只显示每个文件的开头 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_Bexamination :IDAL_Bexamination
    {
        private string SearchID_SQL = @"Select EmployeeID From Bexamination
Where EmployeeID=@EmployeeID And YearMonth=@YearMonth";
        private string Add_SQL = @"Insert Into Bexamination(
CREATE_DATETIME,UPDATE_DATETIME,TRANS_STATE,UPDATER_ID,TERMINAL_CD,EmployeeID,YearMonth,BID,HistorySigns,LaboratoryExamination,Diagnosis,Purpose,Results,BImage,Physicians)
Values (
CONVERT(VARCHAR,GETDATE(),112)+REPLACE(CONVERT(VARCHAR,GETDATE(),108),':',''),CONVERT(VARCHAR,GETDATE(),112)+REPLACE(CONVERT(VARCHAR,GETDATE(),108),':',''),'1',@UPDATER_ID,@TERMINAL_CD,@EmployeeID,@YearMonth,@BID,@HistorySigns,@LaboratoryExamination,@Diagnosis,@Purpose,@Results,@BImage,@Physicians)";
        private string Update_SQL = @"Update Bexamination Set 
TRANS_STATE='2',
UPDATER_ID=@UPDATER_ID,
TERMINAL_CD=@TERMINAL_CD,
BID=@BID,
HistorySigns=@HistorySigns,
LaboratoryExamination=@LaboratoryExamination,
Diagnosis=@Diagnosis,
Purpose=@Purpose,
Results=@Results,
BImage=@BImage,
Physicians=@Physicians
Where EmployeeID=@EmployeeID and YearMonth=@YearMonth ";

        public ReturnValue Add(Bexamination 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("@BID", SqlDbType.NVarChar,10),
					new SqlParameter("@HistorySigns", SqlDbType.NVarChar,256),
					new SqlParameter("@LaboratoryExamination", SqlDbType.NVarChar,256),
					new SqlParameter("@Diagnosis", SqlDbType.NVarChar,256),
					new SqlParameter("@Purpose", SqlDbType.NVarChar,256),
					new SqlParameter("@Results", SqlDbType.NVarChar,256),
					new SqlParameter("@BImage", 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.BID;
            parameters[5].Value = model.HistorySigns;
            parameters[6].Value = model.LaboratoryExamination;
            parameters[7].Value = model.Diagnosis;
            parameters[8].Value = model.Purpose;
            parameters[9].Value = model.Results;
            if (model.BImage == null)
后面还有 59 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。