protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
List <vw_admi110s> admi110sList;
int iChkCnts = 0;
try
{
#region 單頭-pick vw_admi110
if (e.Row.Table.Prefix.ToLower() == "vw_admi110")
{
switch (e.Column.ToLower())
{
case "adc01":
//if ((pNewValue == null ? "" : pNewValue).Length > 5)
//{
// pdr["ada02"] = 456;
// WfShowMsg("字串長度不可大於5!");
// return false;
//}
break;
}
}
#endregion
#region 單身-pick vw_admi110s
if (e.Row.Table.Prefix.ToLower() == "vw_admi110s")
{
admi110sList = e.Row.Table.ToList <vw_admi110s>();
switch (e.Column.ToLower())
{
case "add02":
if (GlobalFn.varIsNull(e.Value))
{
e.Row["add02_c"] = "";
return(true);
}
if (BoAdm.OfChkAdoPKExists(e.Value.ToString()) == false)
{
WfShowErrorMsg("無此程式編號!");
return(false);
}
iChkCnts = admi110sList.Where(p => p.add02 == e.Value.ToString()).Count();
if (iChkCnts > 1)
{
WfShowErrorMsg("該程式已在,請檢核!");
return(false);
}
e.Row["add02_c"] = BoAdm.OfGetAdo02(e.Value.ToString());
break;
}
}
#endregion
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_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;
}
}
private void FrmAdms801_Load(object sender, EventArgs e)
{
try
{
WfSetUltraTxtEditPick(ute_adb02);
ute_adb02.UseAppStyling = false;
ute_adb02.EditorButtonClick += new EditorButtonEventHandler(UltraTextEditor_EditorPickButtonClick);
if (LoginInfo != null)
{
if (GlobalFn.varIsNull(LoginInfo.CompNo))//表示第一次登入
{
var adaModel = BoSecurity.OfGetAdaModel(LoginInfo.UserNo);
ute_adb02.Text = adaModel.ada08;
}
else
{
ute_adb02.Text = LoginInfo.CompNo;
}
}
}
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_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;
}
}
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;
}
}
/// <summary>
/// 單檔,batch,report 專用的組合查詢
/// </summary>
/// <param name="pSqlParmList"></param>
/// <param name="pTabMaster"></param>
/// <returns></returns>
public string WfCombineQuerystring(TabInfo pTabMaster, out List <SqlParameter> pSqlParmList)
{
string rtnQueryString = "";
List <QueryInfo> queryInfoList;
QueryInfo queryModel;
try
{
queryInfoList = new List <QueryInfo>();
foreach (DataColumn dc in pTabMaster.DtSource.Columns)
{
if (GlobalFn.varIsNull(pTabMaster.DtSource.Rows[0][dc.ColumnName]))
{
continue;
}
queryModel = new QueryInfo();
queryModel.TableName = pTabMaster.ViewTable;
queryModel.ColumnName = dc.ColumnName;
queryModel.ColumnType = dc.Prefix.ToString();//改用記在 prefix的型別
queryModel.Value = pTabMaster.DtSource.Rows[0][dc.ColumnName];
queryInfoList.Add(queryModel);
}
rtnQueryString = WfGetQueryString(queryInfoList, out pSqlParmList);
}
catch (Exception ex)
{
throw ex;
}
return(rtnQueryString);
}
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_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_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;
}
}
//回傳值 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;
}
}
//回傳值 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_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_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 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 bool WfFormCheck()
{
vw_invi101s detailModel = null;
UltraGrid uGrid;
string msg;
string chkColName;
int iChkDetailTab;
try
{
#region 單身資料檢查
iChkDetailTab = 0;
uGrid = TabDetailList[iChkDetailTab].UGrid;
foreach (DataRow drTemp in TabDetailList[iChkDetailTab].DtSource.Rows)
{
if (drTemp.RowState == DataRowState.Unchanged)
{
continue;
}
detailModel = drTemp.ToItem <vw_invi101s>();
#region icn02-來源單位
chkColName = "icn02";
if (GlobalFn.varIsNull(detailModel.icn02))
{
this.uTab_Detail.SelectedTab = uTab_Detail.Tabs[iChkDetailTab];
msg = TabDetailList[iChkDetailTab].AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
WfShowErrorMsg(msg);
WfFindErrUltraGridCell(uGrid, drTemp, chkColName);
return(false);
}
#endregion
#region icn03-目的單位
chkColName = "icn03";
if (GlobalFn.varIsNull(detailModel.icn03))
{
this.uTab_Detail.SelectedTab = uTab_Detail.Tabs[iChkDetailTab];
msg = TabDetailList[iChkDetailTab].AzaTbList.Where(p => p.aza03 == chkColName).Select(p => p.aza04).FirstOrDefault();
msg += "不可為空白";
WfShowErrorMsg(msg);
WfFindErrUltraGridCell(uGrid, drTemp, chkColName);
return(false);
}
#endregion
}
#endregion
WfSetDetailPK();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 flase.未通過驗證,還原原來的值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
#region 單頭-pick vw_admi610
if (e.Row.Table.Prefix.ToLower() == "vw_admi610")
{
switch (e.Column.ToLower())
{
case "adm01": //目錄代碼
if (GlobalFn.varIsNull(e.Value))
{
e.Row["adm01_c"] = "";
break;
}
if (BoAdm.OfChkAdoPKExists(GlobalFn.isNullRet(e.Value, ""), "M") == false)
{
WfShowErrorMsg("無此目錄代碼");
return(false);
}
e.Row["adm01_c"] = BoAdm.OfGetAdo02(GlobalFn.isNullRet(e.Value, ""));
break;
}
}
#endregion
#region 單頭-pick vw_admi610s
if (e.Row.Table.Prefix.ToLower() == "vw_admi610s")
{
switch (e.Column.ToLower())
{
case "adm02": //程式代碼
if (GlobalFn.varIsNull(e.Value))
{
e.Row["adm02_c"] = "";
break;
}
if (BoAdm.OfChkAdoPKExists(GlobalFn.isNullRet(e.Value, "")) == false)
{
WfShowErrorMsg("無此程式設定資料");
return(false);
}
e.Row["adm02_c"] = BoAdm.OfGetAdo02(GlobalFn.isNullRet(e.Value, ""));
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
private bool WfIniDataSource(AdvanceQueryInfo pAdvQueryInfo)
{
UltraGrid uGrid;
try
{
uGrid = pAdvQueryInfo.UGrid;
if (GlobalFn.varIsNull(pAdvQueryInfo.Key))
{
WfShowErrorMsg("此查詢代碼,請檢核");
return(false);
}
var masterAzaList = BoMaster.OfGetAzaModels(pAdvQueryInfo.Key)
.Where(p => p.aza05.ToUpper() == "Y")
.ToList();
if (masterAzaList == null)
{
WfShowErrorMsg("無此查詢代碼,請檢核");
return(false);
}
else
{
pAdvQueryInfo.ConditionList = new List <ConditionInfo>();
var detailAzaList = BoMaster.OfGetAzaModels(pAdvQueryInfo.Key)
.Where(p => p.aza05.ToUpper() == "Y")
.ToList();
foreach (aza_tb azaModel in detailAzaList)
{
pAdvQueryInfo.ConditionList.Add(new ConditionInfo()
{
TableName = azaModel.aza01,
Condition = "",
ColumnName = azaModel.aza03,
ColumnDesc = azaModel.aza04,
ColumnType = azaModel.aza08,
Value = null,
orderSeq = azaModel.aza06
}
);
}
}
//初始化主檔GRID
uGrid.DataSource = new List <ConditionInfo>();
uGrid.DataBind();
WfSetGridHeader(uGrid);
WfSetAppearance(uGrid);
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
//回傳值 true.通過驗證 false.未通過驗證,會把值還原
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
#region 單頭- vw_basi070
if (e.Row.Table.Prefix.ToLower() == "vw_basi070")
{
switch (e.Column.ToLower())
{
case "bej01":
if (GlobalFn.isNullRet(e.Value, "") == "")
{
return(true);
}
if (BoBas.OfChkBejPkExists(GlobalFn.isNullRet(e.Value.ToString(), "")) == true)
{
WfShowErrorMsg("單位已存在,請檢核!");
return(false);
}
break;
case "bej03": //小數位數
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (!GlobalFn.isNumeric(e.Value.ToString()))
{
WfShowErrorMsg("請輸入數字!");
return(false);
}
if (GlobalFn.isNullRet(e.Value, 0.0M) < 0 || GlobalFn.isNullRet(e.Value, 0.0M) > 5)
{
WfShowErrorMsg("請輸入區間數字0-5!");
return(false);
}
DrMaster["bej03"] = Math.Round(Convert.ToDecimal(e.Value), 0, MidpointRounding.AwayFromZero); //自動四捨伍入
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfQueryOk()
{
//List<string> actAllArray = null;
List <string> actChooseList = null;
try
{
DtMaster.Rows.Clear();
if (!GlobalFn.varIsNull(_actAllList))
{
//actAllArray = _actAllList.Split(new char[] { ',' })
// .ToList<string>();
if (!GlobalFn.varIsNull(_actChoose))
{
actChooseList = _actChoose.Split(new char[] { ',' })
.ToList <string>();
}
foreach (adq_tb adqModel in _actAllList)
{
var drNew = DtMaster.NewRow();
drNew["is_pick"] = "N";
if (actChooseList != null)
{
var chkCnts = actChooseList.Where(p => p.ToLower() == adqModel.adq02.ToLower()).Count();
if (chkCnts > 0)
{
drNew["is_pick"] = "Y";
}
}
drNew["action"] = adqModel.adq02;
drNew["action_c"] = adqModel.adq03;
DtMaster.Rows.Add(drNew);
}
//DtMaster = BoMaster.OfGetDataTable(StrSqlBody + extendSqlWhere, SqlParmTotalList.ToArray());
}
BindingMaster.DataSource = DtMaster;
//改取sort後的第一筆
if (DtMaster != null && DtMaster.Rows.Count > 0)
{
uGrid_Master.Rows.GetRowWithListIndex(0).Selected = true;
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override Boolean WfDisplayMode()
{
vw_zinvt001 masterModel = null;
try
{
if (DrMaster != null && DrMaster.RowState != DataRowState.Detached)
{
masterModel = DrMaster.ToItem <vw_zinvt001>();
WfSetDocPicture("", masterModel.igaconf, "", pbxDoc);
if ((FormEditMode == YREditType.新增 || FormEditMode == YREditType.修改))
{
if (BaaModel == null || GlobalFn.varIsNull(BaaModel.baa04))
{
WfShowErrorMsg("未設定本國幣別,請先設定!");
}
BekModel = BoBas.OfGetBekModel(BaaModel.baa04);
if (BekModel == null)
{
WfShowErrorMsg(string.Format("未設定此幣別{0},於幣別基本資料檔,請先設定!", BaaModel.baa04));
}
}
}
else
{
WfSetDocPicture("", "", "", pbxDoc);
}
if (FormEditMode == YREditType.NA)
{
WfSetControlsReadOnlyRecursion(this, true);
}
else
{
WfSetControlsReadOnlyRecursion(this, false); //先全開
WfSetControlReadonly(uGridMaster, true); //主表grid不可編輯
WfSetControlsReadOnlyRecursion(ute_iga01.Parent, true);
WfSetControlsReadOnlyRecursion(ute_igaconu.Parent, true);
//明細先全開,並交由 WfSetDetailDisplayMode處理
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override Boolean WfDisplayMode()
{
vw_invi010 masterModel;
try
{
if (FormEditMode == YREditType.NA)
{
WfSetControlsReadOnlyRecursion(this, true);
}
else
{
masterModel = DrMaster.ToItem <vw_invi010>();
WfSetControlsReadOnlyRecursion(this, false);
WfSetControlReadonly(uGridMaster, true);//主表grid不可編輯
WfSetControlReadonly(new List <Control> {
ute_babcreu, ute_babcreg, udt_babcred
}, true);
WfSetControlReadonly(new List <Control> {
ute_babmodu, ute_babmodg, udt_babmodd
}, true);
WfSetControlReadonly(new List <Control> {
ute_babsecu, ute_babsecg
}, true);
WfSetControlReadonly(ute_bab04_c, true);
if (GlobalFn.varIsNull(masterModel.bab03))
{
WfSetControlReadonly(ute_bab04, true);
}
else
{
WfSetControlReadonly(ute_bab04, false);
}
;
if (FormEditMode == YREditType.修改)
{
WfSetControlReadonly(ute_bab01, true);
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//*****************************表單自訂Fuction****************************************
#region wfAutoCodeResult 顯示編碼結果
public void wfAutoCodeResult()
{
vw_basi001 masterModel;
string autoCodeResult = "";
string tempString = "";
if (DrMaster == null)
{
ute_result.Text = "";
}
masterModel = DrMaster.ToItem <vw_basi001>();
if (GlobalFn.varIsNull(masterModel.baa06) ||
GlobalFn.varIsNull(masterModel.baa07) ||
GlobalFn.varIsNull(masterModel.baa08)
)
{
ute_result.Text = "";
}
//先處理單別位數
tempString = "".PadLeft(GlobalFn.isNullRet(masterModel.baa06, 0), 'X');
autoCodeResult += tempString + "-";
//再處理自動編號方式
tempString = "";
switch (masterModel.baa07)
{
case "1":
tempString = "";
break;
case "2":
tempString = "yyMM";
break;
case "3":
tempString = "yyww";
break;
case "4":
tempString = "yyMMdd";
break;
}
autoCodeResult += tempString;
//最後處理流水編
var flowLength = GlobalFn.isNullRet(masterModel.baa08 - tempString.Length, 0);
tempString = "".PadLeft(flowLength, '9');
autoCodeResult += tempString;
ute_result.Text = autoCodeResult;
}
protected override bool WfPreInUpdateModeCheck()
{
vw_glat200 masterModel;
string sqlSelect = "";
List <SqlParameter> sqlParmList = null;
int chkCnts = 0;
try
{
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);
}
}
if (masterModel.gea02 == "AR" && masterModel.gea03 == 2) //應收帳款
{
sqlSelect = @"SELECT COUNT(1) FROM cfa_tb WHERE cfa01=@cfa01 AND cfaconf<>'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)
{
throw ex;
}
}
protected override bool WfPickClickOnEditMode(object sender, string pColName, DataRow pDr)
{
vw_invi010 masterModel;
try
{
masterModel = DrMaster.ToItem <vw_invi010>();
//this.MsgInfoReturned = new MessageInfo();
MessageInfo messageModel = new MessageInfo();
#region 單頭-pick vw_invi010
if (pDr.Table.Prefix.ToLower() == "vw_invi010")
{
switch (pColName.ToLower())
{
case "bab04": //單據性質
if (GlobalFn.varIsNull(masterModel.bab03))
{
WfShowErrorMsg("請先輸入模組別!");
return(false);
}
messageModel.ParamSearchList = new List <SqlParameter>();
messageModel.ParamSearchList.Add(new SqlParameter("@azf01", masterModel.bab03));
WfShowPickUtility("p_azf1", messageModel);
if (messageModel.Result == System.Windows.Forms.DialogResult.OK)
{
if (messageModel.DataRowList.Count > 0)
{
pDr[pColName] = GlobalFn.isNullRet(messageModel.DataRowList[0]["azf02"], "");
}
else
{
pDr[pColName] = "";
}
}
//if (messageModel != null && messageModel.DataRowList.Count > 0)
//{
// pDr[pColName] = GlobalFn.isNullRet(messageModel.DataRowList[0]["azf02"], "");
//}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfPreInsertDetailCheck(int pCurTabDetail)
{
vw_taxi020 masterModel = null;
string sqlSelect = "";
List <SqlParameter> sqlParms = null;
int chkCnts = 0;
try
{
masterModel = DrMaster.ToItem <vw_taxi020>();
if (GlobalFn.varIsNull(masterModel.tbe01) || masterModel.tbe01 == 0 ||
GlobalFn.varIsNull(masterModel.tbe02) || masterModel.tbe02 == 0 ||
GlobalFn.varIsNull(masterModel.tbe03) || masterModel.tbe03 == 0
)
{
WfShowErrorMsg("請先新增單頭資料!");
return(false);
}
if (TabDetailList[0].DtSource.Rows.Count == 0)
{
//檢查單頭資料是否存在
sqlSelect = @"SELECT COUNT(1) FROM tbe_tb
WHERE tbe01=@tbe01
AND tbe11=@tbe11
AND NOT (@tbe02>tbe03
OR tbe03<@tbe02)
";
sqlParms = new List <SqlParameter>();
sqlParms.Add(new SqlParameter("@tbe01", masterModel.tbe01));
sqlParms.Add(new SqlParameter("@tbe02", masterModel.tbe02));
sqlParms.Add(new SqlParameter("@tbe03", masterModel.tbe03));
sqlParms.Add(new SqlParameter("@tbe11", masterModel.tbe11));
chkCnts = GlobalFn.isNullRet(BoTax.OfGetFieldValue(sqlSelect, sqlParms.ToArray()), 0);
if (chkCnts > 1)
{
WfShowErrorMsg("該年月+申報別資料有重疊,請先查詢後再做修改!");
return(false);
}
WfSetControlsReadOnlyRecursion(ute_tbe01.Parent, true);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 false未通過驗證,還原輸入的值 true.未通過驗證,保留原值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
beb_tb bebModel;
try
{
#region 單頭-pick vw_basi030
if (e.Row.Table.Prefix.ToLower() == "vw_basi030")
{
switch (e.Column.ToLower())
{
case "bec01": //員工編號
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (BoBas.OfChkBecPKValid(GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("員工編號已存在,請檢核!");
return(false);
}
break;
case "bec03": //部門
if (GlobalFn.varIsNull(e.Value))
{
e.Row["bec03_c"] = "";
return(true);
}
if (BoBas.OfChkBebPkValid(GlobalFn.isNullRet(e.Value, "")) == false)
{
WfShowErrorMsg("查無此部門,請檢核!");
return(false);
}
bebModel = BoBas.OfGetBebModel(GlobalFn.isNullRet(e.Value, ""));
e.Row["bec03_c"] = GlobalFn.isNullRet(bebModel.beb03, "");
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_invi101 masterModel = null;
try
{
#region 單頭-pick vw_invi101
if (e.Row.Table.Prefix.ToLower() == "vw_invi101s")
{
masterModel = DrMaster.ToItem <vw_invi101>();
switch (e.Column.ToLower())
{
case "icn02": //來源單位
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (BoBas.OfChkBejPkValid(GlobalFn.isNullRet(e.Value, "")) == false)
{
WfShowErrorMsg("無此單位存在,請檢核!");
return(false);
}
break;
case "icn03": //目的單位
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (BoBas.OfChkBejPkValid(GlobalFn.isNullRet(e.Value, "")) == false)
{
WfShowErrorMsg("無此單位存在,請檢核!");
return(false);
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 false未通過驗證,還原輸入的值 true.未通過驗證,保留原值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_basi020 masterModel = null;
try
{
masterModel = DrMaster.ToItem <vw_basi020>();
#region 單頭-pick vw_basi020
if (e.Row.Table.Prefix.ToLower() == "vw_basi020")
{
switch (e.Column.ToLower())
{
case "beb01": //部門編號
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (BoBas.OfChkBebPkValid(GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("部門編號已存在,請檢核!");
return(false);
}
break;
case "beb02": //部門簡稱
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (GlobalFn.varIsNull(masterModel.beb03))
{
e.Row["beb03"] = e.Value;
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
