//*****************************表單自訂Fuction**************************************** #region WfConfirm 確認 private void WfConfirm() { vw_stpi100 masterModel = null; try { if (DrMaster == null) { return; } if (WfRetrieveMaster() == false) { return; } if (WfLockMasterRow() == false) //這裡會LOCK資料 { return; } WfSetBllTransaction(); masterModel = DrMaster.ToItem <vw_stpi100>(); if (masterModel.scavali == "N") { WfShowErrorMsg("客戶已失效!"); WfRollback(); return; } if (GlobalFn.isNullRet(masterModel.scaconf, "N") != "N") { WfShowErrorMsg("客戶非未確認狀態!"); WfRollback(); return; } DrMaster["scaconf"] = "Y"; DrMaster["scavali"] = "Y"; DrMaster["scamodu"] = LoginInfo.UserNo; DrMaster["scamodg"] = LoginInfo.DeptNo; DrMaster["scamodd"] = Now; BoMaster.OfUpdate(DrMaster.Table); WfCommit(); DrMaster.AcceptChanges(); WfShowBottomStatusMsg("作業成功!"); masterModel = DrMaster.ToItem <vw_stpi100>(); WfSetDocPicture(masterModel.scavali, masterModel.scaconf, "", pbxDoc); } catch (Exception ex) { WfRollback(); DrMaster.RejectChanges(); throw ex; } }
private bool WfReCalculate(string ipa01) { icc_tb iccModel; string selectSql; try { //lock master row 並取得transaction物件 if (WfLockMasterRow() == false) { WfShowErrorMsg("Lock ipa_file 失敗!"); return(false); } WfRetrieveMaster(); //更新主檔資料 WfRetrieveDetail(); //更新明細資料 WfSetBllTransaction(); //相關bll 註冊transaction TabDetailList[0].BoBasic.TRAN = BoMaster.TRAN; foreach (DataRow drDetail in TabDetailList[0].DtSource.Rows) { var ipbModel = drDetail.ToItem <ipb_tb>(); iccModel = BoInv.OfGetIccModel(ipbModel.ipb03, ipbModel.ipb04); drDetail["ipb06"] = iccModel.icc05; drDetail["ipbmodu"] = LoginInfo.UserNo; drDetail["ipbmodg"] = LoginInfo.DeptNo; drDetail["ipbmodd"] = Now; } DrMaster["ipa05"] = "Y"; DrMaster["ipa06"] = Today; DrMaster["ipamodu"] = LoginInfo.UserNo; DrMaster["ipamodg"] = LoginInfo.DeptNo; DrMaster["ipamodd"] = Now; BoMaster.OfUpdate(TabMaster.DtSource); TabDetailList[0].BoBasic.OfUpdate(TabDetailList[0].DtSource); if (WfCommit() == false) { DrMaster.RejectChanges(); TabDetailList[0].DtSource.RejectChanges(); WfRollback(); WfShowErrorMsg("執行commit失敗!"); return(false); } return(false); } catch (Exception ex) { DrMaster.RejectChanges(); TabDetailList[0].DtSource.RejectChanges(); WfRollback(); throw ex; } }
protected override bool WfPreDeleteCheck(DataRow pDr) { vw_glat200 masterModel; string sqlSelect = ""; List <SqlParameter> sqlParmList = null; int chkCnts = 0; try { WfRetrieveMaster();//更新Master資料 masterModel = DrMaster.ToItem <vw_glat200>(); masterModel = DrMaster.ToItem <vw_glat200>(); if (!GlobalFn.varIsNull(masterModel.gea06)) { WfShowBottomStatusMsg("已拋轉傳票,不可刪除!"); return(false); } if (masterModel.gea02 == "AR" && masterModel.gea03 == 1) //應收帳款 { sqlSelect = @"SELECT COUNT(1) FROM cea_tb WHERE cea01=@cea01 AND ceaconf<>'N' "; sqlParmList = new List <SqlParameter>(); sqlParmList.Add(new SqlParameter("@cea01", masterModel.gea01)); chkCnts = GlobalFn.isNullRet(BoGla.OfGetFieldValue(sqlSelect, sqlParmList.ToArray()), 0); if (chkCnts != 0) { WfShowBottomStatusMsg("單據非未確認狀態,不可刪除!"); return(false); } } return(true); } catch (Exception ex) { WfRollback(); DrMaster.RejectChanges(); throw ex; } }
private bool WfCancelPosting(string ipa01) { icc_tb iccModel; string selectSql; try { //lock master row 並取得transaction物件 if (WfLockMasterRow() == false) { WfShowErrorMsg("Lock ipa_file 失敗!"); return(false); } WfSetBllTransaction(); //相關bll 註冊transaction TabDetailList[0].BoBasic.TRAN = BoMaster.TRAN; DrMaster["ipa07"] = "N"; DrMaster["ipa08"] = DBNull.Value; DrMaster["ipamodu"] = LoginInfo.UserNo; DrMaster["ipamodg"] = LoginInfo.DeptNo; DrMaster["ipamodd"] = Now; BoMaster.OfUpdate(TabMaster.DtSource); if (WfCommit() == false) { DrMaster.RejectChanges(); TabDetailList[0].DtSource.RejectChanges(); WfRollback(); WfShowErrorMsg("執行commit失敗!"); return(false); } return(false); } catch (Exception ex) { DrMaster.RejectChanges(); WfRollback(); throw ex; } }
private void WfInvalid() { vw_stpi100 masterModel = null; string msg; try { if (DrMaster == null) { return; } if (WfRetrieveMaster() == false) //這裡會LOCK資料 { return; } WfSetBllTransaction(); masterModel = DrMaster.ToItem <vw_stpi100>(); if (masterModel.scavali == "Y") { msg = "是否要作廢客戶?"; } else { msg = "是否要作廢還原客戶?"; } var result = WfShowConfirmMsg(msg); //if (WfShowConfirmMsg(msg) != 1) if (result != DialogResult.Yes) { return; } if (masterModel.scavali == "Y" || masterModel.scavali == "W")//走作廢 { DrMaster["scavali"] = "N"; } else { DrMaster["scavali"] = "Y"; } DrMaster["scamodu"] = LoginInfo.UserNo; DrMaster["scamodg"] = LoginInfo.DeptNo; DrMaster["scamodd"] = Now; BoMaster.OfUpdate(DrMaster.Table); WfCommit(); DrMaster.AcceptChanges(); WfShowBottomStatusMsg("作業成功!"); masterModel = DrMaster.ToItem <vw_stpi100>(); WfSetDocPicture(masterModel.scavali, masterModel.scaconf, "", pbxDoc); } catch (Exception ex) { WfRollback(); DrMaster.RejectChanges(); throw ex; } }