【正文】 private void Bnt_Update_ItemClick (object sender, EventArgs e)4. 點(diǎn)擊“刪除明細(xì)”按鈕事件private void Bnt_DelList_ItemClick (object sender, EventArgs e)5. 點(diǎn)擊“審核”按鈕事件private void Bnt_Audit_ItmeClick(object sender, EventArgs e)6. 點(diǎn)擊“屬性”按鈕事件private void Bnt_Attrib_ItemClick(object sender, EventArgs e)7. 點(diǎn)擊“刷新”按鈕事件private void Bnt_Refresh_ItemClick(object sender, EventArgs e)8. 點(diǎn)擊“保存”按鈕事件private void Bnt_Save_ItemClick(object sender, EventArgs e)9. 點(diǎn)擊“退出”按鈕事件private void Bnt_Cancel_ItemClick( object sender, EventArgs e) 10. 保存方法：(保存按鈕會調(diào)用)public Boolean SaveDate()11. 檢查數(shù)據(jù)：(保存按鈕會調(diào)用)public Boolean CheckDate(12. 初始化數(shù)據(jù)public void GetData13. 讀取界面按鈕狀態(tài)public void loadbuttonStatus14. 設(shè)置單據(jù)編輯狀態(tài)public void ReadOnlyControl15. 設(shè)置單據(jù)表格編輯狀態(tài)public void ReadOnlyGridView16. 獲取單據(jù)編號public void GetBillID 中包含F(xiàn)rmBuyInCome函數(shù)如下：1) 得到單據(jù)信息public OutputDTO FrmBuyInCome_SearchUpdate (InputDTO inputdto)注：InputDTO是通用的數(shù)據(jù)輸入對象2) 添加信息public OutputDTO FrmBuyInCome_Add (InputDTO inputdto)3) 修改信息public OutputDTO FrmBuyInCome_SearchUpdate(InputDTO inputdto)4) 刪除信息public OutputDTO FrmBuyInCome_Del (InputDTO inputdto)5) 保存信息public OutputDTO FrmBuyInCome_Save (InputDTO inputdto)6) 審核信息public OutputDTO FrmBuyInCome_Audit (InputDTO inputdto)7) 獲取單據(jù)編號public OutputDTO FrmBuyInCome_GetBillID (InputDTO inputdto)：1) 得到單據(jù)信息 public DataTable FrmBuyInCome_Search (string datesql)2) 添加信息public DataTable FrmBuyInCome_Add (string datesql)3) 修改信息public DataTable FrmBuyInCome_SearchUpdate (string datesql)4) 刪除信息public int FrmBuyInCome_Del (string CUR_ID)5) 保存信息public int FrmBuyInCome_Save(DataTable dt)6) 審核信息public int FrmBuyInCome_Save(DataTable dt)7) 獲取單據(jù)編號public int FrmBuyInCome_GetBillID (DataTable dt)11. 算法加密算法使用MD5加密算法獲取編號存儲過程GetCode12. SQL語句i. 增加：入庫單、入庫退回單：表頭檔INSERT INTO [INV_MF_PS]([PS_NO], [PS_DD], [PAY_DD], [CHK_DD], [TRAD_MTH], [BAT_NO], [CUS_NO], [VOH_ID], [VOH_NO], [DEP], [INV_NO], [TAX_ID], [PO_ID], [PO_NO], [RP_NO], [ZHANG_ID], [CUR_ID], [EXC_RTO], [SAL_NO], [ARP_NO], [AMTN_IRP], [AMT_IRP], [RSV_PER], [AMTN_RSV], [AMT_RSV], [REM], [PAY_MTH], [PAY_DAYS], [CHK_DAYS], [INT_DAYS], [PAY_REM], [CLS_ID], [EP_NO], [AMTN_EP], [TAX_IRP], [USR], [CHK_MAN], [PRT_SW], [CPY_SW], [BIL_NO], [DIS_CNT], [CB_ID], [CONTRACT], [LC_NO], [PK_NO], [CLS_REM], [AMT], [VOH_MKNO], [BIL_ID], [CLS_DATE], [CUS_OS_NO], [PO_ID2], [CK_CLS_ID], [LZ_CLS_ID], [CLSCK], [CLSLZ], [AMTN_FT], [YD_ID], [BIL_TYPE], [ACC_FP_NO], [PCTOSA], [CNTT_NO], [KP_ID], [EP_NO1], [AMTN_EP1], [MOB_ID], [ZB_NO], [FJ_NUM], [SYS_DATE], [INV_DD], [QTY], [AMT_CLS], [AMTN_NET_CLS], [TAX_CLS], [PRT_USR], [TURN_ID], [ARP_DD], [BD_ID], [ZC_FLAG], [QTY_CLS], [CLSID], [ADR_NO], [ARD_NAME], [SEND_NO], [AMTN_NET], [SEEN_NAME], [COL_NO], [COL_NAME], [PS_NO_NO], [SAL_NO2], [PS_REM], [CNT_MAN1], [TEL1], [AMTN_EP2], [EP_NO2], [ATTN_INV], [PS_ID])VALUES(PS_NO,varchar(20), PS_DD,datetime, PAY_DD,datetime, CHK_DD,datetime, TRAD_MTH,varchar(10), BAT_NO,varchar(20), CUS_NO,varchar(12), VOH_ID,varchar(2), VOH_NO,varchar(20), DEP,varchar(8), INV_NO,varchar(14), TAX_ID,varchar(1), PO_ID,varchar(2), PO_NO,varchar(25), RP_NO,varchar(20), ZHANG_ID,varchar(1), CUR_ID,varchar(4), EXC_RTO,numeric(28,8), SAL_NO,varchar(12), ARP_NO,varchar(20), AMTN_IRP,numeric(28,8), AMT_IRP,numeric(28,8), RSV_PER,numeric(28,8), AMTN_RSV,numeric(28,8), AMT_RSV,numeric(28,8), REM,text, PAY_MTH,varchar(1), PAY_DAYS,smallint, CHK_DAYS,smallint, INT_DAYS,smallint, PAY_REM,varchar(80), CLS_ID,varchar(1), EP_NO,varchar(20), AMTN_EP,numeric(28,8), TAX_IRP,numeric(28,8), USR,varchar(12), CHK_MAN,varchar(12), PRT_SW,varchar(1), CPY_SW,varchar(1), BIL_NO,varchar(20), DIS_CNT,numeric(28,8), CB_ID,varchar(1), CONTRACT,varchar(80), LC_NO,varchar(30), PK_NO,varchar(20), CLS_REM,varchar(30), AMT,numeric(28,8), VOH_MKNO,varchar(20), BIL_ID,varchar(2), CLS_DATE,datetime, CUS_OS_NO,varchar(30), PO_ID2,varchar(1), CK_CLS_ID,varchar(1), LZ_CLS_ID,varchar(1), CLSCK,varchar(1), CLSLZ,varchar(1), AMTN_FT,numeric(28,8), YD_ID,varchar(1), BIL_TYPE,varchar(2), ACC_FP_NO,varchar(20), PCTOSA,varchar(1), CNTT_NO,varchar(40), KP_ID,varchar(1), EP_NO1,varchar(20), AMTN_EP1,numeric(28,8), MOB_ID,varchar(2), ZB_NO,varchar(20), FJ_NUM,smallint, SYS_DATE,datetime, INV_DD,datetime, QTY,numeric(28,8), AMT_CLS,numeric(28,8), AMTN_NET_CLS,numeric(28,8), TAX_CLS,numeric(28,8), PRT_USR,varchar(12), TURN_ID,varchar(1), ARP_DD,datetime, BD_ID,varchar(1), ZC_FLAG,varchar(1), QTY_CLS,numeric(28,8), CLSID,varchar(1), ADR_NO,varchar(4), ARD_NAME,varchar(100), SEND_NO,varchar(4), AMTN_NET,numeric(28,8), SEEN_NAME,varchar(100), COL_NO,varchar(20), COL_NAME,varchar(80), PS_NO_NO,numeric(18,0), SAL_NO2,varchar(12), PS_REM,varchar(100), CNT_MAN1,varchar(30), TEL1,varchar(20), AMTN_EP2,numeric(28,8), EP_NO2,varchar(20), ATTN_INV,numeric(28,8), PS_ID,bit,)入庫單、入庫退回單：表身檔 INSERT INTO [INV_TF_PS]([PS_NO], [ITM], [PS_DD], [WH], [BAT_NO], [PO_NO], [PRD_NO], [PRD_NAME], [PRD_MARK], [QTY], [QTY1], [CST_SAL], [CSTN_SAL], [UP], [AMTN_NET], [AMT], [TAX], [DIS_CNT], [QTY_RTN], [AMTN_EP], [PAK_UNIT], [PAK_EXC], [PAK_NW_N], [PAK_NW], [PAK_WEIGHT_UNIT], [PAK_GW_N], [PAK_GW], [PAK_MEAST], [PAK_MEAST_UNIT], [VALID_DD], [REM], [EST_DD], [TAX_RTO], [CST_STD], [UP_QTY1], [EST_ITM], [OS_ID], [QTY_PS], [PRE_ITM], [SEND_WH], [QTY_LOSS], [AMTN_SNET], [TAXS], [UT], [AMTN], [FREE_ID], [AMT_FP], [AMTN_NET_FP], [TAX_FP], [QTY_CK], [BZ_KND], [PRICE_ID], [費(fèi)用分?jǐn)偨痤~], [TI_NO], [SUP_PRD_NO], [CNTT_NO], [TYPE_SGT], [GF_NO], [PK_NO], [TI_ITM], [QTY_FP], [SL_NO], [SH_NO_CUS], [AMTN_EP1], [RTO_EP], [廠商單號], [FH_NO], [PRD_NO_SO