private void FillItemCode()
{
DrpItemDescription.Items.Clear();
// DDLMaterialCode.Items.Add("Select...");
if (drpItemCategory.Text == "Select..." && drpItemCode.Text == "Select..." || drpItemCode.Text == "")
{
strQuery = "select distinct(ItemId) as Product_Code,concat([ITEMID],' - ',Product_Name) as Product_Name from ax.INVENTTABLE where PRODUCT_GROUP ='POP' and BLOCK=0 order by Product_Name";
DrpItemDescription.Items.Clear();
DrpItemDescription.Items.Add("Select...");
baseObj.BindToDropDown(DrpItemDescription, strQuery, "Product_Name", "Product_Code");
DrpItemDescription.Focus();
}
}
protected void drpItemCode_SelectedIndexChanged(object sender, EventArgs e)
{
strQuery = "Select distinct P.ITEMID+'-'+P.Product_Name as Name,P.ITEMID from ax.InventTable P where Product_Group='POP' AND P.BLOCK=0 and P.PRODUCT_SUBCATEGORY ='" + drpItemCode.SelectedItem.Value + "'"; //--AND SITE_CODE='657546'";
DrpItemDescription.DataSource = null;
DrpItemDescription.Items.Clear();
//DDLMaterialCode.Items.Add("Select...");
baseObj.BindToDropDown(DrpItemDescription, strQuery, "Name", "ITEMID");
DrpItemDescription.Items.Add("Select...");
// txtAvailableQuantity.Text = string.Empty;
txtRemark.Text = string.Empty;
txtQTYPcs.Text = string.Empty;
DrpItemDescription.Enabled = true;
//DDLMaterialCode.SelectedIndex = 0;
//DDLMaterialCode_SelectedIndexChanged(sender, e);
DrpItemDescription.Focus();
if (DrpItemDescription.SelectedItem.Text != "Select...")
{
DrpItemDescription_SelectedIndexChanged(null, null);
}
}
