protected void btnQuery_Click(object sender, EventArgs e) { PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(TextBoxRowCountLimit.Text); ParameterList.Add(txtTrans_No.Text); ParameterList.Add(txtChan_Source_No.Text); ParameterList.Add(SLP_Trans_Date.Text); ParameterList.Add(SLP_Locate_No.Text); ParameterList.Add(""); ParameterList.Add(txtChan_Trans_No.Text); DataTable Dt = BCO.QueryTransInByFind(ParameterList); if (Dt.Rows.Count != 0) { BindGrid(Dt); } else { ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "QueryNoData", "alert(' 查無資料 ');", true); } }
private void SetNoRangeValue(string strTransNo) { PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(1); ParameterList.Add(strTransNo); ParameterList.Add(""); ParameterList.Add(""); ParameterList.Add(""); ParameterList.Add(""); ParameterList.Add(""); DataTable Dt = BCO.QueryTransInByFind(ParameterList); DataRow dr = Dt.Select("TRANS_NO ='" + strTransNo + "'")[0]; if (dr["REMOVE_NO_RANGE"].ToString().IndexOf('~') != -1) { string[] strREMOVE_NO_RANGE = dr["REMOVE_NO_RANGE"].ToString().Split(new char[] { '~' }); lblRemove_No_Range.Text = strREMOVE_NO_RANGE[0] + "~<br>" + strREMOVE_NO_RANGE[1]; } else { lblRemove_No_Range.Text = ""; } if (dr["BACKWARD_NO_RANGE"].ToString().IndexOf('~') != -1) { string[] strRETURN_NO_RANGE = dr["BACKWARD_NO_RANGE"].ToString().Split(new char[] { '~' }); lblReturn_No_Range.Text = strRETURN_NO_RANGE[0] + "~<br>" + strRETURN_NO_RANGE[1]; } else { lblReturn_No_Range.Text = ""; } if (dr["ACCEPT_NO_RAGNE"].ToString().IndexOf('~') != -1) { string[] strST_ACCEPT_NO_RANGE = dr["ACCEPT_NO_RAGNE"].ToString().Split(new char[] { '~' }); lblST_Accept_No_Range.Text = strST_ACCEPT_NO_RANGE[0] + "~<br>" + strST_ACCEPT_NO_RANGE[1]; } else { lblST_Accept_No_Range.Text = ""; } if (dr["INOUT_NO_RANGE"].ToString().IndexOf('~') != -1) { string[] strINOUT_NO_RANGE = dr["INOUT_NO_RANGE"].ToString().Split(new char[] { '~' }); lblInOut_No_Range.Text = strINOUT_NO_RANGE[0] + "~<br>" + strINOUT_NO_RANGE[1]; } else { lblInOut_No_Range.Text = ""; } PanelList.Visible = true; //this.MID.Value = dr["ID"].ToString(); Session["MID"] = dr["ID"].ToString(); }