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'вол%')
}
