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