sryang/thinkyu
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
thinkyu/Web/App_Code/DAC/SsmsDAC.cs
T
sryang 439e941268 feat: fmSendSalaryStrip GridView 改用 ObjectDataSource 
- SsmsDAC 新增 SelectSalaryStrip/SelectSalaryStripSum

- dsSSMS 改 ObjectDataSource；dsSSMSSum 移除，footer 改用 SsmsDAC
2026-09-10 11:04:33 +08:00

1112 lines
59 KiB
C#
Raw Permalink Blame History

using System;
using System.Data;
using System.Data.Common;
using System.ComponentModel;
using System.Text;
using Wellan.Data;
using Wellan.Common;
using System.Data.SqlClient;
[DataObject(true)]
public class SsmsDAC : Wellan.Data.WDAC
{
private DbCommand cmdSelectSSMS;
private DbCommand cmdInsertSSMS;
private DbCommand cmdUpdateSSMS;
private DbCommand cmdDeleteSSMS;
private DbCommand cmdDeleteOneSSMS;
private string _trusr = "X001";
public SsmsDAC()
{
cmdSelectSSMS = Query.NewCommand(
@"SELECT
SSYMM, SSENO, SSNUM, SSPYN, SSITM, SSJNO, SSCNO, SSBRH, SSD01, SSD02, SSSRD,
SSP00, SSP01, SSP02, SSP03, SSP04, SSP05, SSP06, SSP07, SSP08, SSP09, SSP10,
SSP11, SSP12, SSP13, SSP14, SSP15, SSP99, SSS01, SSS02, SSS03, SSS04, SSS05,
SSS06, SSS07, SSS08, SSS09, SSS10, SSS11, SSS12, SSS13, SSS14, SSS15, SSS99,
SSH01, SSH02, SSH03, SSH04, SSH05, SSH06, SSH07, SSH08, SSH09, SSH10, SST01,
SST02, SST03, SST04, SST05, SST06, SST07, SST08, SST09, SST10, SST11, SST12,
SST13, SST14, SST15, SST16, SST17, SST18, SST19, SST20, SST21, SST22, SST13,
SST14, SST15, SSL01, SSL02, SSL03, SSL04, SSL05, SSC01, SSC02, SSC03, SSC04,
SSC05, SSC06, SSC07, SSC08, SSC09, SSC10
FROM dbo.SSMS
WHERE SSYMM=@SSYMM
AND SSENO=@SSENO
AND SSPYN=@SSPYN
AND SSITM=@SSITM");
cmdSelectSSMS.Parameters.Add(Query.NewParameter("SSYMM", DbType.DateTime));
cmdSelectSSMS.Parameters.Add(Query.NewParameter("SSENO", DbType.String));
cmdSelectSSMS.Parameters.Add(Query.NewParameter("SSPYN", DbType.String));
cmdSelectSSMS.Parameters.Add(Query.NewParameter("SSITM", DbType.String));
cmdInsertSSMS = Query.NewCommand(
@"INSERT INTO dbo.SSMS
(SSYMM, SSENO, SSNUM, SSPYN, SSITM, SSJNO, SSCNO, SSBRH, SSD01, SSD02, SSSRD,
SSP00, SSP01, SSP02, SSP03, SSP04, SSP05, SSP06, SSP07, SSP08, SSP09, SSP10,
SSP11, SSP12, SSP13, SSP14, SSP15, SSP99, SSS01, SSS02, SSS03, SSS04, SSS05,
SSS06, SSS07, SSS08, SSS09, SSS10, SSS11, SSS12, SSS13, SSS14, SSS15, SSS99,
SSH01, SSH02, SSH03, SSH04, SSH05, SSH06, SSH07, SSH08, SSH09, SSH10, SST01,
SST02, SST03, SST04, SST05, SST06, SST07, SST08, SST09, SST10, SST11, SST12,
SST13, SST14, SST15, SST16, SST17, SST18, SST19, SST20, SST21, SST22, SST23,
SST24, SST25, SSL01, SSL02, SSL03, SSL04, SSL05, SSC01, SSC02, SSC03, SSC04,
SSC05, SSC06, SSC07, SSC08, SSC09, SSC10, TRDAT, TRMOD, TRUSR)
VALUES
(@SSYMM, @SSENO, @SSNUM, @SSPYN, @SSITM, @SSJNO, @SSCNO, @SSBRH, @SSD01, @SSD02, @SSSRD,
@SSP00, @SSP01, @SSP02, @SSP03, @SSP04, @SSP05, @SSP06, @SSP07, @SSP08, @SSP09, @SSP10,
@SSP11, @SSP12, @SSP13, @SSP14, @SSP15, @SSP99, @SSS01, @SSS02, @SSS03, @SSS04, @SSS05,
@SSS06, @SSS07, @SSS08, @SSS09, @SSS10, @SSS11, @SSS12, @SSS13, @SSS14, @SSS15, @SSS99,
@SSH01, @SSH02, @SSH03, @SSH04, @SSH05, @SSH06, @SSH07, @SSH08, @SSH09, @SSH10, @SST01,
@SST02, @SST03, @SST04, @SST05, @SST06, @SST07, @SST08, @SST09, @SST10, @SST11, @SST12,
@SST13, @SST14, @SST15, @SST16, @SST17, @SST18, @SST19, @SST20, @SST21, @SST22, @SST23,
@SST24, @SST25, @SSL01, @SSL02, @SSL03, @SSL04, @SSL05, @SSC01, @SSC02, @SSC03, @SSC04,
@SSC05, @SSC06, @SSC07, @SSC08, @SSC09, @SSC10, GETDATE(), 'INSERT', @TRUSR)");
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSYMM", DbType.DateTime));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSENO", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSNUM", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSPYN", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSITM", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSJNO", DbType.AnsiString));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSCNO", DbType.AnsiString));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSBRH", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSD01", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSD02", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSSRD", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP00", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP01", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP02", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP03", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP04", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP05", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP06", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP07", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP08", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP09", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP10", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP11", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP12", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP13", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP14", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP15", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSP99", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS01", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS02", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS03", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS04", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS05", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS06", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS07", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS08", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS09", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS10", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS11", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS12", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS13", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS14", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS15", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSS99", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH01", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH02", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH03", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH04", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH05", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH06", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH07", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH08", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH09", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSH10", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST01", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST02", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST03", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST04", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST05", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST06", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST07", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST08", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST09", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST10", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST11", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST12", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST13", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST14", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST15", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST16", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST17", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST18", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST19", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST20", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST21", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST22", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST23", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST24", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SST25", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSL01", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSL02", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSL03", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSL04", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSL05", DbType.Int32));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC01", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC02", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC03", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC04", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC05", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC06", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC07", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC08", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC09", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("SSC10", DbType.String));
cmdInsertSSMS.Parameters.Add(Query.NewParameter("TRUSR", DbType.String));
cmdUpdateSSMS = Query.NewCommand(
@"UPDATE dbo.SSMS SET
SSNUM=@SSNUM, SSJNO=@SSJNO,
SSCNO=@SSCNO, SSBRH=@SSBRH, SSD01=@SSD01, SSD02=@SSD02, SSSRD=@SSSRD,
SSP00=@SSP00, SSP01=@SSP01, SSP02=@SSP02, SSP03=@SSP03, SSP04=@SSP04,
SSP05=@SSP05, SSP06=@SSP06, SSP07=@SSP07, SSP08=@SSP08, SSP09=@SSP09,
SSP10=@SSP10, SSP11=@SSP11, SSP12=@SSP12, SSP13=@SSP13, SSP14=@SSP14,
SSP15=@SSP15, SSP99=@SSP99, SSS01=@SSS01, SSS02=@SSS02, SSS03=@SSS03,
SSS04=@SSS04, SSS05=@SSS05, SSS06=@SSS06, SSS07=@SSS07, SSS08=@SSS08,
SSS09=@SSS09, SSS10=@SSS10, SSS11=@SSS11, SSS12=@SSS12, SSS13=@SSS13,
SSS14=@SSS14, SSS15=@SSS15, SSS99=@SSS99, SSH01=@SSH01, SSH02=@SSH02,
SSH03=@SSH03, SSH04=@SSH04, SSH05=@SSH05, SSH06=@SSH06, SSH07=@SSH07,
SSH08=@SSH08, SSH09=@SSH09, SSH10=@SSH10, SST01=@SST01, SST02=@SST02,
SST03=@SST03, SST04=@SST04, SST05=@SST05, SST06=@SST06, SST07=@SST07,
SST08=@SST08, SST09=@SST09, SST10=@SST10, SST11=@SST11, SST12=@SST12,
SST13=@SST13, SST14=@SST14, SST15=@SST15, SST16=@SST16, SST17=@SST17,
SST18=@SST18, SST19=@SST19, SST20=@SST20, SST21=@SST21, SST22=@SST22,
SST23=@SST23, SST24=@SST24, SST25=@SST25, SSL01=@SSL01, SSL02=@SSL02,
SSL03=@SSL03, SSL04=@SSL04, SSL05=@SSL05, SSC01=@SSC01, SSC02=@SSC02,
SSC03=@SSC03, SSC04=@SSC04, SSC05=@SSC05, SSC06=@SSC06, SSC07=@SSC07,
SSC08=@SSC08, SSC09=@SSC09, SSC10=@SSC10, TRDAT=GETDATE(), TRMOD='UPDATE',
TRUSR=@TRUSR
WHERE SSYMM=@OLD_SSYMM
AND SSENO=@OLD_SSENO
AND SSPYN=@OLD_SSPYN
AND SSITM=@OLD_SSITM");
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSNUM", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSJNO", DbType.AnsiString));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSCNO", DbType.AnsiString));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSBRH", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSD01", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSD02", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSSRD", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP00", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP01", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP02", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP03", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP04", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP05", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP06", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP07", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP08", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP09", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP10", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP11", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP12", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP13", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP14", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP15", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSP99", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS01", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS02", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS03", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS04", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS05", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS06", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS07", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS08", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS09", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS10", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS11", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS12", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS13", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS14", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS15", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSS99", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH01", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH02", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH03", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH04", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH05", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH06", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH07", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH08", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH09", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSH10", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST01", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST02", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST03", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST04", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST05", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST06", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST07", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST08", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST09", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST10", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST11", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST12", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST13", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST14", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST15", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST16", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST17", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST18", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST19", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST20", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST21", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST22", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST23", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST24", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SST25", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSL01", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSL02", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSL03", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSL04", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSL05", DbType.Int32));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC01", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC02", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC03", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC04", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC05", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC06", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC07", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC08", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC09", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("SSC10", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("TRUSR", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("OLD_SSYMM", DbType.DateTime));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("OLD_SSENO", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("OLD_SSPYN", DbType.String));
cmdUpdateSSMS.Parameters.Add(Query.NewParameter("OLD_SSITM", DbType.String));
cmdDeleteSSMS = Query.NewCommand(
@"DELETE FROM SSMS WHERE SSYMM=@SSYMM AND SSPYN=@SSPYN");
cmdDeleteSSMS.Parameters.Add(Query.NewParameter("SSYMM", DbType.DateTime));
cmdDeleteSSMS.Parameters.Add(Query.NewParameter("SSPYN", DbType.String));
cmdDeleteOneSSMS = Query.NewCommand(
@"DELETE FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN");
cmdDeleteOneSSMS.Parameters.Add(Query.NewParameter("SSYMM", DbType.DateTime));
cmdDeleteOneSSMS.Parameters.Add(Query.NewParameter("SSENO", DbType.String));
cmdDeleteOneSSMS.Parameters.Add(Query.NewParameter("SSPYN", DbType.String));
cmdDeleteOneSSMS.Parameters.Add(Query.NewParameter("SSITM", DbType.String));
}
public SsmsDAC(WQuery Query)
: this()
{
this._query = Query;
}
public string TRUSR
{
get
{
return _trusr;
}
set
{
_trusr = value;
}
}
public void InsertOne(DbTransaction tran, SsmsRecord newRecord)
{
if (tran != null)
{
cmdInsertSSMS.Connection = tran.Connection;
cmdInsertSSMS.Transaction = tran;
}
else if (_query != null)
{
cmdInsertSSMS.Connection = _query.NewConnection();
}
else
{
return;
}
cmdInsertSSMS.Parameters["SSYMM"].Value = newRecord.SSYMM; // 薪資月份
cmdInsertSSMS.Parameters["SSENO"].Value = newRecord.SSENO; // 人員編號
cmdInsertSSMS.Parameters["SSNUM"].Value = newRecord.SSNUM; // 客戶編號
cmdInsertSSMS.Parameters["SSPYN"].Value = newRecord.SSPYN; // 專案年度編號
cmdInsertSSMS.Parameters["SSITM"].Value = // 項次
WGuard1.WNextRen(newRecord.SSYMM, "SSMS", "SSITM", "<999>",
String.Format("SSYMM='{0:s}' AND SSENO='{1:s}' AND SSPYN='{2:s}'",
newRecord.SSYMM.ToString("yyyy/MM/dd", WGuard1.InvariantCulture),
newRecord.SSENO,
newRecord.SSPYN),
tran);
cmdInsertSSMS.Parameters["SSJNO"].Value = newRecord.SSJNO; // 職稱
cmdInsertSSMS.Parameters["SSCNO"].Value = newRecord.SSCNO; // 等級
cmdInsertSSMS.Parameters["SSBRH"].Value = newRecord.SSBRH; // 站別
cmdInsertSSMS.Parameters["SSD01"].Value = newRecord.SSD01; // 到職天數
cmdInsertSSMS.Parameters["SSD02"].Value = newRecord.SSD02; // 勞保到職天數
cmdInsertSSMS.Parameters["SSSRD"].Value = newRecord.SSSRD; // 時薪
cmdInsertSSMS.Parameters["SSP00"].Value = newRecord.SSP00; // 本薪
cmdInsertSSMS.Parameters["SSP01"].Value = newRecord.SSP01; // 全勤獎金
cmdInsertSSMS.Parameters["SSP02"].Value = newRecord.SSP02; // 伙食津貼
cmdInsertSSMS.Parameters["SSP03"].Value = newRecord.SSP03; // 職務加給
cmdInsertSSMS.Parameters["SSP04"].Value = newRecord.SSP04; // 派駐津貼
cmdInsertSSMS.Parameters["SSP05"].Value = newRecord.SSP05; // 其他津貼
cmdInsertSSMS.Parameters["SSP06"].Value = newRecord.SSP06; // 前二加班
cmdInsertSSMS.Parameters["SSP07"].Value = newRecord.SSP07; // 後二加班
cmdInsertSSMS.Parameters["SSP08"].Value = newRecord.SSP08; // 假日加班
cmdInsertSSMS.Parameters["SSP09"].Value = newRecord.SSP09; // 短差
cmdInsertSSMS.Parameters["SSP10"].Value = newRecord.SSP10; // 長差
cmdInsertSSMS.Parameters["SSP11"].Value = newRecord.SSP11; // 電話費
cmdInsertSSMS.Parameters["SSP12"].Value = newRecord.SSP12; // 油料費
cmdInsertSSMS.Parameters["SSP13"].Value = newRecord.SSP13; // 獎金
cmdInsertSSMS.Parameters["SSP14"].Value = newRecord.SSP14; // 加項14
cmdInsertSSMS.Parameters["SSP15"].Value = newRecord.SSP15; // 加項15
cmdInsertSSMS.Parameters["SSP99"].Value = newRecord.SSP99; // 其他加項
cmdInsertSSMS.Parameters["SSS01"].Value = newRecord.SSS01; // 病假扣款
cmdInsertSSMS.Parameters["SSS02"].Value = newRecord.SSS02; // 事假扣款
cmdInsertSSMS.Parameters["SSS03"].Value = newRecord.SSS03; // 所得稅
cmdInsertSSMS.Parameters["SSS04"].Value = newRecord.SSS04; // 勞保費
cmdInsertSSMS.Parameters["SSS05"].Value = newRecord.SSS05; // 健保費
cmdInsertSSMS.Parameters["SSS06"].Value = newRecord.SSS06; // 勞退自提
cmdInsertSSMS.Parameters["SSS07"].Value = newRecord.SSS07; // 福利金
cmdInsertSSMS.Parameters["SSS08"].Value = newRecord.SSS08; // 減項08
cmdInsertSSMS.Parameters["SSS09"].Value = newRecord.SSS09; // 減項09
cmdInsertSSMS.Parameters["SSS10"].Value = newRecord.SSS10; // 減項10
cmdInsertSSMS.Parameters["SSS11"].Value = newRecord.SSS11; // 減項11
cmdInsertSSMS.Parameters["SSS12"].Value = newRecord.SSS12; // 減項12
cmdInsertSSMS.Parameters["SSS13"].Value = newRecord.SSS13; // 減項13
cmdInsertSSMS.Parameters["SSS14"].Value = newRecord.SSS14; // 減項14
cmdInsertSSMS.Parameters["SSS15"].Value = newRecord.SSS15; // 減項15
cmdInsertSSMS.Parameters["SSS99"].Value = newRecord.SSS99; // 其他減項
cmdInsertSSMS.Parameters["SSH01"].Value = newRecord.SSH01; // 雇主勞保費
cmdInsertSSMS.Parameters["SSH02"].Value = newRecord.SSH02; // 職災保險
cmdInsertSSMS.Parameters["SSH03"].Value = newRecord.SSH03; // 就業保險
cmdInsertSSMS.Parameters["SSH04"].Value = newRecord.SSH04; // 工資墊償
cmdInsertSSMS.Parameters["SSH05"].Value = newRecord.SSH05; // 雇主健保費
cmdInsertSSMS.Parameters["SSH06"].Value = newRecord.SSH06; // 勞退提撥
cmdInsertSSMS.Parameters["SSH07"].Value = newRecord.SSH07; // 雇主07
cmdInsertSSMS.Parameters["SSH08"].Value = newRecord.SSH08; // 雇主08
cmdInsertSSMS.Parameters["SSH09"].Value = newRecord.SSH09; // 雇主09
cmdInsertSSMS.Parameters["SSH10"].Value = newRecord.SSH10; // 雇主10
cmdInsertSSMS.Parameters["SST01"].Value = newRecord.SST01; // 前二加班時數
cmdInsertSSMS.Parameters["SST02"].Value = newRecord.SST02; // 後二加班時數
cmdInsertSSMS.Parameters["SST03"].Value = newRecord.SST03; // 假日加班時數
cmdInsertSSMS.Parameters["SST04"].Value = newRecord.SST04; // 累積補休時數
cmdInsertSSMS.Parameters["SST05"].Value = newRecord.SST05; // 補休時數
cmdInsertSSMS.Parameters["SST06"].Value = newRecord.SST06; // 特休時數
cmdInsertSSMS.Parameters["SST07"].Value = newRecord.SST07; // 事假時數
cmdInsertSSMS.Parameters["SST08"].Value = newRecord.SST08; // 病假時數
cmdInsertSSMS.Parameters["SST09"].Value = newRecord.SST09; // 喪假時數
cmdInsertSSMS.Parameters["SST10"].Value = newRecord.SST10; // 產假時數
cmdInsertSSMS.Parameters["SST11"].Value = newRecord.SST11; // 婚假時數
cmdInsertSSMS.Parameters["SST12"].Value = newRecord.SST12; // 陪產假時數
cmdInsertSSMS.Parameters["SST13"].Value = newRecord.SST13; // 公假時數
cmdInsertSSMS.Parameters["SST14"].Value = newRecord.SST14; // 公傷假時數
cmdInsertSSMS.Parameters["SST15"].Value = newRecord.SST15; // 生理假時數
cmdInsertSSMS.Parameters["SST16"].Value = newRecord.SST16; // 家庭照顧假時數
cmdInsertSSMS.Parameters["SST17"].Value = newRecord.SST17; // 育嬰假時數
cmdInsertSSMS.Parameters["SST18"].Value = newRecord.SST18; // 時數18
cmdInsertSSMS.Parameters["SST19"].Value = newRecord.SST19; // 時數19
cmdInsertSSMS.Parameters["SST20"].Value = newRecord.SST20; // 時數20
cmdInsertSSMS.Parameters["SST21"].Value = newRecord.SST21; // 時數21
cmdInsertSSMS.Parameters["SST22"].Value = newRecord.SST22; // 時數22
cmdInsertSSMS.Parameters["SST23"].Value = newRecord.SST23; // 時數23
cmdInsertSSMS.Parameters["SST24"].Value = newRecord.SST24; // 時數24
cmdInsertSSMS.Parameters["SST25"].Value = newRecord.SST25; // 時數25
cmdInsertSSMS.Parameters["SSL01"].Value = newRecord.SSL01; // 勞保投保等級
cmdInsertSSMS.Parameters["SSL02"].Value = newRecord.SSL02; // 健保投保等級
cmdInsertSSMS.Parameters["SSL03"].Value = newRecord.SSL03; // 勞退提撥等級
cmdInsertSSMS.Parameters["SSL04"].Value = newRecord.SSL04; // 等級04
cmdInsertSSMS.Parameters["SSL05"].Value = newRecord.SSL05; // 等級05
cmdInsertSSMS.Parameters["SSC01"].Value = newRecord.SSC01; // 請假備註
cmdInsertSSMS.Parameters["SSC02"].Value = newRecord.SSC02; // 加班備註
cmdInsertSSMS.Parameters["SSC03"].Value = newRecord.SSC03; // 電話費備註
cmdInsertSSMS.Parameters["SSC04"].Value = newRecord.SSC04; // 油料費備註
cmdInsertSSMS.Parameters["SSC05"].Value = newRecord.SSC05; // 差勤備註
cmdInsertSSMS.Parameters["SSC06"].Value = newRecord.SSC06; // 薪資加減備註
cmdInsertSSMS.Parameters["SSC07"].Value = newRecord.SSC07; // 備註07
cmdInsertSSMS.Parameters["SSC08"].Value = newRecord.SSC08; // 備註08
cmdInsertSSMS.Parameters["SSC09"].Value = newRecord.SSC09; // 備註09
cmdInsertSSMS.Parameters["SSC10"].Value = newRecord.SSC10; // 備註10
cmdInsertSSMS.Parameters["TRUSR"].Value = _trusr;
cmdInsertSSMS.ExecuteNonQuery();
}
public void UpdateOne(DbTransaction tran, SsmsRecord record)
{
if (tran != null)
{
cmdUpdateSSMS.Connection = tran.Connection;
cmdUpdateSSMS.Transaction = tran;
}
else if (_query != null)
{
cmdUpdateSSMS.Connection = _query.NewConnection();
}
else
{
return;
}
cmdUpdateSSMS.Parameters["OLD_SSYMM"].Value = record.SSYMM; // 薪資月份
cmdUpdateSSMS.Parameters["OLD_SSENO"].Value = record.SSENO; // 人員編號
cmdUpdateSSMS.Parameters["OLD_SSPYN"].Value = record.SSPYN; // 專案年度編號
cmdUpdateSSMS.Parameters["OLD_SSITM"].Value = record.SSITM; // 項次
cmdUpdateSSMS.Parameters["SSNUM"].Value = record.SSNUM; // 客戶編號
cmdUpdateSSMS.Parameters["SSJNO"].Value = record.SSJNO; // 職稱
cmdUpdateSSMS.Parameters["SSCNO"].Value = record.SSCNO; // 等級
cmdUpdateSSMS.Parameters["SSBRH"].Value = record.SSBRH; // 站別
cmdUpdateSSMS.Parameters["SSD01"].Value = record.SSD01; // 到職天數
cmdUpdateSSMS.Parameters["SSD02"].Value = record.SSD02; // 勞保到職天數
cmdUpdateSSMS.Parameters["SSSRD"].Value = record.SSSRD; // 時薪
cmdUpdateSSMS.Parameters["SSP00"].Value = record.SSP00; // 本薪
cmdUpdateSSMS.Parameters["SSP01"].Value = record.SSP01; // 全勤獎金
cmdUpdateSSMS.Parameters["SSP02"].Value = record.SSP02; // 伙食津貼
cmdUpdateSSMS.Parameters["SSP03"].Value = record.SSP03; // 職務加給
cmdUpdateSSMS.Parameters["SSP04"].Value = record.SSP04; // 派駐津貼
cmdUpdateSSMS.Parameters["SSP05"].Value = record.SSP05; // 其他津貼
cmdUpdateSSMS.Parameters["SSP06"].Value = record.SSP06; // 前二加班
cmdUpdateSSMS.Parameters["SSP07"].Value = record.SSP07; // 後二加班
cmdUpdateSSMS.Parameters["SSP08"].Value = record.SSP08; // 假日加班
cmdUpdateSSMS.Parameters["SSP09"].Value = record.SSP09; // 短差
cmdUpdateSSMS.Parameters["SSP10"].Value = record.SSP10; // 長差
cmdUpdateSSMS.Parameters["SSP11"].Value = record.SSP11; // 電話費
cmdUpdateSSMS.Parameters["SSP12"].Value = record.SSP12; // 油料費
cmdUpdateSSMS.Parameters["SSP13"].Value = record.SSP13; // 加項13
cmdUpdateSSMS.Parameters["SSP14"].Value = record.SSP14; // 加項14
cmdUpdateSSMS.Parameters["SSP15"].Value = record.SSP15; // 加項15
cmdUpdateSSMS.Parameters["SSP99"].Value = record.SSP99; // 其他加項
cmdUpdateSSMS.Parameters["SSS01"].Value = record.SSS01; // 病假扣款
cmdUpdateSSMS.Parameters["SSS02"].Value = record.SSS02; // 事假扣款
cmdUpdateSSMS.Parameters["SSS03"].Value = record.SSS03; // 所得稅
cmdUpdateSSMS.Parameters["SSS04"].Value = record.SSS04; // 勞保費
cmdUpdateSSMS.Parameters["SSS05"].Value = record.SSS05; // 健保費
cmdUpdateSSMS.Parameters["SSS06"].Value = record.SSS06; // 勞退自提
cmdUpdateSSMS.Parameters["SSS07"].Value = record.SSS07; // 福利金
cmdUpdateSSMS.Parameters["SSS08"].Value = record.SSS08; // 減項08
cmdUpdateSSMS.Parameters["SSS09"].Value = record.SSS09; // 減項09
cmdUpdateSSMS.Parameters["SSS10"].Value = record.SSS10; // 減項10
cmdUpdateSSMS.Parameters["SSS11"].Value = record.SSS11; // 減項11
cmdUpdateSSMS.Parameters["SSS12"].Value = record.SSS12; // 減項12
cmdUpdateSSMS.Parameters["SSS13"].Value = record.SSS13; // 減項13
cmdUpdateSSMS.Parameters["SSS14"].Value = record.SSS14; // 減項14
cmdUpdateSSMS.Parameters["SSS15"].Value = record.SSS15; // 減項15
cmdUpdateSSMS.Parameters["SSS99"].Value = record.SSS99; // 其他減項
cmdUpdateSSMS.Parameters["SSH01"].Value = record.SSH01; // 雇主勞保費
cmdUpdateSSMS.Parameters["SSH02"].Value = record.SSH02; // 職災保險
cmdUpdateSSMS.Parameters["SSH03"].Value = record.SSH03; // 就業保險
cmdUpdateSSMS.Parameters["SSH04"].Value = record.SSH04; // 工資墊償
cmdUpdateSSMS.Parameters["SSH05"].Value = record.SSH05; // 雇主健保費
cmdUpdateSSMS.Parameters["SSH06"].Value = record.SSH06; // 勞退提撥
cmdUpdateSSMS.Parameters["SSH07"].Value = record.SSH07; // 雇主07
cmdUpdateSSMS.Parameters["SSH08"].Value = record.SSH08; // 雇主08
cmdUpdateSSMS.Parameters["SSH09"].Value = record.SSH09; // 雇主09
cmdUpdateSSMS.Parameters["SSH10"].Value = record.SSH10; // 雇主10
cmdUpdateSSMS.Parameters["SST01"].Value = record.SST01; // 前二加班時數
cmdUpdateSSMS.Parameters["SST02"].Value = record.SST02; // 後二加班時數
cmdUpdateSSMS.Parameters["SST03"].Value = record.SST03; // 假日加班時數
cmdUpdateSSMS.Parameters["SST04"].Value = record.SST04; // 累積補休時數
cmdUpdateSSMS.Parameters["SST05"].Value = record.SST05; // 補休時數
cmdUpdateSSMS.Parameters["SST06"].Value = record.SST06; // 特休時數
cmdUpdateSSMS.Parameters["SST07"].Value = record.SST07; // 事假時數
cmdUpdateSSMS.Parameters["SST08"].Value = record.SST08; // 病假時數
cmdUpdateSSMS.Parameters["SST09"].Value = record.SST09; // 喪假時數
cmdUpdateSSMS.Parameters["SST10"].Value = record.SST10; // 產假時數
cmdUpdateSSMS.Parameters["SST11"].Value = record.SST11; // 婚假時數
cmdUpdateSSMS.Parameters["SST12"].Value = record.SST12; // 陪產假時數
cmdUpdateSSMS.Parameters["SST13"].Value = record.SST13; // 公假時數
cmdUpdateSSMS.Parameters["SST14"].Value = record.SST14; // 公傷假時數
cmdUpdateSSMS.Parameters["SST15"].Value = record.SST15; // 生理假時數
cmdUpdateSSMS.Parameters["SST16"].Value = record.SST16; // 家庭照顧假時數
cmdUpdateSSMS.Parameters["SST17"].Value = record.SST17; // 育嬰假時數
cmdUpdateSSMS.Parameters["SST18"].Value = record.SST18; // 時數18
cmdUpdateSSMS.Parameters["SST19"].Value = record.SST19; // 時數19
cmdUpdateSSMS.Parameters["SST20"].Value = record.SST20; // 時數20
cmdUpdateSSMS.Parameters["SST21"].Value = record.SST21; // 時數21
cmdUpdateSSMS.Parameters["SST22"].Value = record.SST22; // 時數22
cmdUpdateSSMS.Parameters["SST23"].Value = record.SST23; // 時數23
cmdUpdateSSMS.Parameters["SST24"].Value = record.SST24; // 時數24
cmdUpdateSSMS.Parameters["SST25"].Value = record.SST25; // 時數25
cmdUpdateSSMS.Parameters["SSL01"].Value = record.SSL01; // 勞保投保等級
cmdUpdateSSMS.Parameters["SSL02"].Value = record.SSL02; // 健保投保等級
cmdUpdateSSMS.Parameters["SSL03"].Value = record.SSL03; // 勞退提撥等級
cmdUpdateSSMS.Parameters["SSL04"].Value = record.SSL04; // 等級04
cmdUpdateSSMS.Parameters["SSL05"].Value = record.SSL05; // 等級05
cmdUpdateSSMS.Parameters["SSC01"].Value = record.SSC01; // 請假備註
cmdUpdateSSMS.Parameters["SSC02"].Value = record.SSC02; // 加班備註
cmdUpdateSSMS.Parameters["SSC03"].Value = record.SSC03; // 電話費備註
cmdUpdateSSMS.Parameters["SSC04"].Value = record.SSC04; // 油料費備註
cmdUpdateSSMS.Parameters["SSC05"].Value = record.SSC05; // 差勤備註
cmdUpdateSSMS.Parameters["SSC06"].Value = record.SSC06; // 薪資加減備註
cmdUpdateSSMS.Parameters["SSC07"].Value = record.SSC07; // 備註07
cmdUpdateSSMS.Parameters["SSC08"].Value = record.SSC08; // 備註08
cmdUpdateSSMS.Parameters["SSC09"].Value = record.SSC09; // 備註09
cmdUpdateSSMS.Parameters["SSC10"].Value = record.SSC10; // 備註10
cmdUpdateSSMS.Parameters["TRUSR"].Value = _trusr;
cmdUpdateSSMS.ExecuteNonQuery();
}
public void Delete(DbTransaction tran, DateTime aYYMM, string sspyn)
{
if (tran != null)
{
cmdDeleteSSMS.Connection = tran.Connection;
cmdDeleteSSMS.Transaction = tran;
}
else if (_query != null)
{
cmdDeleteSSMS.Connection = _query.NewConnection();
}
else
{
return;
}
cmdDeleteSSMS.Parameters["SSYMM"].Value = aYYMM;
cmdDeleteSSMS.Parameters["SSPYN"].Value = sspyn;
cmdDeleteSSMS.ExecuteNonQuery();
}
public void DeleteOne(DbTransaction tran, DateTime aYYMM, string sseno, string sspyn, string ssitm)
{
if (tran != null)
{
cmdDeleteOneSSMS.Connection = tran.Connection;
cmdDeleteOneSSMS.Transaction = tran;
}
else if (_query != null)
{
cmdDeleteOneSSMS.Connection = _query.NewConnection();
}
else
{
return;
}
cmdDeleteOneSSMS.Parameters["SSYMM"].Value = aYYMM;
cmdDeleteOneSSMS.Parameters["SSENO"].Value = sseno;
cmdDeleteOneSSMS.Parameters["SSPYN"].Value = sspyn;
cmdDeleteOneSSMS.Parameters["SSITM"].Value = ssitm;
cmdDeleteOneSSMS.ExecuteNonQuery();
}
public SsmsRecord SelectOne(DbTransaction tran, DateTime aYYMM, string sseno, string sspyn, string ssitm)
{
if (tran != null)
{
cmdSelectSSMS.Connection = tran.Connection;
cmdSelectSSMS.Transaction = tran;
}
else if (_query != null)
{
cmdSelectSSMS.Connection = _query.NewConnection();
}
else
{
return null;
}
cmdSelectSSMS.Parameters["SSYMM"].Value = aYYMM;
cmdSelectSSMS.Parameters["SSENO"].Value = sseno;
cmdSelectSSMS.Parameters["SSPYN"].Value = sspyn;
cmdSelectSSMS.Parameters["SSITM"].Value = ssitm;
SsmsRecord result = new SsmsRecord();
ConnectionState oldState = cmdSelectSSMS.Connection.State;
if (cmdSelectSSMS.Connection.State == ConnectionState.Closed)
cmdSelectSSMS.Connection.Open();
try
{
DbDataReader reader = cmdSelectSSMS.ExecuteReader();
if (reader.Read())
result.Fill(reader);
else
result = null;
reader.Close();
}
finally
{
if (oldState == ConnectionState.Closed && cmdSelectSSMS.Connection.State == ConnectionState.Open)
cmdSelectSSMS.Connection.Close();
}
return result;
}
private const string SelectSalaryStripSql =
@"SELECT A.*,
SSP06 + SSP07 + SSP08 + SSP13 + SSP14 OVERWORK,
SSP09 + SSP10 + SSP12 OUTGOING,
SSP00 + SSP01 + SSP02 + SSP03 + SSP04 + SSP05 + SSP06 + SSP07 + SSP08 + SSP09 + SSP10 + SSP11 + SSP12 + SSP13 + SSP14 + SSP15 + SSP99 SSPLUS,
SSS01 + SSS02 + SSS09 LEAVING,
SST01 + SST02 + SST03 + SST21 + SST22 OVERWORKTIME,
(SSP00 + SSP01 + SSP02 + SSP03 + SSP04 + SSP05 + SSP06 + SSP07 + SSP08 + SSP09 + SSP10 + SSP11 + SSP12 + SSP13 + SSP14 + SSP15 + SSP99)
- (SSS01 + SSS02 + SSS03 + SSS04 + SSS05 + SSS06 + SSS07 + SSS08 + SSS09 + SSS10 + SSS11 + SSS12 + SSS13 + SSS14 + SSS15 + SSS99) SSTOTAL,
SSS01 + SSS02 + SSS04 + SSS05 + SSS06 + SSS07 + SSS08 + SSS09 + SSS10 + SSS11 + SSS12 + SSS13 + SSS14 + SSS15 + SSS99 SSMINUS,
SSP01 + SSP02 + SSP03 + SSP04 + SSP05 + SSP06 + SSP07 + SSP08 + SSP09 + SSP10 + SSP11 + SSP12 + SSP13 + SSP14 + SSP15 + SSP99 TOTALPLUS,
SSH01 + SSH02 + SSH03 EMPLOYER,
ISNULL(B.BPNME, '') BPNME,
ISNULL(C.BPPYM, '') BPPYM,
ISNULL(B.BPSWY, '') BPSWY,
ISNULL(D.BCNAM, '') BCNAM,
ISNULL(B.BPACC, '') BPACC,
ISNULL(B.BPEML, '') BPEML,
ISNULL(B.BPEM2, '') BPEM2,
(SELECT SUM(SSS06) FROM {0} E WHERE A.SSENO=E.SSENO AND E.SSYMM <= @SSYMM) SSS06SUM,
(SELECT SUM(SSH06) FROM {0} F WHERE A.SSENO=F.SSENO AND F.SSYMM <= @SSYMM) SSH06SUM,
SSC01, SSC03, SSC03, SSC04, SSC05, SSC06, SSC07, SSC08, SSC09, SSC10
FROM {0} A
LEFT OUTER JOIN BPSNView B ON A.SSENO=B.BPENO
LEFT OUTER JOIN BPAA C ON A.SSPYN=C.BPPYN
LEFT OUTER JOIN BRML D ON B.BPBNK=D.BCNUM";
private const string SelectSalaryStripSumSql =
@"SELECT ISNULL(SUM(SSD01), 0) SSD01, ISNULL(SUM(SSD02), 0) SSD02, ISNULL(SUM(SSSRD), 0) SSSRD, ISNULL(SUM(SSP00), 0) SSP00,
ISNULL(SUM(SSP01), 0) SSP01, ISNULL(SUM(SSP02), 0) SSP02, ISNULL(SUM(SSP03), 0) SSP03, ISNULL(SUM(SSP04), 0) SSP04,
ISNULL(SUM(SSP05), 0) SSP05, ISNULL(SUM(SSP06), 0) SSP06, ISNULL(SUM(SSP07), 0) SSP07, ISNULL(SUM(SSP08), 0) SSP08,
ISNULL(SUM(SSP09), 0) SSP09, ISNULL(SUM(SSP10), 0) SSP10, ISNULL(SUM(SSP11), 0) SSP11, ISNULL(SUM(SSP12), 0) SSP12,
ISNULL(SUM(SSP13), 0) SSP13, ISNULL(SUM(SSP14), 0) SSP14, ISNULL(SUM(SSP15), 0) SSP15, ISNULL(SUM(SSP99), 0) SSP99,
ISNULL(SUM(SSS01), 0) SSS01, ISNULL(SUM(SSS02), 0) SSS02, ISNULL(SUM(SSS03), 0) SSS03, ISNULL(SUM(SSS04), 0) SSS04,
ISNULL(SUM(SSS05), 0) SSS05, ISNULL(SUM(SSS06), 0) SSS06, ISNULL(SUM(SSS07), 0) SSS07, ISNULL(SUM(SSS08), 0) SSS08,
ISNULL(SUM(SSS09), 0) SSS09, ISNULL(SUM(SSS10), 0) SSS10, ISNULL(SUM(SSS11), 0) SSS11, ISNULL(SUM(SSS12), 0) SSS12,
ISNULL(SUM(SSS13), 0) SSS13, ISNULL(SUM(SSS14), 0) SSS14, ISNULL(SUM(SSS15), 0) SSS15, ISNULL(SUM(SSS99), 0) SSS99,
ISNULL(SUM(SSH01), 0) SSH01, ISNULL(SUM(SSH02), 0) SSH02, ISNULL(SUM(SSH03), 0) SSH03, ISNULL(SUM(SSH04), 0) SSH04,
ISNULL(SUM(SSH05), 0) SSH05, ISNULL(SUM(SSH06), 0) SSH06, ISNULL(SUM(SSH07), 0) SSH07, ISNULL(SUM(SSH08), 0) SSH08,
ISNULL(SUM(SSH09), 0) SSH09, ISNULL(SUM(SSH10), 0) SSH10, ISNULL(SUM(SST01), 0) SST01, ISNULL(SUM(SST02), 0) SST02,
ISNULL(SUM(SST03), 0) SST03, ISNULL(SUM(SST04), 0) SST04, ISNULL(SUM(SST05), 0) SST05, ISNULL(SUM(SST06), 0) SST06,
ISNULL(SUM(SST07), 0) SST07, ISNULL(SUM(SST08), 0) SST08, ISNULL(SUM(SST09), 0) SST09, ISNULL(SUM(SST10), 0) SST10,
ISNULL(SUM(SST11), 0) SST11, ISNULL(SUM(SST12), 0) SST12, ISNULL(SUM(SST13), 0) SST13, ISNULL(SUM(SST14), 0) SST14,
ISNULL(SUM(SST15), 0) SST15, ISNULL(SUM(SST16), 0) SST16, ISNULL(SUM(SST17), 0) SST17, ISNULL(SUM(SST18), 0) SST18,
ISNULL(SUM(SST19), 0) SST19, ISNULL(SUM(SST20), 0) SST20, ISNULL(SUM(SST21), 0) SST21, ISNULL(SUM(SST22), 0) SST22,
ISNULL(SUM(SST23), 0) SST23, ISNULL(SUM(SST24), 0) SST24, ISNULL(SUM(SST25), 0) SST25, ISNULL(SUM(SSL01), 0) SSL01,
ISNULL(SUM(SSL02), 0) SSL02, ISNULL(SUM(SSL03), 0) SSL03, ISNULL(SUM(SSL04), 0) SSL04, ISNULL(SUM(SSL05), 0) SSL05,
ISNULL(SUM(SSP06 + SSP07 + SSP08 + SSP13 + SSP14), 0) OVERWORK,
ISNULL(SUM(SSP09 + SSP10 + SSP12), 0) OUTGOING,
ISNULL(SUM(SSP00 + SSP01 + SSP02 + SSP03 + SSP04 + SSP05 + SSP06 + SSP07 + SSP08 + SSP09 + SSP10 + SSP11 + SSP12 +
SSP13 + SSP14 + SSP15 + SSP99), 0) SSPLUS,
ISNULL(SUM(SSS01 + SSS02 + SSS09), 0) LEAVING,
ISNULL(SUM(SST01 + SST02 + SST03 + SST21 + SST22), 0) OVERWORKTIME,
ISNULL(SUM((SSP00 + SSP01 + SSP02 + SSP03 + SSP04 + SSP05 + SSP06 + SSP07 + SSP08 + SSP09 + SSP10 + SSP11 + SSP12 +
SSP13 + SSP14 + SSP15 + SSP99)
- (SSS01 + SSS02 + SSS03 + SSS04 + SSS05 + SSS06 + SSS07 + SSS08 + SSS09 + SSS10 + SSS11 + SSS12 + SSS13 +
SSS14 + SSS15 + SSS99)), 0) SSTOTAL,
ISNULL(SUM(SSS01 + SSS02 + SSS04 + SSS05 + SSS06 + SSS07 + SSS08 + SSS09 + SSS10 + SSS11 + SSS12 + SSS13 + SSS14 +
SSS15 + SSS99), 0) SSMINUS,
ISNULL(SUM(SSP01 + SSP02 + SSP03 + SSP04 + SSP05 + SSP06 + SSP07 + SSP08 + SSP09 + SSP10 + SSP11 + SSP12 + SSP13 +
SSP14 + SSP15 + SSP99), 0) TOTALPLUS,
ISNULL(SUM(SSH01 + SSH02 + SSH03), 0) EMPLOYER
FROM {0} A WHERE SSYMM=@SSYMM AND SSPYN=@SSPYN";
/// <summary>
/// 薪資條發放 Grid 查詢
/// </summary>
[DataObjectMethod(DataObjectMethodType.Select)]
public DataTable SelectSalaryStrip(string tableName, DateTime SSYMM, string SSPYN)
{
DbCommand cmd = Query.NewCommand(
String.Format(SelectSalaryStripSql, tableName) + " WHERE SSYMM=@SSYMM AND SSPYN=@SSPYN ORDER BY SSENO ");
cmd.Parameters.Add(Query.NewParameter("SSYMM", SSYMM));
cmd.Parameters.Add(Query.NewParameter("SSPYN", SSPYN));
return Query.Select(cmd);
}
/// <summary>
/// 薪資條發放 Grid 合計查詢
/// </summary>
[DataObjectMethod(DataObjectMethodType.Select)]
public DataTable SelectSalaryStripSum(string tableName, DateTime SSYMM, string SSPYN)
{
DbCommand cmd = Query.NewCommand(String.Format(SelectSalaryStripSumSql, tableName));
cmd.Parameters.Add(Query.NewParameter("SSYMM", SSYMM));
cmd.Parameters.Add(Query.NewParameter("SSPYN", SSPYN));
return Query.Select(cmd);
}
}
public class SsmsRecord
{
public DateTime SSYMM;
public string SSENO;
public string SSNUM;
public string SSPYN;
public string SSITM;
public string SSJNO;
public string SSCNO;
public string SSBRH;
public int SSD01;
public int SSD02;
public int SSSRD;
public int SSP00;
public int SSP01;
public int SSP02;
public int SSP03;
public int SSP04;
public int SSP05;
public int SSP06;
public int SSP07;
public int SSP08;
public int SSP09;
public int SSP10;
public int SSP11;
public int SSP12;
public int SSP13;
public int SSP14;
public int SSP15;
public int SSP99;
public int SSS01;
public int SSS02;
public int SSS03;
public int SSS04;
public int SSS05;
public int SSS06;
public int SSS07;
public int SSS08;
public int SSS09;
public int SSS10;
public int SSS11;
public int SSS12;
public int SSS13;
public int SSS14;
public int SSS15;
public int SSS99;
public int SSH01;
public int SSH02;
public int SSH03;
public int SSH04;
public int SSH05;
public int SSH06;
public int SSH07;
public int SSH08;
public int SSH09;
public int SSH10;
public int SST01;
public int SST02;
public int SST03;
public int SST04;
public int SST05;
public int SST06;
public int SST07;
public int SST08;
public int SST09;
public int SST10;
public int SST11;
public int SST12;
public int SST13;
public int SST14;
public int SST15;
public int SST16;
public int SST17;
public int SST18;
public int SST19;
public int SST20;
public int SST21;
public int SST22;
public int SST23;
public int SST24;
public int SST25;
public int SSL01;
public int SSL02;
public int SSL03;
public int SSL04;
public int SSL05;
public string SSC01;
public string SSC02;
public string SSC03;
public string SSC04;
public string SSC05;
public string SSC06;
public string SSC07;
public string SSC08;
public string SSC09;
public string SSC10;
public SsmsRecord()
{
SSYMM = new DateTime();
SSENO = "";
SSNUM = "";
SSPYN = "";
SSITM = "";
SSJNO = "";
SSCNO = "";
SSBRH = "";
SSD01 = 0;
SSD02 = 0;
SSSRD = 0;
SSP00 = 0;
SSP01 = 0;
SSP02 = 0;
SSP03 = 0;
SSP04 = 0;
SSP05 = 0;
SSP06 = 0;
SSP07 = 0;
SSP08 = 0;
SSP09 = 0;
SSP10 = 0;
SSP11 = 0;
SSP12 = 0;
SSP13 = 0;
SSP14 = 0;
SSP15 = 0;
SSP99 = 0;
SSS01 = 0;
SSS02 = 0;
SSS03 = 0;
SSS04 = 0;
SSS05 = 0;
SSS06 = 0;
SSS07 = 0;
SSS08 = 0;
SSS09 = 0;
SSS10 = 0;
SSS11 = 0;
SSS12 = 0;
SSS13 = 0;
SSS14 = 0;
SSS15 = 0;
SSS99 = 0;
SSH01 = 0;
SSH02 = 0;
SSH03 = 0;
SSH04 = 0;
SSH05 = 0;
SSH06 = 0;
SSH07 = 0;
SSH08 = 0;
SSH09 = 0;
SSH10 = 0;
SST01 = 0;
SST02 = 0;
SST03 = 0;
SST04 = 0;
SST05 = 0;
SST06 = 0;
SST07 = 0;
SST08 = 0;
SST09 = 0;
SST10 = 0;
SST11 = 0;
SST12 = 0;
SST13 = 0;
SST14 = 0;
SST15 = 0;
SST16 = 0;
SST17 = 0;
SST18 = 0;
SST19 = 0;
SST20 = 0;
SST21 = 0;
SST22 = 0;
SST23 = 0;
SST24 = 0;
SST25 = 0;
SSL01 = 0;
SSL02 = 0;
SSL03 = 0;
SSL04 = 0;
SSL05 = 0;
SSC01 = "";
SSC02 = "";
SSC03 = "";
SSC04 = "";
SSC05 = "";
SSC06 = "";
SSC07 = "";
SSC08 = "";
SSC09 = "";
SSC10 = "";
}
public void Fill(DbDataReader reader)
{
int i = 0;
SSYMM = !reader.IsDBNull(i) ? reader.GetDateTime(i) : new DateTime();
i++;
SSENO = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSNUM = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSPYN = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSITM = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSJNO = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSCNO = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSBRH = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSD01 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSD02 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSSRD = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP00 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP01 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP02 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP03 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP04 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP05 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP06 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP07 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP08 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP09 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP10 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP11 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP12 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP13 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP14 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP15 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSP99 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS01 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS02 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS03 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS04 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS05 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS06 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS07 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS08 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS09 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS10 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS11 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS12 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS13 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS14 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS15 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSS99 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH01 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH02 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH03 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH04 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH05 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH06 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH07 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH08 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH09 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSH10 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST01 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST02 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST03 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST04 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST05 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST06 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST07 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST08 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST09 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST10 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST11 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST12 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST13 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST14 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST15 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST16 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST17 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST18 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST19 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST20 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST21 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST22 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST23 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST24 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SST25 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSL01 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSL02 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSL03 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSL04 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSL05 = !reader.IsDBNull(i) ? reader.GetInt32(i) : 0;
i++;
SSC01 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC02 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC03 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC04 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC05 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC06 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC07 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC08 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC09 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
i++;
SSC10 = !reader.IsDBNull(i) ? reader.GetString(i) : "";
}
}
Reference in New Issue View Git Blame Copy Permalink