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; }
private void SaveData() { try { SaveDT(); IVMModel.IVM043_BCO BCO = new IVMModel.IVM043_BCO(ConntionDB); DataTable dt = (DataTable)Session["IVM043_DTL_" + PageTimeStamp.Value]; int iRow = 1; string strErrMsg = string.Empty; foreach (DataRow dr in dt.Rows) { if (!( ( (dr["LOCATE_SECTION"].ToString().Trim() == "") && (dr["ITEM"].ToString().Trim() == "") && (dr["PERIOD"].ToString().Trim() == "") && ((dr["STOCKTAKE_QTY"].ToString().Trim() == "") || (dr["STOCKTAKE_QTY"].ToString().Trim() == "0")) ) || ( (dr["LOCATE_SECTION"].ToString().Trim() != "") && (dr["ITEM"].ToString().Trim() != "") && (dr["PERIOD"].ToString().Trim() != "") && (dr["STOCKTAKE_QTY"].ToString().Trim() != "") ) )) { if (strErrMsg != "") strErrMsg += "<br />"; strErrMsg += "第 " + iRow.ToString() + " 列資料輸入不完整"; } else { if (dr["ITEM"].ToString().Trim() != "") { DataTable dtItem = BCO.CheckItem(dr["ITEM"].ToString().Trim()); if (dtItem.Rows.Count > 0) { if (dr["PERIOD"].ToString().Trim() != "") { DataTable dtPeriod = BCO.CheckPeriod(dr["ITEM"].ToString().Trim(), dr["PERIOD"].ToString().Trim()); if (dtPeriod.Rows.Count == 0) { if (strErrMsg != "") strErrMsg += "<br />"; strErrMsg += "第 " + iRow.ToString() + " 列 期別不存在"; } } } else { if (strErrMsg != "") strErrMsg += "<br />"; strErrMsg += "第 " + iRow.ToString() + " 列 品號不存在"; } } if ((dr["LOCATE_SECTION"].ToString().Trim() != "") && (dr["ITEM"].ToString().Trim() != "") && (dr["PERIOD"].ToString().Trim() != "")) { //檢查實盤數請輸入大於零 if (int.Parse(dr["STOCKTAKE_QTY"].ToString().Trim()) <= 0) { if (strErrMsg != "") strErrMsg += "<br />"; strErrMsg += "第 " + iRow.ToString() + " 列 實盤數請輸入大於零的整數"; } for (int i = 0; i < dt.Rows.Count; i++) { if (i != iRow - 1) { if ((dr["LOCATE_SECTION"].ToString().Trim() == dt.Rows[i]["LOCATE_SECTION"].ToString().Trim()) && (dr["ITEM"].ToString().Trim() == dt.Rows[i]["ITEM"].ToString().Trim()) && (dr["PERIOD"].ToString().Trim() == dt.Rows[i]["PERIOD"].ToString().Trim())) { if (strErrMsg != "") strErrMsg += "<br />"; strErrMsg += "第 " + iRow.ToString() + " 列與第 " + (i + 1) + " 列 資料重複"; break; } } } } } iRow++; //dr["ITEM_NAME"].ToString() //1.檢查品號是否存 //2.期別是否存在 //3.實盤數只能輸入數字,最多6碼 } if (strErrMsg != "") { ErrorMsgLabel.Text = strErrMsg; GridView1.DataSource = dt; GridView1.DataBind(); return; } DataView dv = dt.DefaultView; dv.RowFilter = "ITEM<>''"; DataTable dtData = dv.ToTable(); if (dtData.Rows.Count > 0) { ParameterList.Clear(); ParameterList.Add(lblStockTakeNo.Text); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(hdfPID.Value); BCO.SaveData(dtData, ParameterList); } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), Guid.NewGuid().ToString(), "setTimeout(function(){alert('儲存完成');location.href='IVM041.aspx?Code=IVM04';},1);", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }