private void redyeingButton_Click(object sender, EventArgs e)
{
if (redyeing_voucher_id == -1)
{
c.ErrorBox("No Voucher Found/Linked");
return;
}
DataTable table = c.getTableRows("Redyeing_Voucher", "Voucher_ID=" + redyeing_voucher_id);
DataRow voucher = table.Rows[0];
M_V3_issueToReDyeingForm f = new M_V3_issueToReDyeingForm(voucher, false, new M_V_history(1));
f.deleteButton.Visible = false;
f.StartPosition = FormStartPosition.CenterScreen;
f.Show();
}
public M_V2_trayInputForm(string production_date, string tray_no, string spring, int no_of_springs, float tray_tare, float gross_weight, string quality, string company_name, string machine_no, string grade, float redyeing, int no_of_springs_rd, int edit_row_index, M_V3_issueToReDyeingForm f)
{
InitializeComponent();
this.issuesource = f.dataGridView1;
this.form = f;
c = new DbConnect();
//Create drop-down quality list
var dataSource1 = new List <string>();
this.d1 = c.getQC('q');
dataSource1.Add("---Select---");
for (int i = 0; i < d1.Rows.Count; i++)
{
dataSource1.Add(d1.Rows[i][0].ToString());
}
this.qualityCB.DataSource = dataSource1;
this.qualityCB.DisplayMember = "Quality";
this.qualityCB.DropDownStyle = ComboBoxStyle.DropDownList;//Create a drop-down list
this.qualityCB.AutoCompleteSource = AutoCompleteSource.ListItems;
this.qualityCB.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//Create drop-down Company list
var dataSource2 = new List <string>();
DataTable d2 = c.getQC('c');
for (int i = 0; i < d2.Rows.Count; i++)
{
dataSource2.Add(d2.Rows[i][0].ToString());
}
this.companyNameCB.DataSource = dataSource2;
this.companyNameCB.DisplayMember = "Company_Names";
this.companyNameCB.DropDownStyle = ComboBoxStyle.DropDownList;//Create a drop-down list
this.companyNameCB.AutoCompleteSource = AutoCompleteSource.ListItems;
this.companyNameCB.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//Create drop-down Spring list
spring_table = new DataTable();
var dataSource3 = new List <string>();
this.spring_table = c.getQC('s');
for (int i = 0; i < spring_table.Rows.Count; i++)
{
dataSource3.Add(spring_table.Rows[i][0].ToString());
}
this.springCB.DataSource = dataSource3;
this.springCB.DisplayMember = "Spring";
this.springCB.DropDownStyle = ComboBoxStyle.DropDownList;//Create a drop-down list
this.springCB.AutoCompleteSource = AutoCompleteSource.ListItems;
this.springCB.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//Create drop-down Spring list
var dataSource4 = new List <string>();
DataTable dm = c.getTableData("Machine_No", "*", "");
dataSource4.Add("---Select---");
for (int i = 0; i < dm.Rows.Count; i++)
{
dataSource4.Add(dm.Rows[i]["Machine_No"].ToString());
}
this.machineNoCB.DataSource = dataSource4;
this.machineNoCB.DisplayMember = "Machine_Number";
this.machineNoCB.DropDownStyle = ComboBoxStyle.DropDownList;//Create a drop-down list
this.machineNoCB.AutoCompleteSource = AutoCompleteSource.ListItems;
this.machineNoCB.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//Create drop-down Spring list
var dataSource5 = new List <string>();
dataSource5.Add("---Select---");
dataSource5.Add("1st");
dataSource5.Add("PQ");
dataSource5.Add("CLQ");
this.gradeCB.DataSource = dataSource5;
this.gradeCB.DisplayMember = "Grade";
this.gradeCB.DropDownStyle = ComboBoxStyle.DropDownList;//Create a drop-down list
this.gradeCB.AutoCompleteSource = AutoCompleteSource.ListItems;
this.gradeCB.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.tray_details.Columns.Add("Sl No");
this.tray_details.Columns.Add("Date Of Production");
this.tray_details.Columns.Add("Tray No");
this.tray_details.Columns.Add("Spring");
this.tray_details.Columns.Add("No Of Springs");
this.tray_details.Columns.Add("Tray Tare");
this.tray_details.Columns.Add("Gross Weight");
this.tray_details.Columns.Add("Quality");
this.tray_details.Columns.Add("Company Name");
this.tray_details.Columns.Add("Machine No");
this.tray_details.Columns.Add("Net Weight");
this.tray_details.Columns.Add("Quality Before Twist");
this.tray_details.Columns.Add("Grade");
this.tray_details.Columns.Add("Redyeing");
this.tray_details.Columns.Add("No Of Springs RD");
if (production_date != null)
{
this.dateTimePickerDTP.Value = this.dateTimePickerDTP.Value = Convert.ToDateTime(production_date);
}
if (tray_no != null)
{
this.trayNumberTB.Text = tray_no;
this.edit_redyeing_old_tray_no = tray_no;
}
if (spring != null)
{
this.springCB.SelectedIndex = this.springCB.FindStringExact(spring);
}
if (no_of_springs != -1)
{
this.numberOfSpringsTB.Text = no_of_springs.ToString();
}
if (tray_tare != -1F)
{
this.traytareTB.Text = tray_tare.ToString();
}
if (gross_weight != -1F)
{
this.grossWeightTB.Text = gross_weight.ToString();
}
if (quality != null)
{
this.qualityCB.SelectedIndex = this.qualityCB.FindStringExact(quality);
}
this.qualityCB.Enabled = false;
if (company_name != null)
{
this.companyNameCB.SelectedIndex = this.companyNameCB.FindStringExact(company_name);
}
this.companyNameCB.Enabled = false;
if (machine_no != null)
{
this.machineNoCB.SelectedIndex = this.machineNoCB.FindStringExact(machine_no);
}
if (grade != null)
{
this.gradeCB.SelectedIndex = this.gradeCB.FindStringExact(grade);
}
this.gradeCB.Enabled = false;
if (redyeing != -1F)
{
this.redyeingPerTB.Text = redyeing.ToString();
}
if (no_of_springs_rd != -1)
{
this.redyeingSpringsTB.Text = no_of_springs_rd.ToString();
}
this.Text = "Add Tray";
this.addButton.Text = "Add Tray";
this.redyeing = true;
if (this.issuesource.Rows.Count != 0)
{
this.tray_details = (DataTable)this.issuesource.DataSource;
}
this.StartPosition = FormStartPosition.Manual;
//set visible and readonly
this.redyeingPerTB.Visible = true;
this.redyeingSpringsTB.Visible = true;
this.add_edit_rd_paramsButton.Visible = true;
this.label16.Visible = true;
this.label17.Visible = true;
this.label18.Visible = true;
this.grossWeightTB.ReadOnly = true;
this.numberOfSpringsTB.ReadOnly = true;
this.traytareTB.ReadOnly = true;
if (edit_row_index != -1)
{
this.Text = "Edit Tray";
this.edit_reyeing_tray = true;
this.addButton.Text = "Confirm Edit";
this.edit_redyeing_tray_index = edit_row_index;
}
}
private void button4_Click_1(object sender, EventArgs e)
{
M_V3_issueToReDyeingForm f = new M_V3_issueToReDyeingForm();
Global.background.show_form(f);
}
