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; } }