private void BillImport_Load(object sender, EventArgs e) { int jobcount = 0; Parent_Item = ListToImport[0].Parent_item; try { jobcount = (int)jobTableAdapter.CountJobs(ListToImport[0].Parent_item, "CJ%"); } catch { } if (jobcount > 0) { FetchBill form = new FetchBill(ListToImport[0].Parent_item); form.ShowDialog(); for (int i = 0; i < form.BillList.Count; i++) { WorkingGrid.Rows.Add(); WorkingGrid[1, i].Value = form.BillList[i].Item; WorkingGrid[0, i].Value = form.BillList[i].sequence; WorkingGrid[3, i].Value = form.BillList[i].qty; WorkingGrid[5, i].Value = form.BillList[i].u_m; } form.Close(); form.Dispose(); for (int i = 0; i < WorkingGrid.Rows.Count; i++) { for (int j = 0; j < ListToImport.Count; j++) { if (WorkingGrid[1, i].Value != null) { if (WorkingGrid[1, i].Value.ToString().Trim() == ListToImport[j].Item) { System.Diagnostics.Debug.Print(ListToImport[j].Item); WorkingGrid[2, i].Value = ListToImport[j].Qty; ListToImport.RemoveAt(j); } } } } for (int i = 0; i < ListToImport.Count; i++) { WorkingGrid.Rows.Insert(0); WorkingGrid[1, 0].Value = ListToImport[i].Item; WorkingGrid[2, 0].Value = ListToImport[i].Qty; WorkingGrid[0, 0].Value = Convert.ToInt32(WorkingGrid[0, WorkingGrid.Rows.Count - 1].Value) + 1; WorkingGrid.Sort(WorkingGrid.Columns[1], ListSortDirection.Ascending); } SetGrid(); } else { ItemCreate form = new ItemCreate(ListToImport[0].Parent_item, ""); form.ShowDialog(); if (form.DialogResult == DialogResult.Cancel) { form.Dispose(); this.Close(); this.Dispose(); } else { form.Dispose(); for (int i = 0; i < ListToImport.Count; i++) { WorkingGrid.Rows.Insert(0); WorkingGrid[0, 0].Value = i + 1; WorkingGrid[1, 0].Value = ListToImport[i].Item; WorkingGrid[2, 0].Value = ListToImport[i].Qty; WorkingGrid[4, 0].Value = ListToImport[i].Description; WorkingGrid.Sort(WorkingGrid.Columns[1], ListSortDirection.Ascending); } } } SetGrid(); for (int i = 0; i < WorkingGrid.Rows.Count; i++) { if (WorkingGrid[4, i].Value == null) { int ItemExists = 0; try { ItemExists = Convert.ToInt32(itemTableAdapter.ExistsCount(WorkingGrid[1, i].Value.ToString())); } catch { ItemExists = 0; } if (ItemExists != 0) { WorkingGrid[4, i].Value = itemTableAdapter.DescQuery(WorkingGrid[1, i].Value.ToString()); } } } }
private void BillImport_Load(object sender, EventArgs e) { int jobcount = 0; Parent_Item = ListToImport[0].Parent_item; try { jobcount = (int)jobTableAdapter.CountJobs(ListToImport[0].Parent_item, "CJ%"); } catch { } if (jobcount > 0) { FetchBill form = new FetchBill(ListToImport[0].Parent_item); form.ShowDialog(); for (int i = 0; i < form.BillList.Count; i++) { WorkingGrid.Rows.Add(); WorkingGrid[1, i].Value = form.BillList[i].Item; WorkingGrid[0, i].Value = form.BillList[i].sequence; WorkingGrid[3, i].Value = form.BillList[i].qty; WorkingGrid[5, i].Value = form.BillList[i].u_m; } form.Close(); form.Dispose(); for (int i = 0; i < WorkingGrid.Rows.Count; i++) { for (int j = 0; j < ListToImport.Count; j++) { if (WorkingGrid[1, i].Value != null) { if (WorkingGrid[1, i].Value.ToString().Trim() == ListToImport[j].Item) { System.Diagnostics.Debug.Print(ListToImport[j].Item); WorkingGrid[2, i].Value = ListToImport[j].Qty; ListToImport.RemoveAt(j); } } } } for (int i = 0; i < ListToImport.Count; i++) { WorkingGrid.Rows.Insert(0); WorkingGrid[1, 0].Value = ListToImport[i].Item; WorkingGrid[2, 0].Value = ListToImport[i].Qty; WorkingGrid[0, 0].Value = Convert.ToInt32 (WorkingGrid[0, WorkingGrid.Rows.Count - 1].Value) + 1; WorkingGrid.Sort(WorkingGrid.Columns[1], ListSortDirection.Ascending); } SetGrid(); } else { ItemCreate form = new ItemCreate(ListToImport[0].Parent_item ,""); form.ShowDialog(); if (form.DialogResult == DialogResult.Cancel) { form.Dispose(); this.Close(); this.Dispose(); } else { form.Dispose(); for (int i = 0; i < ListToImport.Count; i++) { WorkingGrid.Rows.Insert(0); WorkingGrid[0, 0].Value = i + 1; WorkingGrid[1, 0].Value = ListToImport[i].Item; WorkingGrid[2, 0].Value = ListToImport[i].Qty; WorkingGrid[4, 0].Value = ListToImport[i].Description; WorkingGrid.Sort(WorkingGrid.Columns[1], ListSortDirection.Ascending); } } } SetGrid(); for (int i = 0; i < WorkingGrid.Rows.Count; i++) { if (WorkingGrid[4, i].Value == null) { int ItemExists = 0; try { ItemExists = Convert.ToInt32 (itemTableAdapter.ExistsCount(WorkingGrid[1, i].Value.ToString())); } catch { ItemExists = 0; } if (ItemExists != 0) { WorkingGrid[4, i].Value = itemTableAdapter.DescQuery(WorkingGrid[1, i].Value.ToString()); } } } }