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; } }