public static string SetLOCATE_SECTIONOnBlur(string strItem, string strPeriod, string strLOCATE_NO, string strLOCATE_SECTION, string strSTOCKTAKE_NO, string strONHD_QTY_CID) { string rtnValue = string.Empty; string strONHD_QTY = "0"; IVMModel.IVM043_BCO BCO = new IVMModel.IVM043_BCO(ConntionDB); if ((strItem != "") && (strPeriod != "") && (strSTOCKTAKE_NO != "") && (strLOCATE_SECTION != "")) { ParameterList.Clear(); ParameterList.Add(strSTOCKTAKE_NO); ParameterList.Add(strLOCATE_NO); ParameterList.Add(strLOCATE_SECTION); ParameterList.Add(strItem); ParameterList.Add(strPeriod); DataTable dt = BCO.CheckDETL(ParameterList); if (dt.Rows.Count > 0) { strONHD_QTY = dt.Rows[0]["onhd_qty"].ToString(); } } rtnValue = strONHD_QTY_CID + ";" + strONHD_QTY; return rtnValue; }
public static string SetItemPeriodOnBlur(string strItem, string strPeriod, string strLOCATE_NO, string strLOCATE_SECTION, string strSTOCKTAKE_NO, string strItemName_CID, string strONHD_QTY_CID, string strErrMsg1_CID, string strErrMsg2_CID) { string rtnValue = string.Empty; string strErrMsg1 = string.Empty; string strErrMsg2 = string.Empty; string strONHD_QTY = "0"; string strItemName = string.Empty; IVMModel.IVM043_BCO BCO = new IVMModel.IVM043_BCO(ConntionDB); if (strItem != "") { DataTable dtItem = BCO.CheckItem(strItem); if (dtItem.Rows.Count > 0) { strItemName = dtItem.Rows[0]["ITEM_NAME"].ToString(); if (strPeriod != "") { DataTable dtPeriod = BCO.CheckPeriod(strItem, strPeriod); if (dtPeriod.Rows.Count > 0) { ParameterList.Clear(); ParameterList.Add(strSTOCKTAKE_NO); ParameterList.Add(strLOCATE_NO); ParameterList.Add(strLOCATE_SECTION); ParameterList.Add(strItem); ParameterList.Add(strPeriod); DataTable dt = BCO.CheckDETL(ParameterList); if (dt.Rows.Count > 0) { strONHD_QTY = dt.Rows[0]["onhd_qty"].ToString(); } } else { strErrMsg2 = "期別不存在"; } } } else { strErrMsg1 = "品號不存在"; } } rtnValue = strErrMsg1_CID + ";" + strErrMsg1 + ";" + strErrMsg2_CID + ";" + strErrMsg2 + ";" + strItemName_CID + ";" + strItemName + ";" + strONHD_QTY_CID + ";" + strONHD_QTY; return rtnValue; }