private void databindDDL() { MaintainAssign BCO = new MaintainAssign(ConntionDB); DataTable Dt = BCO.QueryChanNameItem(); this.ddlChanNo.DataSource = Dt; this.ddlChanNo.DataTextField = "chan_name"; this.ddlChanNo.DataValueField = "chan_no"; this.ddlChanNo.DataBind(); if (ddlChanNo.Items.Count > 0) { ddlChanNo.SelectedIndex = 0; Dt = BCO.GetStoreByChanNo(ddlChanNo.SelectedItem.Value); this.ddlStore.DataSource = Dt; ddlStore.DataTextField = "name"; ddlStore.DataValueField = "store"; ddlStore.DataBind(); if (ddlStore.Items.Count > 0) ddlStore.SelectedIndex = 0; } }
protected void QueryItemDataUpdate() { if (this.ddlChanNo.SelectedItem.Value == string.Empty || this.SLP_SKU.Text == string.Empty || this.SLP_Period.Text == string.Empty) return; ParameterList.Clear(); ParameterList.Add(this.SLP_SKU.Text); // ParameterList.Add("119709"); ParameterList.Add(this.ddlStore.SelectedItem.Value); ParameterList.Add(this.ddlChanNo.SelectedItem.Value); ParameterList.Add(this.SLP_Period.Text); ParameterList.Add(this.SLP_AcceptDate.Text.Replace("/", "").Trim()); string sChanItem = ""; string sListPrice = ""; string sTTLAssignQty = ""; string sSTAcceptQty = ""; string sOnhdQty = ""; string sSecOnhdQty = ""; string sMessage = ""; MaintainAssign BCO = new MaintainAssign(ConntionDB); BCO.QueryItemData(ParameterList, out sChanItem, out sListPrice, out sTTLAssignQty, out sSTAcceptQty, out sOnhdQty, out sSecOnhdQty, out sMessage); this.txtChanItem.Text = sChanItem; this.txtListPrice.Text = sListPrice; this.txtTTLAssignQty.Text = sTTLAssignQty; this.txtSTAcceptQty.Text = sSTAcceptQty; this.txtOnhdQty.Text = sOnhdQty; this.txtSecOnhdQty.Text = sSecOnhdQty; }
private string CheckWdsItem(out string strMSG) { //0.V_ITEM IN VARCHAR2, //1.V_PERIOD IN VARCHAR2, //2.V_CHAN_NO IN VARCHAR2, //3.V_STORE IN VARCHAR2, //P_MSG OUT VARCHAR2 //P_REUSLT OUT VARCHAR2 ParameterList.Clear(); ParameterList.Add(this.SLP_SKU.Text); ParameterList.Add(this.SLP_Period.Text); ParameterList.Add(this.ddlChanNo.SelectedItem.Value); ParameterList.Add(this.ddlStore.SelectedItem.Value); string strResult = string.Empty; MaintainAssign BCO = new MaintainAssign(ConntionDB); BCO.CheckWdsItem(ParameterList, out strResult, out strMSG); return strResult; }
public static string GetStoreData(string txtChanNo) { MaintainAssign BCO = new MaintainAssign(ConntionDB); // return sQualifyCondition; DataTable dt = BCO.GetStoreByChanNo(txtChanNo); string sRet = dt.Rows.Count.ToString() + ","; foreach (DataRow dr in dt.Rows) { //a)呼叫MaintainDisStore.DeleteDisStoreByChan(); sRet = sRet + dr["Store"].ToString() + "," + dr["name"].ToString() + ","; } return sRet; }
private DataTable SetAcceptDataMode(out string strErr) { string sAcceptNo = this.Request["acceptno"].ToString(); MaintainAssign BCO = new MaintainAssign(ConntionDB); DataTable dt = BCO.QueryByAcceptNo(sAcceptNo); string sChan_no = ""; string sStore = ""; strErr = string.Empty; foreach (DataRow dr in dt.Rows) { //a)呼叫MaintainDisStore.DeleteDisStoreByChan(); string sItem = dr["item"].ToString(); string sPeriod = dr["period"].ToString(); string sTempChan_no = ""; string sTempStore = ""; string sAcceptQty = ""; BCO.QueryChanNoByItemPeriod(sItem, sPeriod, out sTempChan_no, out sTempStore, out sAcceptQty); if (sTempChan_no == string.Empty) { dr["ID"] = "F"; } else if (sChan_no == string.Empty && sTempChan_no != string.Empty) { sChan_no = sTempChan_no; sStore = sTempStore; this.ddlChanNo.SelectedValue = sChan_no; this.ddlStore.SelectedValue = sStore; dr["ST_ACCEPT_QTY"] = sAcceptQty; dr["ID"] = "T"; } else if (sChan_no == sTempChan_no) { dr["ST_ACCEPT_QTY"] = sAcceptQty; dr["ID"] = "T"; } else { dr["ID"] = "F"; } } for (int idx = dt.Rows.Count - 1; idx >= 0; --idx) { DataRow dr = dt.Rows[idx]; if (dr["ID"].ToString() == "F") { dr.Delete(); continue; } ParameterList.Clear(); ParameterList.Add(dr["item"].ToString()); ParameterList.Add(sStore); ParameterList.Add(sChan_no); ParameterList.Add(dr["period"].ToString()); ParameterList.Add(DateTime.Today.ToString("yyyyMMdd")); string sChanItem = ""; string sListPrice = ""; string sTTLAssignQty = ""; string sSTAcceptQty = ""; string sOnhdQty = ""; string sSecOnhdQty = ""; string sMessage = ""; BCO.QueryItemData(ParameterList, out sChanItem, out sListPrice, out sTTLAssignQty, out sSTAcceptQty, out sOnhdQty, out sSecOnhdQty, out sMessage); dr["chan_item"] = sChanItem; dr["ListPrice"] = sListPrice; dr["Total_assign_Qty"] = sTTLAssignQty; dr["Total_St_Accept_Qty"] = sSTAcceptQty; dr["onhd_qty"] = sOnhdQty; dr["onhdx_qty"] = sSecOnhdQty; ParameterList.Clear(); if (sMessage != "OK") { strErr += "品號 " + dr["item"] + "期別 " + dr["period"] + " " + sMessage + "<br>"; } } dt.AcceptChanges(); // ScriptManager.RegisterStartupScript(Page, this.GetType(), // "VGI022.aspx", "alert(' " + dt.Rows.Count.ToString() + " ');", true); if (dt.Rows.Count > 0) { this.ddlChanNo.Enabled = false; this.ddlStore.Enabled = false; } else { ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "NoDataAlert.aspx", "alert('驗收資料皆已進行指配作業,無對應的指配資料可建立');", true); } return dt; }
protected void ddlChanNo_SelectedIndexChanged(object sender, EventArgs e) { MaintainAssign BCO = new MaintainAssign(ConntionDB); DataTable Dt = BCO.GetStoreByChanNo(ddlChanNo.SelectedItem.Value); this.ddlStore.DataSource = Dt; ddlStore.DataTextField = "name"; ddlStore.DataValueField = "store"; ddlStore.DataBind(); if (ddlStore.Items.Count > 0) ddlStore.SelectedIndex = 0; }
public static string QueryItemData(string txtChanNo, string txtStore, string txtItem, string txtPeriod, string txtAcceptDate) { // aChanNo ,aStore , aItem , aPeriod , aAcceptDate bool HaveData = false; ArrayList meterList = new ArrayList(); meterList.Clear(); meterList.Add(txtItem.Trim()); meterList.Add(txtStore.Trim()); meterList.Add(txtChanNo.Trim()); meterList.Add(txtPeriod.Trim()); meterList.Add(txtAcceptDate.Replace("/", "").Trim()); string sChanItem = "324234"; string sListPrice = "324234"; string sTTLAssignQty = "324234"; string sSTAcceptQty = "324234"; string sOnhdQty = "324234"; string sSecOnhdQty = "324234"; string sMessage = ""; // return sChanItem + "," + sListPrice + "," + sTTLAssignQty + "," + sSTAcceptQty + "," + sOnhdQty + "," + sSecOnhdQty; MaintainAssign BCO = new MaintainAssign(ConntionDB); HaveData = BCO.QueryItemData(meterList, out sChanItem, out sListPrice, out sTTLAssignQty, out sSTAcceptQty, out sOnhdQty, out sSecOnhdQty, out sMessage); if (HaveData == true) { string strRes = string.Empty; if (sMessage.Substring((sMessage.Length - 2), 2) != "OK") { strRes = sMessage; } else { ParameterList.Clear(); ParameterList.Add(txtItem.Trim()); ParameterList.Add(txtPeriod.Trim()); ParameterList.Add(txtChanNo.Trim()); if (BCO.checkChanItem(ParameterList)) { strRes = ""; } else { strRes = "通路到期日小於系統日 不可進行該品號期別的新增"; } } return sChanItem + "&" + sListPrice + "&" + sTTLAssignQty + "&" + sSTAcceptQty + "&" + sOnhdQty + "&" + sSecOnhdQty + "&" + strRes; } else { return ""; } }
protected void btnAssignNoExpore_Click(object sender, EventArgs e) { // ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "if (confirm('理貨商品己擷取,是否重新擷取商品?')){this.disabled=true;__doPostBack('Trans','');}", true); #region 前置檢查與參數過濾 string par_AssignNo = this.txt_AssignNo.Text; string par_AcceptDate = this.SLP_AcceptDate.Text; string par_ChanNo = this.txtChanNo.Text; string par_Store = this.txtStore.Text; // string par_CREATEUID = "vds2gdev"; par_CREATEUID = par_CREATEUID.ToUpper(); string par_CREATEUID = Session["UID"].ToString(); #endregion #region 組合查詢條件至ArrayList ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(par_AssignNo, "string")); ParameterList.Add(GetValueSetParameter(par_AcceptDate, "string")); ParameterList.Add(GetValueSetParameter(par_ChanNo, "string")); ParameterList.Add(GetValueSetParameter(par_Store, "string")); ParameterList.Add(GetValueSetParameter(par_CREATEUID, "string")); #endregion MaintainAssign BCO = new MaintainAssign(ConntionDB); string sTranNo; BCO.ExportAssign(ParameterList, out sTranNo); if (sTranNo == string.Empty) ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGI041.aspx", "alert(' 此指配單號已被匯出過!! ');", true); else { this.txt_OutNo1.Text = sTranNo; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGI041.aspx", "alert(' 指配單號匯出成功!! ');", true); } }
//檢查是否有可使用儲格,並回傳轉入及轉出的儲格 private bool CheckForRemove(out string strOutLS, out string strInLS) { MaintainAssign BCO = new MaintainAssign(ConntionDB); BCO.QueryLocateSection(out strOutLS, out strInLS); if (strOutLS == "") { ErrorMsgLabel.Text = "查無轉出儲格"; return false; } if (strInLS == "") { ErrorMsgLabel.Text = "查無轉入儲格"; return false; } return true; }
protected void btn_Save_Click(object sender, EventArgs e) { try { string par_AcceptDate = this.SLP_AcceptDate.Text; string par_ChanNo = this.ddlChanNo.SelectedValue; string par_Store = this.ddlStore.SelectedValue; string par_CREATEUID = Session["UID"].ToString(); #region 檢查 if (par_ChanNo.Trim() == string.Empty) { throw new Exception("通路未設定!!"); } if (par_Store.Trim() == string.Empty) { throw new Exception("廠商門市未設定!!"); } if (this.txt_PageStatus.Text != "QUERY" && (this.SLP_SKU.Text != string.Empty || this.SLP_Period.Text != string.Empty)) { QueryItemDataUpdate(); throw new Exception("明細資料在編輯狀態,不可儲存!!"); } #endregion #region 建立移轉單 if (Request["formtype"] == "1")//由驗收單畫面連過來 { //檢查是否需要建移轉單 //如果[出庫儲位庫存量] < [進貨數量],要建移轉單 if (checkNeedRemove()) { string strOutLS = string.Empty; string strInLS = string.Empty; if (CheckForRemove(out strOutLS, out strInLS)) { string strMainID = string.Empty; string strRemoveNo = string.Empty; ArrayList ErrList = new ArrayList(); bool result = false; DataTable Dt_Detail = MakeDetailTable(strOutLS, strInLS); ParameterList.Clear(); ParameterList.Add(par_CREATEUID); ParameterList.Add(par_AcceptDate); ParameterList.Add("M3"); PIC.VDS2G.VSM.IVM.MaintainRemoveData bco = new PIC.VDS2G.VSM.IVM.MaintainRemoveData(ConntionDB); result = bco.CreateRemoveData(ParameterList, Dt_Detail, null, out strMainID, out strRemoveNo, out ErrList); if (result == false) { throw new Exception("無足夠儲位,無法建立移轉單"); } } else { throw new Exception("查無儲格資料,無法建立移轉單"); } } } #endregion ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(par_AcceptDate, "string")); ParameterList.Add(GetValueSetParameter(par_ChanNo, "string")); ParameterList.Add(GetValueSetParameter(par_Store, "string")); ParameterList.Add(GetValueSetParameter(par_CREATEUID, "string")); string sAssignNo = ""; string sAcceptNo = ""; string sOutNo = ""; string SessionIDName = "VGI022_" + PageTimeStamp.Value; DataTable dt = (DataTable)Session[SessionIDName]; if (dt.Rows.Count == 0) { throw new Exception("無明細項目資料!!"); } MaintainAssign BCO = new MaintainAssign(ConntionDB); BCO.CreateAssign(ParameterList, null, dt, out sAssignNo, out sAcceptNo, out sOutNo); this.txt_AssignNo.Text = sAssignNo; this.txt_AcceptNo.Text = sAcceptNo; this.txt_OutNo.Text = sOutNo; IDList.Clear(); if (Session["VGI02QueryID"] != null) { IDList = (ArrayList)Session["VGI02QueryID"]; IDList.Clear(); } Response.Redirect("VGI022.aspx?ID=" + txt_AssignNo.Text + "&mode=VIEW&Code=VGI02", false); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #region 存檔後狀態設定 // this.hid_PageStatus.Value = "VIEW"; // this.txt_PageStatus.Text = "VIEW"; // SetPageStatus(); #endregion }
//GridView1 資料繫結 private void databind_Dtl() { try { MaintainAssign BCO = new MaintainAssign(ConntionDB); ParameterList.Clear(); ParameterList.Add(this.Request["ID"].ToString()); ParameterList.Add(this.txtStore.Text); DataTable Dt = BCO.QueryItemDataDetail(ParameterList); foreach (DataRow dr in Dt.Rows) { //a)呼叫MaintainDisStore.DeleteDisStoreByChan(); string sTempListPrice = ""; string sTempTTLQty = ""; ParameterList.Clear(); ParameterList.Add(dr["item"]); // ParameterList.Add("119709"); ParameterList.Add(this.txtStore.Text); ParameterList.Add(this.txtChanNo.Text); ParameterList.Add(dr["period"]); // ParameterList.Add("000001"); ParameterList.Add(SLP_AcceptDate.Text.Replace("/", "")); BCO.QueryItemListPriceTTLQty(ParameterList, out sTempListPrice, out sTempTTLQty); dr["ListPrice"] = sTempListPrice; dr["Total_assign_Qty"] = sTempTTLQty; } string SessionIDName = "VGI022_" + PageTimeStamp.Value; Session[SessionIDName] = Dt; GridView1.DataSource = Dt; GridView1.PageIndex = 0; GridView1.DataBind(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
//表頭資料繫結 private bool databind_Mst() { bool ret = false; try { ParameterList.Clear(); ParameterList.Add(this.Request["ID"].ToString()); MaintainAssign BCO = new MaintainAssign(ConntionDB); DataTable DtMain = BCO.QueryItemDataMaster(ParameterList); if (DtMain.Rows.Count == 1)//&& { ret = true; txt_AssignNo.Text = DtMain.Rows[0]["assign_no"].ToString(); SLP_AcceptDate.Text = DtMain.Rows[0]["st_accept_date"].ToString(); txt_AcceptNo.Text = DtMain.Rows[0]["st_accept_no"].ToString(); this.txtChanNo.Text = DtMain.Rows[0]["chan_no"].ToString(); this.txtStore.Text = DtMain.Rows[0]["store"].ToString(); txt_OutNo.Text = DtMain.Rows[0]["out_no"].ToString(); // txt_OutNo1.Text = DtMain.Rows[0]["out_no"].ToString(); } else { ret = false; string sAssignNo = this.Request["ID"].ToString().ToUpper(); //int idx = IDList.IndexOf(sAssignNo); //if (idx != -1) // IDList.Remove(sAssignNo); //Session["VGI02QueryID"] = IDList; ScriptManager.RegisterStartupScript(Page, this.GetType(), "VG022.aspx", "alert(' 此筆指配單(" + sAssignNo + ")已被其他使用者刪除,請點選上一筆/下一筆鈕繼續查詢 ');", true); } return ret; } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; return ret; } }
}//page_load /// databindDDL 繫結查詢資料到DropDownList /// </summary> private void databindDDL() { DataTable Dt = bco.QueryChanNameItem(); ddlChanNo.DataSource = Dt; ddlChanNo.DataTextField = "chan_name"; ddlChanNo.DataValueField = "chan_no"; ddlChanNo.DataBind(); if (ddlChanNo.Items.Count > 0) { ddlChanNo.SelectedIndex = 0; MaintainAssign bcoMA = new MaintainAssign(ConntionDB); Dt = bcoMA.GetStoreByChanNo(ddlChanNo.SelectedItem.Value); this.ddlStore.DataSource = Dt; DataRow drMyRow = Dt.NewRow(); drMyRow["name"] = "全部"; drMyRow["store"] = ""; Dt.Rows.InsertAt(drMyRow, 0); ddlStore.DataTextField = "name"; ddlStore.DataValueField = "store"; ddlStore.DataBind(); if (ddlStore.Items.Count > 0) ddlStore.SelectedIndex = 0; } }
protected void ddlChanNo_SelectedIndexChanged(object sender, EventArgs e) { MaintainAssign BCO = new MaintainAssign(ConntionDB); DataTable Dt = bco.GetStoreByChanNo(ddlChanNo.SelectedItem.Value); this.ddlStore.DataSource = Dt; DataRow drMyRow = Dt.NewRow(); drMyRow["name"] = "全部"; drMyRow["store"] = ""; Dt.Rows.InsertAt(drMyRow, 0); ddlStore.DataTextField = "name"; ddlStore.DataValueField = "store"; ddlStore.DataBind(); if (ddlStore.Items.Count > 0) ddlStore.SelectedIndex = 0; }