OleDbDAL/DAL_Surgery.cs

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

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

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

namespace XTHospital.OleDbDAL
{
    public class DAL_Surgery : IDAL_Surgery
    {
        private string SearchID_SQL = @"Select EmployeeID From Surgery
Where EmployeeID=@EmployeeID And YearMoth=@YearMonth";
        private string Add_SQL = @"Insert Into Surgery(
CREATE_DATETIME,UPDATE_DATETIME,TRANS_STATE,UPDATER_ID,TERMINAL_CD,EmployeeID,YearMoth,Length,Bust,Weight,BadBreath,Skin,Lymphoid,Thyroid,Spine,Limbs,Joint,Flatfoot,Genitourinary,Anal,Hernia,Other,MedicalAdvice,Physicians)
Values (
FORMAT(date(),'YYYYMMDD')+FORMAT(TIME(),'HHMMSS'),FORMAT(date(),'YYYYMMDD')+FORMAT(TIME(),'HHMMSS'),'1',@UPDATER_ID,@TERMINAL_CD,@EmployeeID,@YearMonth,@Length,@Bust,@Weight,@BadBreath,@Skin,@Lymphoid,@Thyroid,@Spine,@Limbs,@Joint,@Flatfoot,@Genitourinary,@Anal,@Hernia,@Other,@MedicalAdvice,@Physicians)";
        private string Update_SQL = @"Update Surgery Set 
TRANS_STATE='2',
UPDATER_ID=@UPDATER_ID,
TERMINAL_CD=@TERMINAL_CD,
Length=@Length,
Bust=@Bust,
Weight=@Weight,
BadBreath=@BadBreath,
Skin=@Skin,
Lymphoid=@Lymphoid,
Thyroid=@Thyroid,
Spine=@Spine,
Limbs=@Limbs,
Joint=@Joint,
Flatfoot=@Flatfoot,
Genitourinary=@Genitourinary,
Anal=@Anal,
Hernia=@Hernia,
Other=@Other,
MedicalAdvice=@MedicalAdvice,
Physicians=@Physicians
Where EmployeeID=@EmployeeID And YearMoth=@YearMonth ";

        public ReturnValue Add(Surgery model)
        {
            OleDbParameter[] parameters = {
					new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12),
					new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar),
					new OleDbParameter("@EmployeeID", OleDbType.VarWChar,18),
					new OleDbParameter("@YearMonth", OleDbType.VarWChar,6),
					new OleDbParameter("@Length", OleDbType.VarWChar,8),
					new OleDbParameter("@Bust", OleDbType.VarWChar,8),
					new OleDbParameter("@Weight", OleDbType.VarWChar,8),
					new OleDbParameter("@BadBreath", OleDbType.VarWChar,50),
					new OleDbParameter("@Skin", OleDbType.VarWChar,128),
					new OleDbParameter("@Lymphoid", OleDbType.VarWChar,128),
					new OleDbParameter("@Thyroid", OleDbType.VarWChar,128),
					new OleDbParameter("@Spine", OleDbType.VarWChar,128),
					new OleDbParameter("@Limbs", OleDbType.VarWChar,128),
					new OleDbParameter("@Joint", OleDbType.VarWChar,128),