//回傳值 false未通過驗證,還原輸入的值 true.未通過驗證,保留原值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
#region 單頭-pick vw_basi090
if (e.Row.Table.Prefix.ToLower() == "vw_basi090")
{
switch (e.Column.ToLower())
{
#region bel01 貨運方式check
case "bel01":
if (BoBas.OfChkBelPKExists(GlobalFn.isNullRet(e.Value.ToString(), "")) == true)
{
WfShowErrorMsg("貨運方式編號已存在,請檢核!");
return(false);
}
break;
#endregion
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
//回傳值 false未通過驗證,還原輸入的值 true.未通過驗證,保留原值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
#region 單頭-pick vw_stpi040
if (e.Row.Table.Prefix.ToLower() == "vw_stpi040")
{
switch (e.Column.ToLower())
{
#region beg01 運輸地點check
case "sbg01":
if (BoStp.OfChkSbgPKExists(GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("運輸地點編號已存在,請檢核!");
return(false);
}
break;
#endregion
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
//回傳值 false未通過驗證,還原輸入的值 true.未通過驗證,保留原值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
#region 單頭-pick vw_basi020
if (e.Row.Table.Prefix.ToLower() == "vw_basi050")
{
switch (e.Column.ToLower())
{
#region bef02 付款條件編號check
case "bef02":
if (BoBas.OfChkBefPKValid(GlobalFn.isNullRet(e.Row["bef01"].ToString(), ""), GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("付款條件編號已存在,請檢核!");
return(false);
}
break;
#endregion
}
}
#endregion
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;
}
}
//回傳值 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_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;
}
}
//回傳值 false未通過驗證,還原輸入的值 true.未通過驗證,保留原值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
#region 單頭-pick vw_puri020
if (e.Row.Table.Prefix.ToLower() == "vw_puri020")
{
switch (e.Column.ToLower())
{
#region pba01 廠商分類編號check
case "pba01":
if (BoPur.OfChkPbaPKExists(GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("廠商分類編號已存在,請檢核!");
return(false);
}
break;
#endregion
}
}
#endregion
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;
}
}
//protected internal override void UcDatePicker_Validating(object sender, CancelEventArgs e)
//{
// string colName = "";
// string currentValue;
// string ctlValue;
// UcDatePicker control = sender as UcDatePicker;
// try
// {
// if (IsInSaveCancle == true || IsInCRUDIni == true)
// return;
// if (IsInFormLoading == true)
// return;
// colName = control.Tag.ToString();
// IsItemchkValid = true;
// currentValue = DRMASTER[colName] == null ? "" : DRMASTER[colName].ToString();
// ctlValue = control.Value == null ? "" : control.Value.ToString();
// if (ctlValue != currentValue)
// {
// if (WfItemCheck(sender, colName, ctlValue, DRMASTER) == false)
// {
// e.Cancel = true;
// IsItemchkValid = false;
// control.Value = OldValue;
// }
// else
// {
// IsChanged = true;
// DRMASTER.EndEdit();
// }
// }
// }
// catch (Exception ex)
// {
// e.Cancel = true;
// control.Value = OldValue;
// IsItemchkValid = false;
// WfShowMsg(ex.ToString());
// }
//}
#endregion
#region UltraDateTimeEditor_Validating 時間控制項
protected internal override void UltraDateTimeEditor_Validating(object sender, CancelEventArgs e)
{
string colName = "";
//DateTime? dbValue = null;
UltraDateTimeEditor control = sender as UltraDateTimeEditor;
try
{
if (IsInSaveCancle == true || IsInCRUDIni == true)
{
return;
}
if (IsInFormLoading == true)
{
return;
}
//if (FormEditMode == YREditType.查詢 || FormEditMode == YREditType.NA)
// return;
WfCleanBottomMsg();
IsInItemchecking = true;
IsItemchkValid = true;
colName = control.Tag.ToString();
if (GlobalFn.isNullRet(control.Value, "") != GlobalFn.isNullRet(OldValue, ""))
{
//WfSetBllTransaction();
var itemCheckInfo = new ItemCheckInfo();
itemCheckInfo.Row = DrMaster;
itemCheckInfo.Value = control.Value;
itemCheckInfo.Column = colName;
if (WfItemCheck(sender, itemCheckInfo) == false)
{
e.Cancel = true;
IsItemchkValid = false;
control.Value = OldValue;
}
else
{
IsChanged = true;
DrMaster.EndEdit();
}
}
}
catch (Exception ex)
{
e.Cancel = true;
IsItemchkValid = false;
control.Value = OldValue;
WfShowErrorMsg(ex.ToString());
}
finally
{
//IsInButtonClick = false;
IsInItemchecking = false;
}
}
protected internal override void UcCheckBox_Validating(object sender, CancelEventArgs e)
{
string colName = "";
string dbValue = "";
//string displayValue = "";
YR.Util.Controls.UcCheckBox control = sender as YR.Util.Controls.UcCheckBox;
try
{
if (IsInSaveCancle == true || IsInCRUDIni == true)
{
return;
}
if (IsInFormLoading == true)
{
return;
}
//if (FormEditMode == YREditType.查詢 || FormEditMode == YREditType.NA)
// return;
WfCleanBottomMsg();
IsItemchkValid = true;
colName = control.Tag.ToString();
dbValue = DrMaster[colName] == null ? "" : DrMaster[colName].ToString();
//displayValue = control.CheckValue == null ? "" : control.CheckValue.ToString();
if (control.CheckValue != OldValue)
{
//WfSetBllTransaction();
var itemCheckInfo = new ItemCheckInfo();
itemCheckInfo.Row = DrMaster;
itemCheckInfo.Value = control.CheckValue;
itemCheckInfo.Column = colName;
if (WfItemCheck(sender, itemCheckInfo) == false)
{
e.Cancel = true;
IsItemchkValid = false;
control.CheckValue = OldValue;
}
else
{
IsChanged = true;
DrMaster.EndEdit();
}
}
}
catch (Exception ex)
{
e.Cancel = true;
IsItemchkValid = false;
control.CheckValue = OldValue;
WfShowErrorMsg(ex.ToString());
}
}
//回傳值 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;
}
}
protected virtual bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 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;
}
}
//回傳值 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;
}
}
//回傳值 true.通過驗證 false.未通過驗證,會把值還原
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
int iChkCnts = 0;
vw_zinvt001 masterModel = null;
vw_zinvt001s detailModel = null;
List <vw_zinvt001s> detailList = null;
bab_tb l_bab = null;
UltraGrid uGrid = null;
try
{
masterModel = DrMaster.ToItem <vw_zinvt001>();
#region 單身-pick vw_zinvt001s
if (e.Row.Table.Prefix.ToLower() == "vw_zinvt001s")
{
uGrid = sender as UltraGrid;
detailModel = e.Row.ToItem <vw_zinvt001s>();
detailList = e.Row.Table.ToList <vw_zinvt001s>();
l_bab = BoBas.OfGetBabModel(masterModel.iga01);
switch (e.Column.ToLower())
{
case "igb07": //異動成本
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (detailModel.igb07 < 0)
{
WfShowErrorMsg("單價不可小於0!");
return(false);
}
//依幣別檔設定單價小數
e.Row[e.Column] = GlobalFn.Round(detailModel.igb07, BekModel.bek03);
WfSetDetailAmt(e.Row);
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
baa_tb baaModel;
vw_glai010 masterModel;
string errMsg;
try
{
baaModel = BoBas.OfGetBaaModel();
masterModel = DrMaster.ToItem <vw_glai010>();
#region 單頭-pick vw_invi010
if (e.Row.Table.Prefix.ToLower() == "vw_glai010")
{
switch (e.Column.ToLower())
{
case "gac01": //單別
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (GlobalFn.isNullRet(baaModel.baa06.Value, 0) != GlobalFn.isNullRet(e.Value, "").Length)
{
errMsg = string.Format("單別限定長度為{0}碼", GlobalFn.isNullRet(baaModel.baa06, ""));
WfShowErrorMsg(errMsg);
return(false);
}
if (BoBas.OfChkBabPKValid(GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("單別已存在,請檢核!");
return(false);
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,會把值還原
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
int iChkCnts = 0;
vw_admi602s detailModel = null;
List <vw_admi602s> detailList = null;
UltraGrid uGrid;
try
{
#region 單身-vw_admi602s
if (e.Row.Table.Prefix.ToLower() == "vw_admi602s")
{
uGrid = sender as UltraGrid;
detailModel = e.Row.ToItem <vw_admi602s>();
switch (e.Column.ToLower())
{
case "adq02": //功能代號
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
detailList = e.Row.Table.ToList <vw_admi602s>();
iChkCnts = detailList.Where(p => GlobalFn.isNullRet(p.adq02, 0) == GlobalFn.isNullRet(e.Value, 0))
.Count();
if (iChkCnts > 1)
{
WfShowErrorMsg("功能代號已存在,請檢核!");
return(false);
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,會把值還原
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
int iChkCnts = 0;
vw_invt522 masterModel = null;
vw_invt522s detailModel = null;
List <vw_invt521s> listDetails = null;
UltraGrid uGrid = null;
try
{
masterModel = DrMaster.ToItem <vw_invt522>();
#region 單身-pick vw_invt521s
if (e.Row.Table.Prefix.ToLower() == "vw_invt522s")
{
uGrid = sender as UltraGrid;
detailModel = e.Row.ToItem <vw_invt522s>();
listDetails = e.Row.Table.ToList <vw_invt521s>();
switch (e.Column.ToLower())
{
case "ipb50": //監盤數量
if (GlobalFn.varIsNull(e.Value))
{
WfShowErrorMsg("請輸入異動數量!");
return(false);
}
if (GlobalFn.isNullRet(e.Value, 0) < 0)
{
WfShowErrorMsg("數量不可小於0!");
return(false);
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
pcc_tb pccModel;
int ChkCnts = 0;
try
{
pccModel = DrMaster.ToItem <pcc_tb>();
#region 單頭-pick vw_puri101
if (e.Row.Table.Prefix.ToLower() == "vw_puri101")
{
switch (e.Column.ToLower())
{
case "pcc01":
if (GlobalFn.varIsNull(e.Value) == true)
{
return(true);
}
if (FormEditMode == YREditType.新增)
{
ChkCnts = GlobalFn.isNullRet(BoPur.OfChkPccPkExists(GlobalFn.isNullRet(e.Value, "")), 0);
if (ChkCnts > 0)
{
WfShowErrorMsg("地址代號已存在!");
return(false);
}
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
try
{
//if (e.Row.Table.Prefix.ToLower() == "vw_admi620s")
//{
// switch (e.Column.ToLower())
// {
// case "aza12":
// var aza12 = e.Value;
// break;
// }
//}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_puri030s detailModel;
List <vw_puri030s> detailList;
int iChkCnts = 0;
try
{
#region 單頭-pick vw_puri030
if (e.Row.Table.Prefix.ToLower() == "vw_puri030")
{
switch (e.Column.ToLower())
{
case "pba01": //採購取價代號
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (BoPur.OfChkPbaPKExists(GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("採購取價代號已存在,請檢核!");
return(false);
}
break;
}
}
#endregion
#region 單身-pick vw_puri030s
if (e.Row.Table.Prefix.ToLower() == "vw_puri030s")
{
detailModel = e.Row.ToItem <vw_puri030s>();
detailList = e.Row.Table.ToList <vw_puri030s>();
switch (e.Column.ToLower())
{
case "pbc03": //取價類型
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
iChkCnts = detailList.Where(p => p.pbc02 != detailModel.pbc02)
.Where(p => p.pbc03 == e.Value.ToString())
.Count();
if (iChkCnts > 0)
{
WfShowErrorMsg("取價類型不得重覆!");
return(false);
}
break;
case "pbc04": //取價順序
if (GlobalFn.varIsNull(e.Value) || GlobalFn.isNullRet(e.Value, 0) == 0)
{
return(true);
}
iChkCnts = detailList.Where(p => p.pbc02 != detailModel.pbc02)
.Where(p => p.pbc04 == Convert.ToInt16(e.Value))
.Count();
if (iChkCnts > 0)
{
WfShowErrorMsg("取價順序不得重覆!");
return(false);
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,會把值還原
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
int chkCnts = 0;
vw_glai110 masterModel = null;
vw_glai110s detailModel = null;
List <vw_glai110s> detailList = null;
gba_tb gbaModel = null;
UltraGrid uGrid = null;
UltraGridRow uGridRow = null;
string sqlSelect = "";
List <SqlParameter> sqlParmList = null;
try
{
masterModel = DrMaster.ToItem <vw_glai110>();
if (e.Column.ToLower() != "gbd01" && GlobalFn.isNullRet(DrMaster["gbd01"], "") == "")
{
WfShowErrorMsg("請先輸入上層部門!");
return(false);
}
#region 單頭-vw_glai110
if (e.Row.Table.Prefix.ToLower() == "vw_glai110")
{
switch (e.Column.ToLower())
{
case "gbd01":
if (GlobalFn.isNullRet(e.Value, "") == "")
{
e.Row["gbd01_c"] = "";
return(true);
}
var babModel = BoBas.OfGetBebModel(e.Value.ToString());
if (babModel == null)
{
WfShowErrorMsg("無此上層部門,請檢核!");
return(false);
}
if (babModel.bebvali != "Y")
{
WfShowErrorMsg("此上層部門已失效,請檢核!");
return(false);
}
if (WfChkGbd01Exists(e.Value.ToString()) == true)
{
WfShowErrorMsg("此上層部門已存在,請檢核!");
return(false);
}
e.Row["gbd01_c"] = babModel.beb03;
break;
}
}
#endregion
#region 單身-vw_glai110s
if (e.Row.Table.Prefix.ToLower() == "vw_glai110s")
{
uGrid = sender as UltraGrid;
uGridRow = uGrid.ActiveRow;
detailModel = e.Row.ToItem <vw_glai110s>();
detailList = e.Row.Table.ToList <vw_glai110s>();
switch (e.Column.ToLower())
{
case "gbd02":
if (GlobalFn.isNullRet(e.Value, "") == "")
{
e.Row["gbd02_c"] = "";
return(true);
}
var babModel = BoBas.OfGetBebModel(e.Value.ToString());
if (babModel == null)
{
WfShowErrorMsg("無此下層部門,請檢核!");
return(false);
}
if (babModel.bebvali != "Y")
{
WfShowErrorMsg("此下層部門已失效,請檢核!");
return(false);
}
if (masterModel.gbd01.ToUpper() == e.Value.ToString().ToUpper())
{
WfShowErrorMsg("不可與上層部門相同,請檢核!");
return(false);
}
chkCnts = detailList.Where(p => p.gbd02.ToUpper() == e.Value.ToString().ToUpper()).Count();
if (chkCnts > 1)
{
WfShowErrorMsg("下層部門不可重覆,請檢核!");
return(false);
}
sqlSelect = "SELECT COUNT(1) FROM gbd_tb WHERE gbd02=@gbd02 AND gbd01<>@gbd01";
sqlParmList = new List <SqlParameter>();
sqlParmList.Add(new SqlParameter("@gbd01", masterModel.gbd01));
sqlParmList.Add(new SqlParameter("@gbd02", e.Value.ToString()));
chkCnts = GlobalFn.isNullRet(BoGla.OfGetFieldValue(sqlSelect, sqlParmList.ToArray()), 0);
if (chkCnts > 0)
{
WfShowErrorMsg("此下層部門已隸屬於其他上層部門,請檢核!");
return(false);
}
e.Row["gbd02_c"] = babModel.beb03;
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_admi600 admi600Model;
try
{
admi600Model = DrMaster.ToItem <vw_admi600>();
#region 單頭-pick vw_admi600
if (e.Row.Table.Prefix.ToLower() == "vw_admi600")
{
switch (e.Column.ToLower())
{
case "ado01": //程式代號
if (GlobalFn.isNullRet(e.Value, "") == "")
{
return(true);
}
if (FormEditMode == YREditType.新增)
{
if (BoAdm.OfChkAdoPKExists(admi600Model.ado01) == true)
{
WfShowErrorMsg("程式代號已存在,請檢查!");
return(false);
}
}
break;
case "ado07": //程式類別 P.程式 M.menu R.報表
if (GlobalFn.varIsNull(admi600Model.ado07) || admi600Model.ado07 == "M")
{
e.Row["ado03"] = "";
e.Row["ado04"] = "";
e.Row["ado05"] = "";
e.Row["ado06"] = "";
e.Row["ado08"] = "N";
e.Row["ado09"] = "N";
e.Row["ado10"] = "";
e.Row["ado11"] = 0;
e.Row["ado12"] = "";
e.Row["ado13"] = "";
e.Row["ado15"] = "";
e.Row["ado16"] = "N";
}
else if (admi600Model.ado07 == "R")
{
e.Row["ado08"] = "N";
e.Row["ado09"] = "N";
e.Row["ado13"] = "";
e.Row["ado15"] = "";
e.Row["ado16"] = "N";
WfItemChkForceFocus(ucb_ado13);
}
WfDisplayMode();
break;
case "ado09": //自動化報表
if (GlobalFn.isNullRet(e.Value, "") == "Y")
{
WfSetControlReadonly(ute_ado10, false);
WfItemChkForceFocus(ute_ado10);
}
else
{
WfSetControlReadonly(ute_ado10, true);
e.Row["ado10"] = ""; //報表名稱
e.Row["ado13"] = "";
}
break;
case "ado14": //流程圖ID
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (BoAdm.OfChkAdxPKExists(e.Value.ToString()) == false)
{
WfShowErrorMsg("無此流程圖ID,請確認!");
return(false);
}
break;
//case "ado15": //Action功能
// if (GlobalFn.varIsNull(e.Value))
// return true;
// if (BoAdm.OfChkAtc02Exists(e.Value.ToString()) == false)
// {
// WfShowMsg("無此欄位,請確認!");
// return false;
// }
// break;
//case "ado16": //是否為子程式
// if (GlobalFn.varIsNull(e.Value))
// return true;
// if (BoAdm.OfChkAtc02Exists(e.Value.ToString()) == false)
// {
// WfShowMsg("無此欄位,請確認!");
// return false;
// }
// break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 false未通過驗證,還原輸入的值 true.未通過驗證,保留原值
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
int iTemp = 0;
try
{
#region 單頭-pick vw_basi080
if (e.Row.Table.Prefix.ToLower() == "vw_basi080")
{
switch (e.Column.ToLower())
{
#region bek01 幣別資料check
case "bek01":
if (BoBas.OfChkBekPKExists(GlobalFn.isNullRet(e.Value.ToString(), "")) == true)
{
WfShowErrorMsg("幣別代碼已存在,請檢核!");
return(false);
}
break;
#endregion
#region bek03 單價小數位數
case "bek03":
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (int.TryParse(GlobalFn.isNullRet(e.Value, ""), out iTemp) == false)
{
WfShowErrorMsg("請輸入整數值");
return(false);
}
if (iTemp > 5 || iTemp < 0)
{
WfShowErrorMsg("需輸入範圍為0-5的整數!");
return(false);
}
break;
#endregion
#region bek03 小計/總計位數
case "bek04":
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (int.TryParse(GlobalFn.isNullRet(e.Value, ""), out iTemp) == false)
{
WfShowErrorMsg("請輸入整數值");
return(false);
}
if (iTemp > 5 || iTemp < 0)
{
WfShowErrorMsg("需輸入範圍為0-5的整數!");
return(false);
}
break;
#endregion
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
baa_tb baaModel;
vw_stpi010 masterModel;
string errMsg;
try
{
baaModel = BoBas.OfGetBaaModel();
masterModel = DrMaster.ToItem <vw_stpi010>();
#region 單頭-pick vw_stpi010
if (e.Row.Table.Prefix.ToLower() == "vw_stpi010")
{
switch (e.Column.ToLower())
{
case "bab01": //單別
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (GlobalFn.isNullRet(baaModel.baa06.Value, 0) != GlobalFn.isNullRet(e.Value, "").Length)
{
errMsg = string.Format("單別限定長度為{0}碼", GlobalFn.isNullRet(baaModel.baa06, ""));
WfShowErrorMsg(errMsg);
return(false);
}
if (BoBas.OfChkBabPKValid(GlobalFn.isNullRet(e.Value, "")) == true)
{
WfShowErrorMsg("單別已存在,請檢核!");
return(false);
}
break;
case "bab03": //模組別
e.Row["bab04"] = "";
e.Row["bab04_c"] = "";
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
WfDisplayMode();
ute_bab04.Focus();
break;
case "bab04": //單據性質
if (GlobalFn.varIsNull(e.Value))
{
e.Row["bab04_c"] = "";
e.Row["bab09"] = "";
WfSetControlReadonly(ute_bab09, true);
return(true);
}
if (GlobalFn.varIsNull(masterModel.bab03))
{
WfShowErrorMsg("請先輸入模組別!");
return(true);
}
if (BoAdm.OfChkAzf02Exists(masterModel.bab03, GlobalFn.isNullRet(e.Value, "")) == false)
{
WfShowErrorMsg("無此模組+單據性質!");
return(false);
}
if (e.Value.ToString() == "30" || e.Value.ToString() == "40")
{
WfSetControlReadonly(ute_bab09, false);
WfItemChkForceFocus(ute_bab09);
}
else
{
WfSetControlReadonly(ute_bab09, true);
}
e.Row["bab09"] = "";
e.Row["bab04_c"] = BoAdm.OfGetAzf02(masterModel.bab03, GlobalFn.isNullRet(e.Value, ""));
break;
case "bab09": //轉應收單別
if (GlobalFn.varIsNull(e.Value))
{
return(true);
}
if (GlobalFn.varIsNull(masterModel.bab04))
{
WfShowErrorMsg("請先輸入單據性質!");
return(false);
}
if (masterModel.bab04 == "30")
{
if (BoCar.OfChkCacPKValid(e.Value.ToString(), "car", "11") == false)
{
WfShowErrorMsg("無此單別!");
return(false);
}
}
else if (masterModel.bab04 == "40")
{
if (BoCar.OfChkCacPKValid(e.Value.ToString(), "car", "21") == false)
{
WfShowErrorMsg("無此單別!");
return(false);
}
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
//回傳值 true.通過驗證 false.未通過驗證,
protected override bool WfItemCheck(object sender, ItemCheckInfo e)
{
vw_admi611s detailModel;
try
{
detailModel = DrMaster.ToItem <vw_admi611s>();
#region 單頭-pick vw_admi611s
if (e.Row.Table.Prefix.ToLower() == "vw_admi611s")
{
switch (e.Column.ToLower())
{
case "ady03": //程式代號
if (GlobalFn.varIsNull(e.Value))
{
DrMaster["ady03_c"] = "";
return(true);
}
var adoModel = BoAdm.OfGetAdoModel(e.Value.ToString());
if (adoModel == null)
{
WfShowErrorMsg("無此程式代號,請確認!");
return(false);
}
if (adoModel.ado07.ToUpper() == "M")
{
WfShowErrorMsg("不可選擇目錄,請確認!");
return(false);
}
DrMaster["ady03_c"] = adoModel.ado02;
break;
case "ady04":
if (e.Value == null)
{
WfShowErrorMsg("欄位不可空白,請確認!");
return(true);
}
if (GlobalFn.isNullRet(e.Value, 0) < 0)
{
WfShowErrorMsg("欄位不可為負數,請確認!");
return(false);
}
break;
case "ady05":
if (e.Value == null)
{
WfShowErrorMsg("欄位不可空白,請確認!");
return(true);
}
if (GlobalFn.isNullRet(e.Value, 0) < 0)
{
WfShowErrorMsg("欄位不可為負數,請確認!");
return(false);
}
break;
case "ady06":
if (e.Value == null)
{
WfShowErrorMsg("欄位不可空白,請確認!");
return(true);
}
if (GlobalFn.isNullRet(e.Value, 0) < 0)
{
WfShowErrorMsg("欄位不可為負數,請確認!");
return(true);
}
break;
case "ady07":
if (e.Value == null)
{
WfShowErrorMsg("欄位不可空白,請確認!");
return(true);
}
if (GlobalFn.isNullRet(e.Value, 0) < 0)
{
WfShowErrorMsg("欄位不可為負數,請確認!");
return(true);
}
break;
}
}
#endregion
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
