protected void txtAutoSize_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { //if (txtAutoSize.Entries.Count > 0) //{ // string size_desc = txtAutoSize.Entries[0].Text; // string[] size; // if (size_desc.ToUpper().Contains("X")) // { // size = size_desc.Split('X'); // txtSize1.Text = size[0].Trim(); // txtSize2.Text = size[1].Trim(); // } // else // { // txtSize1.Text = size_desc.Trim(); // txtSize2.Text = ""; // } //} //else //{ // txtSize1.Text = ""; // txtSize2.Text = ""; //} }
protected void txtMatcodeNumber_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { //Master.ShowMessage(txtMRNumber.Entries[0].Text); if (txtTagNo.Entries.Count > 0) { txtMatDescr.Text = WebTools.GetExpr("MAT_DESCR", "PIP_MAT_STOCK", " WHERE MAT_CODE1='" + txtTagNo.Entries[0].Text + "'"); } }
protected void txtMRNumber_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { //Master.ShowMessage(txtMRNumber.Entries[0].Text); if (txtMRNumber.Entries.Count > 0) { txtPOSubject.Text = WebTools.GetExpr("MR_TITLE", "PIP_MAT_REQUISITION", " WHERE MR_NO='" + txtMRNumber.Entries[0].Text + "'"); } }
protected void RadAutoCompleteBox1_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { //Get Available & Previous Issued Qty string mat_id = WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " WHERE MAT_CODE1='" + RadAutoCompleteBox1.Entries[0].Text + "'"); string sc_id = WebTools.GetExpr("SC_ID", "PIP_PAINTING_MAT", " WHERE PAINT_ID='" + Request.QueryString["PAINT_ID"] + "'"); txtAvlQty.Text = WebTools.GetExpr("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID = " + mat_id + " and SUB_CON_ID = '" + sc_id + "'"); txtPrevJcQty.Text = WebTools.GetExpr("ISSUED_QTY", "VIEW_PAINT_ISSUED", " WHERE SC_ID = '" + sc_id + "' AND MAT_ID = '" + mat_id + "'"); }
protected void txtAutoMatCode_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { string matcode = txtAutoMatCode.Text; if (!string.IsNullOrEmpty(matcode.Trim())) { string mat_id = WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " WHERE MAT_CODE1 = '" + matcode + "'"); Response.Redirect("MaterialStock_Recon_A.aspx?MAT_ID=" + mat_id); } }
protected void txtAutoRFINo_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { HiddenMRVID.Value = WebTools.GetExpr("MRR_ID", "PIP_MAT_INSP_REQUEST", " WHERE RFI_NO = '" + txtAutoRFINo.Text.Trim() + "'"); ddlMRVList.DataBind(); if (HiddenMRVID.Value != null) { ddlMRVList.SelectedValue = HiddenMRVID.Value; refreshData(); } ddlMRVList.Enabled = false; }
protected void txtSize_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { if (txtSize1.Entries.Count > 0) { size_desc = txtSize1.Entries[0].Text; } if (txtSize2.Entries.Count > 0) { if (txtSize1.Entries.Count < 1) { size_desc = txtSize2.Entries[0].Text; } else { size_desc = size_desc + " X " + txtSize2.Entries[0].Text; } } txtsizeDesc.Text = ""; txtsizeDesc.Text = size_desc; }
protected void RadAutoCompleteBox1_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e) { // SELECT [l-kabinet].* //FROM [l-kabinet] //WHERE (F LIKE N'вол%') }