private void cmbParentCat_SelectedIndexChanged(object sender, EventArgs e)
{
string keywords = cmbParentCat.Text;
if (!string.IsNullOrEmpty(keywords))
{
errorProvider1.Clear();
DataTable dt = dalItem.CatSearch(keywords);
DataTable distinctTable = dt.DefaultView.ToTable(true, "item_name");
distinctTable.DefaultView.Sort = "item_name ASC";
cmbParentName.DataSource = distinctTable;
cmbParentName.DisplayMember = "item_name";
cmbParentName.ValueMember = "item_name";
if (string.IsNullOrEmpty(cmbParentName.Text))
{
cmbParentCode.DataSource = null;
}
}
else
{
cmbParentName.DataSource = null;
}
cmbParentName.SelectedIndex = -1;
updateTestName();
}
private void LoadPartList(DataGridView dgv)
{
int index = 1;
DataTable dt = dalItem.CatSearch(cmbCat.Text);
dt.DefaultView.Sort = "item_name ASC";
dt = dt.DefaultView.ToTable();
dgv.Rows.Clear();
foreach (DataRow item in dt.Rows)
{
float partf = 0;
float runnerf = 0;
int n = dgv.Rows.Add();
if (!string.IsNullOrEmpty(item[dalItem.ItemProPWPcs].ToString()))
{
partf = Convert.ToSingle(item[dalItem.ItemProPWPcs]);
}
if (!string.IsNullOrEmpty(item[dalItem.ItemProRWPcs].ToString()))
{
runnerf = Convert.ToSingle(item[dalItem.ItemProRWPcs]);
}
dgv.Rows[n].Cells[indexColName].Value = index;
dgv.Rows[n].Cells[dalItem.ItemMaterial].Value = item[dalItem.ItemMaterial].ToString();
dgv.Rows[n].Cells[dalItem.ItemName].Value = item[dalItem.ItemName].ToString();
dgv.Rows[n].Cells[dalItem.ItemCode].Value = item[dalItem.ItemCode].ToString();
dgv.Rows[n].Cells[dalItem.ItemColor].Value = item[dalItem.ItemColor].ToString();
dgv.Rows[n].Cells[dalItem.ItemMBatch].Value = item[dalItem.ItemMBatch].ToString();
dgv.Rows[n].Cells[dalItem.ItemQuoTon].Value = item[dalItem.ItemQuoTon].ToString();
dgv.Rows[n].Cells[dalItem.ItemBestTon].Value = item[dalItem.ItemBestTon].ToString();
dgv.Rows[n].Cells[dalItem.ItemProTon].Value = item[dalItem.ItemProTon].ToString();
dgv.Rows[n].Cells[dalItem.ItemQuoCT].Value = item[dalItem.ItemQuoCT].ToString();
dgv.Rows[n].Cells["ProCT"].Value = item[dalItem.ItemProCTFrom].ToString() + " - " + item[dalItem.ItemProCTTo].ToString();
dgv.Rows[n].Cells["ItemWeight(g)"].Value = (partf + runnerf).ToString();
dgv.Rows[n].Cells[dalItem.ItemQuoPWPcs].Value = item[dalItem.ItemQuoPWPcs].ToString();
dgv.Rows[n].Cells[dalItem.ItemQuoRWPcs].Value = item[dalItem.ItemQuoRWPcs].ToString();
dgv.Rows[n].Cells[dalItem.ItemProPWShot].Value = item[dalItem.ItemProPWShot].ToString();
dgv.Rows[n].Cells[dalItem.ItemProRWShot].Value = item[dalItem.ItemProRWShot].ToString();
dgv.Rows[n].Cells[dalItem.ItemCavity].Value = item[dalItem.ItemCavity].ToString();
dgv.Rows[n].Cells[dalItem.ItemProCooling].Value = item[dalItem.ItemProCooling].ToString();
dgv.Rows[n].Cells[dalItem.ItemProPWPcs].Value = partf.ToString("0.00");
dgv.Rows[n].Cells[dalItem.ItemProRWPcs].Value = runnerf.ToString("0.00");
index++;
}
tool.listPaint(dgv);
if (dt.Rows.Count <= 0 && formLoaded)
{
MessageBox.Show("no data under this record");
}
}
private void LoadPackingToCMB()
{
DataTable dt_Packaging = dalItem.CatSearch(text.Cat_Packaging);
DataTable dt_Packaging_ItemName = dt_Packaging.DefaultView.ToTable(true, "item_name");
DataTable dt_Carton = dalItem.CatSearch(text.Cat_Carton);
DataTable dt_Carton_ItemName = dt_Carton.DefaultView.ToTable(true, "item_name");
DataTable dt_All = dt_Packaging.Copy();
dt_All.Merge(dt_Carton);
dt_All.DefaultView.Sort = "item_name ASC";
cmbPackingName.DataSource = dt_All;
cmbPackingName.DisplayMember = "item_name";
cmbPackingName.SelectedIndex = -1;
cmbPackingCode.DataSource = null;
}
private void loadItemNameData()
{
string keywords = cmbItemCat.Text;
if (!string.IsNullOrEmpty(keywords))
{
DataTable dt = dalItem.CatSearch(keywords);
DataTable dtItemName = dt.DefaultView.ToTable(true, "item_name");
dtItemName.DefaultView.Sort = "item_name ASC";
cmbItemName.DataSource = dtItemName;
cmbItemName.DisplayMember = "item_name";
}
else
{
cmbItemName.DataSource = null;
}
}
