//*****************************表單自訂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;
}
}
