protected override bool WfPreDeleteDetailCheck(int pCurTabDetail, DataRow pDrDetail) { vw_taxi020s detailModel = null; try { detailModel = pDrDetail.ToItem <vw_taxi020s>(); if (!GlobalFn.varIsNull(detailModel.tbe09)) { WfShowErrorMsg("已有開立發票,不可刪除!"); return(false); } return(true); } catch (Exception ex) { throw ex; } }
private void WfSetTotalCnts(DataRow drTbe) { vw_taxi020s detailModel = null; int begNo, endNo; try { detailModel = drTbe.ToItem <vw_taxi020s>(); if (GlobalFn.varIsNull(detailModel.tbe07) || GlobalFn.varIsNull(detailModel.tbe08)) { drTbe["total_cnts"] = 0; return; } begNo = Convert.ToInt32(detailModel.tbe07.Substring(2, 8)); endNo = Convert.ToInt32(detailModel.tbe08.Substring(2, 8)); drTbe["total_cnts"] = endNo - begNo + 1; } catch (Exception ex) { throw ex; } }
protected override bool WfFormCheck() { vw_taxi020 masterModel = null; vw_taxi020s detailModel = null; List <vw_taxi020s> detailList = null; UltraGrid uGrid; string msg; Control chkControl; string chkColName; int iChkDetailTab, chkCnts; try { masterModel = DrMaster.ToItem <vw_taxi020>(); #region 單頭資料檢查 chkColName = "tbe01"; //發票年度 chkControl = ute_tbe01; if (GlobalFn.varIsNull(masterModel.tbe01)) { 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); } chkColName = "tbe02"; //發票月份-起 chkControl = ute_tbe02; if (GlobalFn.varIsNull(masterModel.tbe02)) { 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); } chkColName = "tbe03"; //發票月份-迄 chkControl = ute_tbe03; if (GlobalFn.varIsNull(masterModel.tbe03)) { 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 #region 單身資料檢查 iChkDetailTab = 0; uGrid = TabDetailList[iChkDetailTab].UGrid; detailList = TabDetailList[iChkDetailTab].DtSource.ToList <vw_taxi020s>(); foreach (DataRow drTemp in TabDetailList[iChkDetailTab].DtSource.Rows) { if (drTemp.RowState == DataRowState.Unchanged) { continue; } detailModel = drTemp.ToItem <vw_taxi020s>(); chkColName = "tbe04"; //發票別 if (GlobalFn.varIsNull(detailModel.tbe04)) { 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); } chkColName = "tbe05"; //發票別 if (GlobalFn.varIsNull(detailModel.tbe05)) { 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); } chkColName = "tbe06"; //發票別 if (GlobalFn.varIsNull(detailModel.tbe06)) { 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); } //檢查發票別+聯數+簿號 在單身是否重覆 chkCnts = detailList.Where(p => GlobalFn.isNullRet(p.tbe04, "").ToUpper() == detailModel.tbe04.ToUpper() && GlobalFn.isNullRet(p.tbe05, "").ToUpper() == detailModel.tbe05.ToUpper() && p.tbe06 == detailModel.tbe06) .Count(); if (chkCnts > 1) { this.uTab_Detail.SelectedTab = uTab_Detail.Tabs[iChkDetailTab]; msg = string.Format("發票別+聯數+簿號有重覆,請檢核!"); WfShowErrorMsg(msg); WfFindErrUltraGridCell(uGrid, drTemp, chkColName); return(false); } //檢查key值是否存在 if (drTemp.RowState == DataRowState.Added) { chkColName = "tbe04"; if (BoTax.OfChkTbePKExists(detailModel.tbe01, detailModel.tbe02, detailModel.tbe03, detailModel.tbe04, detailModel.tbe05, detailModel.tbe06) == true) { this.uTab_Detail.SelectedTab = uTab_Detail.Tabs[iChkDetailTab]; msg = string.Format("發票本已存在,請檢核!"); WfShowErrorMsg(msg); WfFindErrUltraGridCell(uGrid, drTemp, chkColName); } } chkColName = "tbe07"; //起始發票號碼 if (GlobalFn.varIsNull(detailModel.tbe07)) { 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); } chkColName = "tbe08"; //截止發票號碼 if (GlobalFn.varIsNull(detailModel.tbe08)) { 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); } //檢查字軌是否相同 if (detailModel.tbe07.ToUpper().Substring(0, 2) != detailModel.tbe08.ToUpper().Substring(0, 2)) { this.uTab_Detail.SelectedTab = uTab_Detail.Tabs[iChkDetailTab]; msg = "發票字軌不同,請檢核!"; WfShowErrorMsg(msg); WfFindErrUltraGridCell(uGrid, drTemp, chkColName); return(false); } } #endregion return(true); } catch (Exception ex) { throw ex; } }
//回傳值 true.通過驗證 false.未通過驗證,會把值還原 protected override bool WfItemCheck(object sender, ItemCheckInfo e) { vw_taxi020 masterModel = null; vw_taxi020s detailModel = null; List <vw_taxi020s> detailList = null; UltraGrid uGrid = null; tba_tb tbaModel = null; int begNo, endNo, chkBegNo, chkEndNo; int ChkCnts = 0; try { masterModel = DrMaster.ToItem <vw_taxi020>(); #region 單頭-vw_taxi020 if (e.Row.Table.Prefix.ToLower() == "vw_taxi020") { switch (e.Column.ToLower()) { case "tbe01": if (GlobalFn.isNullRet(e.Value, "") == "") { return(true); } if (Convert.ToInt32(e.Value) <= 0) { WfShowErrorMsg("不可為0或負數!"); return(false); } break; case "tbe11": //申報別 if (GlobalFn.isNullRet(e.Value, "") == "") { return(true); } if (BoTax.OfChkTbaPKExists(GlobalFn.isNullRet(e.Value, "")) == false) { WfShowErrorMsg("無此申報別"); return(false); } tbaModel = BoTax.OfGetTbaModel(e.Value.ToString()); DrMaster["tbe11_c"] = tbaModel.tba04; break; case "tbe02": if (GlobalFn.isNullRet(e.Value, "") == "") { return(true); } if (Convert.ToInt32(e.Value) <= 0) { WfShowErrorMsg("不可為0或負數!"); return(false); } if (masterModel.tbe03 != 0 && Convert.ToInt32(e.Value) > masterModel.tbe03) { WfShowErrorMsg("發票年月起不得大於迄月!"); return(false); } break; case "tbe03": if (GlobalFn.isNullRet(e.Value, "") == "") { return(true); } if (Convert.ToInt32(e.Value) <= 0) { WfShowErrorMsg("不可為0或負數!"); return(false); } if (masterModel.tbe02 != 0 && Convert.ToInt32(e.Value) < masterModel.tbe02) { WfShowErrorMsg("發票年月起不得大於迄月!"); return(false); } break; } } #endregion #region 單身-vw_taxi020s if (e.Row.Table.Prefix.ToLower() == "vw_taxi020s") { uGrid = sender as UltraGrid; detailModel = e.Row.ToItem <vw_taxi020s>(); detailList = e.Row.Table.ToList <vw_taxi020s>(); switch (e.Column.ToLower()) { case "tbe04": //發票別 if (GlobalFn.varIsNull(e.Value)) { return(true); } if (!GlobalFn.varIsNull(e.Value) && !GlobalFn.varIsNull(detailModel.tbe05) && detailModel.tbe06 > 0 && detailList.Count > 1 ) { if (WfChktbe04tbe05tbe06(e.Value.ToString(), detailModel.tbe05, detailModel.tbe06) == false) { return(false); } } break; case "tbe05": //聯數 if (GlobalFn.varIsNull(e.Value)) { return(true); } if (!GlobalFn.varIsNull(detailModel.tbe04) && !GlobalFn.varIsNull(e.Value) && detailModel.tbe06 > 0 && detailList.Count > 1 ) { if (WfChktbe04tbe05tbe06(detailModel.tbe04, e.Value.ToString(), detailModel.tbe06) == false) { return(false); } } break; case "tbe06": //簿號 if (GlobalFn.varIsNull(e.Value)) { return(true); } if (!GlobalFn.varIsNull(detailModel.tbe04) && !GlobalFn.varIsNull(detailModel.tbe05) && Convert.ToInt32(detailModel.tbe06) > 0 && detailList.Count > 1 ) { if (WfChktbe04tbe05tbe06(detailModel.tbe04, e.Value.ToString(), detailModel.tbe06) == false) { return(false); } } break; case "tbe07": //起始發票號碼 if (GlobalFn.varIsNull(e.Value)) { return(true); } if (GlobalFn.varIsNull(detailModel.tbe05)) { return(true); } if (e.Value.ToString().Length != 10) { WfShowErrorMsg("發票號碼應為10碼!"); return(false); } if (!GlobalFn.isEnglishLettrs(e.Value.ToString().Substring(0, 2))) { WfShowErrorMsg("發票前兩碼僅能輸入英文字母!"); return(false); } if (!GlobalFn.isNumberCharachter(e.Value.ToString().Substring(2, 8))) { WfShowErrorMsg("發票後八碼僅能輸入數字!"); return(false); } if (!GlobalFn.varIsNull(detailModel.tbe08)) { begNo = Convert.ToInt32(e.Value.ToString().Substring(2, 8)); endNo = Convert.ToInt32(detailModel.tbe08.Substring(2, 8)); if (e.Value.ToString().Substring(0, 2) != detailModel.tbe08.Substring(0, 2)) { WfShowErrorMsg("發票字軌應相同,請檢核!"); return(false); } if (begNo > endNo) { WfShowErrorMsg("發票號碼,起不得大於迄!"); return(false); } //檢查明細中是否有發票重疊 ChkCnts = detailList.Where(p => !GlobalFn.varIsNull(p.tbe07) && !GlobalFn.varIsNull(p.tbe08) && p.tbe07.Substring(0, 2).ToUpper() == detailModel.tbe07.Substring(0, 2).ToUpper() && !(endNo <Convert.ToInt32(p.tbe07.Substring(2, 8)) || begNo> Convert.ToInt32(p.tbe08.Substring(2, 8))) ).Count(); if (ChkCnts > 1) { WfShowErrorMsg("輸入發票有重覆,請檢核!"); return(false); } } WfSetTotalCnts(e.Row); break; case "tbe08": //截止發票號碼 if (GlobalFn.varIsNull(e.Value)) { return(true); } if (GlobalFn.varIsNull(detailModel.tbe05)) { return(true); } if (e.Value.ToString().Length != 10) { WfShowErrorMsg("發票號碼應為10碼!"); return(false); } if (!GlobalFn.isEnglishLettrs(e.Value.ToString().Substring(0, 2))) { WfShowErrorMsg("發票前兩碼僅能輸入英文字母!"); return(false); } if (!GlobalFn.isNumberCharachter(e.Value.ToString().Substring(2, 8))) { WfShowErrorMsg("發票後八碼僅能輸入數字!"); return(false); } if (!GlobalFn.varIsNull(detailModel.tbe08)) { begNo = Convert.ToInt32(detailModel.tbe08.Substring(2, 8)); endNo = Convert.ToInt32(e.Value.ToString().Substring(2, 8)); if (e.Value.ToString().Substring(0, 2) != detailModel.tbe07.Substring(0, 2)) { WfShowErrorMsg("發票字軌應相同,請檢核!"); return(false); } if (begNo > endNo) { WfShowErrorMsg("發票號碼,起不得大於迄!"); return(false); } //檢查明細中是否有發票重疊 ChkCnts = detailList.Where(p => !GlobalFn.varIsNull(p.tbe07) && !GlobalFn.varIsNull(p.tbe08) && p.tbe07.Substring(0, 2).ToUpper() == detailModel.tbe07.Substring(0, 2).ToUpper() && !(endNo <Convert.ToInt32(p.tbe07.Substring(2, 8)) || begNo> Convert.ToInt32(p.tbe08.Substring(2, 8))) ).Count(); if (ChkCnts > 1) { WfShowErrorMsg("輸入發票有重覆,請檢核!"); return(false); } } WfSetTotalCnts(e.Row); break; } } #endregion return(true); } catch (Exception ex) { throw ex; } }
protected override bool WfPickClickOnEditMode(object sender, string pColName, DataRow pDr) { try { vw_taxi020 masterModel = null; vw_taxi020s detailModel = null; //this.MsgInfoReturned = new MessageInfo(); MessageInfo messageModel = new MessageInfo(); #region 單頭-pick vw_stpt400 if (pDr.Table.Prefix.ToLower() == "vw_taxi020") { masterModel = DrMaster.ToItem <vw_taxi020>(); switch (pColName.ToLower()) { case "tbe11": //申報別 messageModel.ParamSearchList = new List <SqlParameter>(); messageModel.IsAutoQuery = true; WfShowPickUtility("p_tba", messageModel); if (messageModel.Result == System.Windows.Forms.DialogResult.OK) { if (messageModel.DataRowList.Count > 0) { pDr[pColName] = GlobalFn.isNullRet(messageModel.DataRowList[0]["tba01"], ""); } else { pDr[pColName] = ""; } } break; } } #endregion #region 單身-pick vw_stpt400s if (pDr.Table.Prefix.ToLower() == "vw_taxi020s") { //masterModel = DrMaster.ToItem<vw_stpt400>(); //detailModel = pDr.ToItem<vw_stpt400s>(); //switch (pColName.ToLower()) //{ // case "sgb03"://料號 // WfShowPickUtility("p_ica1", messageModel); // if (messageModel.Result == System.Windows.Forms.DialogResult.OK) // { // if (messageModel.DataRowList.Count > 0) // pDr[pColName] = GlobalFn.isNullRet(messageModel.DataRowList[0]["ica01"], ""); // else // pDr[pColName] = ""; // } // break; //} } #endregion return(true); } catch (Exception ex) { throw ex; } }