Esempio n. 1
0
        //*****************************表單自訂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;
            }
        }
Esempio n. 2
0
        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;
            }
        }
Esempio n. 3
0
        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;
            }
        }
Esempio n. 4
0
        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;
            }
        }
Esempio n. 5
0
        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;
            }
        }