protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_invb500 masterModel = null;
try
{
masterModel = DrMaster.ToItem <vw_invb500>();
switch (e.Column.ToLower())
{
case "ipa01":
if (GlobalFn.isNullRet(e.Value, "") == "")
{
return(true);
}
if (BoBas.OfChkBabPKValid(GlobalFn.isNullRet(e.Value, ""), "inv", "50") == false)
{
WfShowErrorMsg("無此單別,請檢核!");
return(false);
}
//e.Row["iga01_c"] = BoBas.OfGetBab02(GlobalFn.isNullRet(e.Value, ""));
break;
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override void WfActionClick(string pActionName)
{
vw_invb501 masterModel;
try
{
switch (pActionName)
{
case "ReCalculate":
WfRetrieveMaster();
masterModel = DrMaster.ToItem <vw_invb501>();
if (GlobalFn.isNullRet(masterModel.ipa05, "") == "Y")
{
WfShowBottomStatusMsg("已重計過!");
return;
}
WfReCalculate(masterModel.ipa01);
break;
}
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_invr215 invr215Model = null;
string msg;
try
{
invr215Model = DrMaster.ToItem <vw_invr215>();
if (
GlobalFn.varIsNull(invr215Model.icc01) &&
GlobalFn.varIsNull(invr215Model.icc02)
)
{
msg = "請至少輸入一個條件!";
WfShowErrorMsg(msg);
errorProvider.SetError(ute_icc01, msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_invr410 invr410Model = null;
string msg;
try
{
invr410Model = DrMaster.ToItem <vw_invr410>();
if (
GlobalFn.varIsNull(invr410Model.ila02_s) &&
GlobalFn.varIsNull(invr410Model.ila02_e) &&
GlobalFn.varIsNull(invr410Model.ila03) &&
GlobalFn.varIsNull(invr410Model.ila04) &&
GlobalFn.varIsNull(invr410Model.ila05) &&
GlobalFn.varIsNull(invr410Model.ilb03) &&
GlobalFn.varIsNull(invr410Model.ilb11)
)
{
msg = "請至少輸入一個條件!";
WfShowErrorMsg(msg);
errorProvider.SetError(ute_ila03, msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_cspr110 cspr110Model = null;
string msg;
try
{
cspr110Model = DrMaster.ToItem <vw_cspr110>();
if (GlobalFn.varIsNull(cspr110Model.jja16_s) &&
GlobalFn.varIsNull(cspr110Model.jja16_e) &&
GlobalFn.varIsNull(cspr110Model.icc05_s) &&
GlobalFn.varIsNull(cspr110Model.icc05_e)
)
{
msg = "請至少輸入一個條件!";
WfShowErrorMsg(msg);
errorProvider.SetError(udt_jja16_s, msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_manr311 manr311Model = null;
string msg;
try
{
manr311Model = DrMaster.ToItem <vw_manr311>();
if (GlobalFn.varIsNull(manr311Model.mfa01) &&
GlobalFn.varIsNull(manr311Model.mfa02_s) &&
GlobalFn.varIsNull(manr311Model.mfa02_e) &&
GlobalFn.varIsNull(manr311Model.mfa03) &&
GlobalFn.varIsNull(manr311Model.mfa06)
)
{
msg = "請至少輸入一個條件!";
WfShowErrorMsg(msg);
errorProvider.SetError(ute_mfa01, msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_glat300_1 masterModel = null;
vw_glat300_1s detailModel = null;
List <vw_glat300_1s> detailList = null;
UltraGrid uGrid;
string msg;
Control chkControl;
string chkColName;
int iChkDetailTab;
try
{
masterModel = DrMaster.ToItem <vw_glat300_1>();
detailList = TabDetailList[0].DtSource.ToList <vw_glat300_1s>();
#region 單頭資料檢查
chkColName = "gfb07"; //本幣金額
chkControl = ute_gfb07;
var sumDetailGfb07 = detailList.Sum(p => p.gfh09);
if (masterModel.gfb07 != sumDetailGfb07)
{
msg = "沖帳金額加總不相同,請檢核!";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public String PesquisaBancoExiste(string strDoBanco, string ServidorInstancia, string UsuarioSQLServer, string SenhaSQLServer)
{
try
{
AbrirConexaoMaster(ServidorInstancia, "MASTER", UsuarioSQLServer, SenhaSQLServer);
string strSQL = " SELECT * FROM sys.databases WHERE name = '" + strDoBanco + "'";
CmdDbMaster = new SqlCommand(strSQL, ConDbMaster);
DrMaster = CmdDbMaster.ExecuteReader();
if (DrMaster.Read())
{
return(DrMaster["name"].ToString());
}
else
{
return("");
}
}
catch (Exception ex)
{
throw new Exception("Erro ao Listar Banco Existe: " + ex.Message.ToString());
}
finally
{
FecharConexaoMaster();
}
}
protected override bool WfFormCheck()
{
vw_invr520 invr520Model = null;
string msg;
try
{
invr520Model = DrMaster.ToItem<vw_invr520>();
if (
GlobalFn.varIsNull(invr520Model.ipa03_s)
&& GlobalFn.varIsNull(invr520Model.ipa03_e)
&& GlobalFn.varIsNull(invr520Model.ipa01)
&& GlobalFn.varIsNull(invr520Model.ipacreu)
&& GlobalFn.varIsNull(invr520Model.ipacreg)
)
{
msg = "請至少輸入一個條件!";
WfShowErrorMsg(msg);
errorProvider.SetError(ute_ipa01, msg);
return false;
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_basi090 masterModel = null;
string msg;
Control chkControl;
string chkColName;
try
{
masterModel = DrMaster.ToItem <vw_basi090>();
#region 單頭資料檢查
chkColName = "bel01";//貨運方式
chkControl = ute_bel01;
if (GlobalFn.varIsNull(masterModel.bel01))
{
this.uTab_Master.SelectedTab = uTab_Master.Tabs[0];
chkControl.Focus();
msg = TabMaster.AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_glab312 masterModel = null;
string msg = "";
try
{
masterModel = DrMaster.ToItem <vw_glab312>();
if (GlobalFn.varIsNull(masterModel.gfa08))
{
msg = "會計年度不可為空白!";
WfShowErrorMsg(msg);
errorProvider.SetError(ute_gfa08, msg);
return(false);
}
if (GlobalFn.varIsNull(masterModel.gfa09))
{
msg = "期數不可為空白!";
WfShowErrorMsg(msg);
errorProvider.SetError(ute_gfa09, msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfPreInUpdateModeCheck()
{
vw_invt521 masterModel;
try
{
masterModel = DrMaster.ToItem <vw_invt521>();
if (masterModel.ipa05 == "N")
{
WfShowBottomStatusMsg("未執行重計，不可修改!");
return(false);
}
if (masterModel.ipa07 == "Y")
{
WfShowBottomStatusMsg("已過帳，不可修改!");
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfDeleteAppenUpdate(DataRow pDr)
{
StringBuilder sbSql;
List <SqlParameter> sqlParmsList;
vw_admi611 admi611Model;
try
{
admi611Model = DrMaster.ToItem <vw_admi611>();
//刪除明細資料
sbSql = new StringBuilder();
sbSql.AppendLine("DELETE FROM ady_tb WHERE ady01=@ady01");
sqlParmsList = new List <SqlParameter>();
sqlParmsList.Add(new SqlParameter("@ady01", admi611Model.adx01));
BoAdm.OfExecuteNonquery(sbSql.ToString(), sqlParmsList.ToArray());
//清空有掛載在menu的料 ado_tb.ado14
sbSql = new StringBuilder();
sbSql.AppendLine("UPDATE ado_tb SET ado14=NULL ");
sbSql.AppendLine("WHERE ado14=@ado14");
sqlParmsList.Add(new SqlParameter("@ado14", admi611Model.adx01));
BoAdm.OfExecuteNonquery(sbSql.ToString(), sqlParmsList.ToArray());
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_cspr110 cspr110Model;
try
{
cspr110Model = DrMaster.ToItem <vw_cspr110>();
switch (e.Column.ToLower())
{
case "iga02_s":
//if (!GlobalFn.varIsNull(e.Value) && !GlobalFn.varIsNull(invr302Model.iga02_s))
//{
// if (invr302Model.iga02_s > invr302Model.iga02_e)
// {
// WfShowErrorMsg("起日不得大於迄日!");
// return false;
// }
//}
break;
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_invr215 invr215Model;
try
{
invr215Model = DrMaster.ToItem <vw_invr215>();
//switch (e.Column.ToLower())
//{
// case "sea02_s":
// if (!GlobalFn.varIsNull(e.Value) && !GlobalFn.varIsNull(invr215Model.pga02_e))
// {
// if (invr215Model.pga02_s > invr215Model.pga02_e)
// {
// WfShowErrorMsg("起日不得大於迄日!");
// return false;
// }
// }
// break;
//}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_invr401 invr401Model;
try
{
invr401Model = DrMaster.ToItem <vw_invr401>();
switch (e.Column.ToLower())
{
case "ila02_s":
if (!GlobalFn.varIsNull(e.Value) && !GlobalFn.varIsNull(invr401Model.ila02_e))
{
if (invr401Model.ila02_s > invr401Model.ila02_e)
{
WfShowErrorMsg("起日不得大於迄日!");
return(false);
}
}
break;
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override Boolean WfDisplayMode()
{
vw_glai100 masterModel = null;
try
{
if (FormEditMode == YREditType.NA)
{
WfSetControlsReadOnlyRecursion(this, true);
uTree.Enabled = true;
uTree.Focus();
}
else
{
masterModel = DrMaster.ToItem <vw_glai100>();
WfSetControlsReadOnlyRecursion(this, false); //先全開
WfSetControlReadonly(uGridMaster, true); //主表grid不可編輯
WfSetGba07ReadOnly(masterModel.gba06);
uTree.Enabled = false;
if (FormEditMode == YREditType.修改)
{
WfSetControlReadonly(ute_gba01, true);
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override Boolean WfDisplayMode()
{
vw_admi602 masterModel = null;
try
{
if (FormEditMode == YREditType.NA)
{
WfSetControlsReadOnlyRecursion(this, true);
}
else//新增與修改
{
masterModel = DrMaster.ToItem <vw_admi602>();
WfSetControlsReadOnlyRecursion(this, true);//先全關
WfSetControlReadonly(TabDetailList[0].UGrid, new List <string> {
"adq03", "adq04"
}, false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_carb350 masterModel = null;
string msg = "";
try
{
masterModel = DrMaster.ToItem <vw_carb350>();
if (GlobalFn.varIsNull(masterModel.gfa01))
{
msg = "傳票傳票單別不可為空白!";
WfShowErrorMsg(msg);
errorProvider.SetError(ute_gfa01, msg);
return(false);
}
if (GlobalFn.varIsNull(masterModel.gea03))
{
msg = "類別不可為空白!";
WfShowErrorMsg(msg);
errorProvider.SetError(udt_gfa05_e, msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_glab311 masterModel = null;
string msg = "";
try
{
masterModel = DrMaster.ToItem <vw_glab311>();
if (GlobalFn.varIsNull(masterModel.gfa02_s))
{
msg = "傳票起日不可為空白!";
WfShowErrorMsg(msg);
errorProvider.SetError(udt_gfa02_s, msg);
return(false);
}
if (GlobalFn.varIsNull(masterModel.gfa02_s))
{
msg = "傳票迄日不可為空白!";
WfShowErrorMsg(msg);
errorProvider.SetError(udt_gfa02_e, msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_glab321 glab321Model;
try
{
glab321Model = DrMaster.ToItem <vw_glab321>();
switch (e.Column.ToLower())
{
case "gfa08":
if (GlobalFn.varIsNull(e.Value))
{
WfShowErrorMsg("會計年度不可為空白,請檢核!");
return(false);
}
if (GlobalFn.isNullRet(e.Value, 0) <= 0)
{
WfShowErrorMsg("會計年度應大於0,請檢核!");
return(false);
}
break;
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfFormCheck()
{
vw_basi060 masterModel = null;
string msg;
Control chkControl;
string chkColName;
try
{
masterModel = DrMaster.ToItem <vw_basi060>();
#region 單頭資料檢查
chkColName = "beg01";
chkControl = ute_beg01;
#region 金融機構編號
if (GlobalFn.varIsNull(masterModel.beg01))
{
this.uTab_Master.SelectedTab = uTab_Master.Tabs[0];
chkControl.Focus();
msg = TabMaster.AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
if (FormEditMode == YREditType.新增 && BoBas.OfChkBegPKExists(GlobalFn.isNullRet(masterModel.beg01, "")) == true)
{
msg = "金融機構編號已存在,請檢核!";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
#endregion
chkColName = "beg02";
chkControl = ute_beg02;
#region 金融機構名稱
if (GlobalFn.varIsNull(masterModel.beg02))
{
this.uTab_Master.SelectedTab = uTab_Master.Tabs[0];
chkControl.Focus();
msg = TabMaster.AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
#endregion
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override Boolean WfDisplayMode()
{
vw_stpi100 masterModel = null;
try
{
if (DrMaster != null && DrMaster.RowState != DataRowState.Detached)
{
masterModel = DrMaster.ToItem <vw_stpi100>();
WfSetDocPicture(masterModel.scavali, masterModel.scaconf, "", pbxDoc);
}
else
{
WfSetDocPicture("", "", "", pbxDoc);
}
if (FormEditMode == YREditType.NA)
{
WfSetControlsReadOnlyRecursion(this, true);
}
else
{
//明細先全開,並交由 WfSetDetailDisplayMode處理-事件觸發
WfSetControlsReadOnlyRecursion(this, false); //先全開
WfSetControlReadonly(uGridMaster, true); //主表grid不可編輯
WfSetControlReadonly(new List <Control> {
ute_scacreu, ute_scacreg, udt_scacred
}, true);
WfSetControlReadonly(new List <Control> {
ute_scamodu, ute_scamodg, udt_scamodd
}, true);
WfSetControlReadonly(new List <Control> {
ute_scasecu, ute_scasecg
}, true);
WfSetControlReadonly(new List <Control> {
ute_sca05_c, ute_sca21_c, ute_sca24_c
}, true);
WfSetControlReadonly(new List <Control> {
ute_sca25_c, ute_sca26_c, ute_sca27_c
}, true);
if (FormEditMode == YREditType.修改)
{
WfSetControlReadonly(ute_sca01, true);
}
SelectNextControl(this.uTab_Header, true, true, true, false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfAppendUpdate()
{
icm_tb icmOrgModel;
DataTable dtIcm;
DataRow drIcm;
CommonBLL boAppend;
StringBuilder sbSql;
try
{
icmOrgModel = DrMaster.ToItem <icm_tb>();
boAppend = new CommonBLL(BoMaster.OfGetConntion());
boAppend.TRAN = BoMaster.TRAN;
boAppend.OfCreateDao("icm_tb", "*", "");
sbSql = new StringBuilder();
sbSql.AppendLine("SELECT * FROM icm_tb");
sbSql.AppendLine(string.Format("WHERE icm01='{0}'", icmOrgModel.icm02));
sbSql.AppendLine(string.Format("AND icm02='{0}'", icmOrgModel.icm01));
dtIcm = boAppend.OfGetDataTable(sbSql.ToString());
if (dtIcm.Rows.Count == 0)//新增
{
drIcm = dtIcm.NewRow();
drIcm["icm01"] = icmOrgModel.icm02;
drIcm["icm02"] = icmOrgModel.icm01;
drIcm["icm03"] = icmOrgModel.icm04;
drIcm["icm04"] = icmOrgModel.icm03;
drIcm["icm05"] = "";
drIcm["icmvali"] = icmOrgModel.icmvali;
drIcm["icmsecu"] = LoginInfo.UserNo;
drIcm["icmsecg"] = LoginInfo.GroupNo;
drIcm["icmcreu"] = LoginInfo.UserNo;
drIcm["icmcreg"] = LoginInfo.DeptNo;
drIcm["icmcred"] = Now;
dtIcm.Rows.Add(drIcm);
}
else
{
drIcm = dtIcm.Rows[0];
drIcm["icm03"] = icmOrgModel.icm04;
drIcm["icm04"] = icmOrgModel.icm03;
drIcm["icmvali"] = icmOrgModel.icmvali;
drIcm["icmmodu"] = LoginInfo.UserNo;
drIcm["icmmodg"] = LoginInfo.DeptNo;
drIcm["icmmodd"] = Now;
}
boAppend.OfUpdate(dtIcm);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfExecute()
{
vw_glab313 masterModel = null;
int chkCnts = 0;
StringBuilder sbResult = null;
try
{
//取得交易物件
BoMaster.TRAN = BoMaster.OfGetConntion().BeginTransaction();
BoGlab313.TRAN = BoMaster.TRAN;
masterModel = DrMaster.ToItem <vw_glab313>();
var securityString = WfGetSecurityString();
var resultList = BoGlab313.OfGlab313Post(masterModel, securityString, "", LoginInfo);
if (resultList == null || resultList.Count == 0)
{
WfShowBottomStatusMsg("無可過帳還原資料!");
BoGlab313.TRAN.Rollback();
return(true);
}
chkCnts = resultList.Where(p => p.Success == false).Count();
if (chkCnts > 0)
{
BoGlab313.TRAN.Rollback();
sbResult = new StringBuilder();
sbResult.AppendLine(string.Format("執行失敗!"));
sbResult.AppendLine(string.Format("過帳還原傳票筆數【{0}】 成功:【{1}】 失敗【{2}】",
resultList.Count,
resultList.Count - chkCnts,
chkCnts
));
sbResult.AppendLine();
sbResult.AppendLine(string.Format("錯誤內容如下"));
sbResult.AppendLine("====================================");
foreach (Result result in resultList.Where(p => p.Success == false))
{
sbResult.AppendLine(string.Format("key1:【{0}】 錯誤訊息:【{1}】", result.Key1, result.Message));
}
WfShowErrorMsg(sbResult.ToString());
BoGlab313.TRAN.Rollback();
return(false);
}
BoMaster.TRAN.Commit();
return(true);
}
catch (Exception ex)
{
if (BoMaster.TRAN != null)
{
BoMaster.TRAN.Rollback();
}
throw ex;
}
}
//*****************************表單自訂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;
}
}
protected override bool WfFormCheck()
{
vw_invb500 masterModel;
bab_tb l_bab = null;
string msg;
Control chkControl;
string chkColName;
int iChkDetailTab;
try
{
masterModel = DrMaster.ToItem <vw_invb500>();
chkColName = "ipa01"; //盤點單號
chkControl = ute_ipa01;
if (GlobalFn.varIsNull(masterModel.ipa01))
{
chkControl.Focus();
msg = TabMaster.AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
chkColName = "ipa03"; //盤點單號
chkControl = udt_ipa03;
if (GlobalFn.varIsNull(masterModel.ipa03))
{
chkControl.Focus();
msg = TabMaster.AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
chkColName = "icc02"; //倉庫
chkControl = ute_icc02;
if (GlobalFn.varIsNull(masterModel.icc02))
{
chkControl.Focus();
msg = TabMaster.AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
errorProvider.SetError(chkControl, msg);
WfShowErrorMsg(msg);
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override void WfActionClick(string pActionName)
{
vw_admq910 masterModel;
string killSql;
try
{
switch (pActionName.ToLower())
{
case "killsession":
if (DrMaster == null)
{
return;
}
masterModel = DrMaster.ToItem <vw_admq910>();
if (masterModel.blkBy <= 0)
{
WfShowBottomStatusMsg("連線未被Lock不可刪除");
return;
}
if (WfShowConfirmMsg("請確認是否要刪除連線?") == DialogResult.Yes)
{
killSql = string.Concat("kill ", masterModel.blkBy, ";");
BoMaster.OfExecuteNonquery(killSql);
WfShowBottomStatusMsg("連線刪除成功!");
if (WfQueryOk())
{
WfDisplayMode();
WfAfterfDisplayMode();
}
}
break;
case "refresh":
if (FormEditMode != YREditType.NA)
{
return;
}
//新增一列,模擬查詢
TabMaster.DtSource.Rows.Add(TabMaster.DtSource.NewRow());
WfGetActiveDatarow();
if (WfQueryOk())
{
WfDisplayMode();
WfAfterfDisplayMode();
}
break;
}
}
catch (Exception ex)
{
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 WfAppendUpdate()
{
UltraTreeNode parentsNode = null;
vw_glai100 masterModel = null;
string gba06_old = "", gba07_old = "";
try
{
masterModel = DrMaster.ToItem <vw_glai100>();
//這裡處理新增修改後的樹狀結構
//refresh父節點下的資料
if (FormEditMode == YREditType.新增)
{
parentsNode = WfGetParentsNode(masterModel);
var addNode = parentsNode.Nodes.Add(masterModel.gba01, string.Concat(masterModel.gba01, "-", masterModel.gba02));
uTree.Enabled = true; //這裡就要先打開,不然會無法設定activenode
uTree.ActiveNode = addNode;
}
else if (FormEditMode == YREditType.修改)
{
var activeNode = uTree.GetNodeByKey(masterModel.gba01);
uTree.Enabled = true; //這裡就要先打開,不然會無法設定activenode
uTree.ActiveNode = activeNode;
//檢查是否需要更新節點
gba06_old = GlobalFn.isNullRet(DrMaster["gba06", DataRowVersion.Original], "");
gba07_old = GlobalFn.isNullRet(DrMaster["gba07", DataRowVersion.Original], "");
if (gba06_old != masterModel.gba06 || gba07_old != masterModel.gba07)
{
if (masterModel.gba06 == "1") //統制科目
{
activeNode.Override.ActiveNodeAppearance.Image = ImgList.Images[GlobalPictuer.MENU_TREE_FOLDER_ACTIVE];
activeNode.Override.NodeAppearance.Image = ImgList.Images[GlobalPictuer.MENU_TREE_FOLDER];
}
else
{
activeNode.Override.ActiveNodeAppearance.Image = null;
activeNode.Override.NodeAppearance.Image = null;
}
if (gba07_old != masterModel.gba07)
{
var newParentsNode = uTree.GetNodeByKey(masterModel.gba07);
activeNode.Reposition(newParentsNode.Nodes);
uTree.ActiveNode = activeNode;
}
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
