public printDyeingOutward(DataRow row, M_V4_printDyeingOutward f) { InitializeComponent(); this.c = new DbConnect(); this.parent = f; if (row.Table.Columns.Count < 3) { return; } //Load firm details DataTable dt10 = c.runQuery("SELECT * FROM Defaults WHERE Default_Type= 'Print' and default_name = 'Default Print Type'"); string default_print_type_id = dt10.Rows[0]["Default_Value"].ToString(); DataTable dt_printTypes = c.runQuery("select * from Print_Types where Print_Type_ID=" + default_print_type_id); if (dt_printTypes == null) { c.WarningBox("Print->Default Print Type is set as " + default_print_type_id + ", not found in Default Print_Type_IDs Table, " + "defaulting to first entry in Print_Types table"); dt_printTypes = c.runQuery("select * from Print_Types"); } for (int j = 0; j < dt_printTypes.Columns.Count - 1; j++) { firmDetails[dt_printTypes.Columns[j].ColumnName] = dt_printTypes.Rows[0][j].ToString(); } this.batchnoTextbox.Text = row["Batch_No"].ToString(); //this.dateTimePicker1.Value = Convert.ToDateTime(row["Input_Date"].ToString()); this.outDateTextbox.Text = row["Dyeing_Out_Date"].ToString().Substring(0, 10); this.customerNameTextbox.Text = row["Dyeing_Company_Name"].ToString(); this.qualityTextbox.Text = row["Quality"].ToString(); this.shadeTextbox.Text = row["Colour"].ToString(); DataTable dyeing_company = c.getTableRows("Dyeing_Company_Names", "Dyeing_Company_Names='" + row["Dyeing_Company_Name"].ToString() + "'"); this.customerAddressTextbox.Text = dyeing_company.Rows[0]["Customer_Address"].ToString(); this.customergstin.Text = dyeing_company.Rows[0]["GSTIN"].ToString(); DataTable quality = c.getTableRows("Quality", "Quality='" + row["Quality"].ToString() + "'"); this.hsnnumber.Text = quality.Rows[0]["HSN_No"].ToString(); this.label6.Text = "(GSTIN No. " + firmDetails["GSTIN"] + ")"; this.label5.Text = firmDetails["Address"]; this.label3.Text = firmDetails["Firm_Name"]; string[] tray_ids = c.csvToArray(row["Tray_ID_Arr"].ToString()); if (!string.IsNullOrEmpty(row["Redyeing"].ToString())) { this.redyeing = true; this.rdLabel.Visible = true; } DataTable dt = new DataTable(); dt.Columns.Add("Sl No"); dt.Columns.Add("Tray No."); dt.Columns.Add("Gross Wt"); dt.Columns.Add("Tray Wt"); dt.Columns.Add("MNo"); dt.Columns.Add("Springs"); dt.Columns.Add("Spring Wt"); dt.Columns.Add("Net Wt"); float net_wt = 0F; int total_springs = 0; for (int i = 0; i < tray_ids.Length; i++) { DataTable dtemp = c.getTrayTable_TrayID(int.Parse(tray_ids[i])); int no_of_springs = int.Parse(dtemp.Rows[0]["Number_Of_Springs"].ToString()); float spring_wt = c.getSpringWeight(dtemp.Rows[0]["Spring"].ToString()) * no_of_springs; float gross_wt = float.Parse(dtemp.Rows[0]["Gross_Weight"].ToString()); float tray_wt = float.Parse(dtemp.Rows[0]["Net_Weight"].ToString()); if (row["Dyeing_Company_Name"].ToString() == "Ichalkaranji Textiles Pvt Ltd") { gross_wt -= 1.25F; tray_wt -= 1.25F; } net_wt += tray_wt; total_springs += no_of_springs; dt.Rows.Add(i + 1, dtemp.Rows[0]["Tray_No"].ToString(), gross_wt, dtemp.Rows[0]["Tray_Tare"].ToString(), dtemp.Rows[0]["Machine_No"].ToString(), dtemp.Rows[0]["Number_of_Springs"].ToString(), spring_wt, tray_wt); } this.netwtTextbox.Text = net_wt.ToString("F3"); dt.Rows.Add("", "", "", "", "Total Springs", total_springs, "Net Weight", net_wt); dataGridView1.DataSource = dt; int weight_width = 100; dataGridView1.Columns["Sl No"].Width = 70; dataGridView1.Columns["Tray No."].Width = 100; dataGridView1.Columns["Gross Wt"].Width = weight_width; dataGridView1.Columns["Tray Wt"].Width = weight_width; dataGridView1.Columns["MNo"].Width = 50; dataGridView1.Columns["Springs"].Width = 50; dataGridView1.Columns["Spring Wt"].Width = weight_width; dataGridView1.Columns["Net Wt"].Width = weight_width; dataGridView1.DefaultCellStyle.SelectionBackColor = Color.White; dataGridView1.DefaultCellStyle.SelectionForeColor = Color.Black; dataGridView1.Columns.Cast <DataGridViewColumn>().ToList().ForEach(t => t.SortMode = DataGridViewColumnSortMode.NotSortable); c.auto_adjust_dgv(dataGridView1); dataGridView1.Columns["Sl No"].AutoSizeMode = DataGridViewAutoSizeColumnMode.None; dataGridView1.Columns["Sl No"].Width = 80; c.set_dgv_column_sort_state(dataGridView1, DataGridViewColumnSortMode.NotSortable); this.where = "Batch_No=" + this.batchnoTextbox.Text + " AND Fiscal_Year='" + row["Fiscal_Year"].ToString() + "'"; this.label3.Text = firmDetails["Firm_Name"]; this.label5.Text = firmDetails["Address"]; this.label6.Text = "(GSTIN No. " + firmDetails["GSTIN"] + ")"; PrinterSettings ps = new PrinterSettings(); printDocument1.PrinterSettings = ps; IEnumerable <PaperSize> paperSizes = ps.PaperSizes.Cast <PaperSize>(); PaperSize sizeA4 = paperSizes.First <PaperSize>(size => size.Kind == PaperKind.A4); // setting paper size to A4 size printDocument1.DefaultPageSettings.PaperSize = sizeA4; }
private void button1_Click(object sender, EventArgs e) { M_V4_printDyeingOutward f = new M_V4_printDyeingOutward(); Global.background.show_form(f); }