OleDbDAL/DAL_Employee.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_Employee : IDAL_Employee
    {
        private string Add_SQL = @"Insert into Employee(
			CREATE_DATETIME,UPDATE_DATETIME,TRANS_STATE,UPDATER_ID,TERMINAL_CD,EmployeeID,EmployeeName,EmployeeSex,EmployeeBirthday,EmployeeWHCD,EmployeeHF,EmployeeJG,EmployeeXJD,EmployeeBM,EmployeeDW,EmployeeJWBS,EmployeeGZID,EmployeePWD,EmployeeEmail,EmployeePhone)
			Values (
			FORMAT(date(),'YYYYMMDD')+FORMAT(TIME(),'HHMMSS'),FORMAT(date(),'YYYYMMDD')+FORMAT(TIME(),'HHMMSS'),'1',@UPDATER_ID,@TERMINAL_CD,@EmployeeID,@EmployeeName,@EmployeeSex,@EmployeeBirthday,@EmployeeWHCD,@EmployeeHF,@EmployeeJG,@EmployeeXJD,@EmployeeBM,@EmployeeDW,@EmployeeJWBS,@EmployeeGZID,@EmployeePWD,@EmployeeEmail,@EmployeePhone)";
        private string UpdateEmployeePWD = @"Update Employee Set 
UPDATE_DATETIME=FORMAT(date(),'YYYYMMDD')+FORMAT(TIME(),'HHMMSS'),
TRANS_STATE='2',
UPDATER_ID=@UPDATER_ID,
TERMINAL_CD=@TERMINAL_CD,
EmployeePWD=@EmployeePWD,
EmployeeEmail=@EmployeeEmail,
EmployeePhone=@EmployeePhone
Where EmployeeID=@EmployeeID";
        private string Search_SQL = @"Select Employee.UPDATER_ID
,Employee.TERMINAL_CD
,Employee.EmployeeID
,Employee.EmployeeGZID
,Employee.EmployeeName
,Switch(Employee.EmployeeSex = '0','男',Employee.EmployeeSex = '1','女',True,'') AS EmpSex
,Employee.EmployeeBirthday
,Employee.EmployeeWHCD
,Employee.EmployeeHF
,Employee.EmployeeJG
,Employee.EmployeeXJD
,Department.Name as EmployeeBM
,Employee.EmployeeDW
,Employee.EmployeeJWBS 
FROM Employee Left Join Department On Department.ID = Employee.EmployeeBM ";
        private string SearchEmployeeID_SQL = @"Select EmployeeID From Employee where EmployeeID = @EmployeeID";
        private string UpdateEmployee_SQL = @"Update Employee Set 
UPDATE_DATETIME=FORMAT(date(),'YYYYMMDD')+FORMAT(TIME(),'HHMMSS'),
TRANS_STATE='2',
UPDATER_ID=@UPDATER_ID,
TERMINAL_CD=@TERMINAL_CD,
EmployeeName=@EmployeeName,
EmployeeSex=@EmployeeSex,
EmployeeBirthday=@EmployeeBirthday,
EmployeeWHCD=@EmployeeWHCD,
EmployeeHF=@EmployeeHF,
EmployeeJG=@EmployeeJG,
EmployeeXJD=@EmployeeXJD,
EmployeeBM=@EmployeeBM,
EmployeeDW=@EmployeeDW,
EmployeeJWBS=@EmployeeJWBS,
EmployeeGZID=@EmployeeGZID,
EmployeePWD=@EmployeePWD,