private void PrintBing() { string strsql = "SELECT material_stock.Material_id,"; strsql += "material_stock.Material_inside_name,"; strsql += "material_stock.Material_stock,"; strsql += "material.Material_class"; strsql += " FROM material_stock, material WHERE material_stock.Matid = material.Matid ORDER BY material.Material_class ASC,material_stock.Material_inside_name ASC "; ds_mat_stockReport ds = new ds_mat_stockReport(); MySqlConnection conn = new MySqlConnection(connectstr.CONNECTSTR); conn.Open(); try { MySqlCommand cmd = new MySqlCommand(strsql, conn); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ds.Tables["tb_mat_stockReport"].Load(dr); ReportDataSource rds = new ReportDataSource(); mat_stockReportview.LocalReport.ReportEmbeddedResource = "MTsystem_win.printForm.mat_stockReportview.rdlc"; rds.Name = "ds_mat_stockReport"; rds.Value = ds.Tables["tb_mat_stockReport"]; mat_stockReportview.LocalReport.DataSources.Add(rds); this.mat_stockReportview.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); this.mat_stockReportview.ZoomMode = ZoomMode.PageWidth; this.mat_stockReportview.ZoomPercent = 100; this.mat_stockReportview.RefreshReport(); } catch (MySqlException ex) { MessageBox.Show("错误代码:" + ex.Number + " 错误信息:" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 材料进仓日报表 /// </summary> private void matInputReport() { string strsql; if (txt_Queryid.Text.Trim().Length != 0) { strsql = "SELECT material_input.Material_id,"; strsql += "material_input.Material_inside_name,material_input.Material_jlsl,"; strsql += "material_input.Material_unit,material_input.Jlzl,material_input.Input_date,"; strsql += "material.Material_class FROM material_input,material"; strsql += " WHERE material_input.Material_id = '" + txt_Queryid.Text.Trim() + "'"; strsql += " AND material_input.Input_date >= '" + dtp_Querydate.Value.ToShortDateString().Trim() + "'"; strsql += " AND material_input.Input_date <= '" + dtp_QuerydateEnd.Value.ToShortDateString().Trim() + "'"; strsql += " AND material_input.Matid = material.Matid"; strsql += " ORDER BY material_input.Input_date ASC"; #region ds_mat_stockReport ds = new ds_mat_stockReport(); MySqlConnection conn = new MySqlConnection(connectstr.CONNECTSTR); conn.Open(); try { MySqlCommand cmd = new MySqlCommand(strsql, conn); MySqlDataReader dr = null; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ds.Tables["tb_mat_inputReport"].Load(dr); ReportDataSource rds = new ReportDataSource(); mat_dayReportview.LocalReport.ReportEmbeddedResource = "MTsystem_win.printForm.mat_dayinReportview.rdlc"; rds.Name = "ds_mat_stockReport"; rds.Value = ds.Tables["tb_mat_inputReport"]; mat_dayReportview.LocalReport.DataSources.Add(rds); this.mat_dayReportview.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); this.mat_dayReportview.ZoomMode = ZoomMode.PageWidth; this.mat_dayReportview.ZoomPercent = 100; this.mat_dayReportview.RefreshReport(); } catch (MySqlException ex) { MessageBox.Show("错误代码:" + ex.Number + " 错误信息:" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion } else { if (cb_date.Checked) { strsql = "SELECT material_input.Material_id,"; strsql += "material_input.Material_inside_name,material_input.Material_jlsl,"; strsql += "material_input.Material_unit,material_input.Jlzl,material_input.Input_date,"; strsql += "material.Material_class FROM material_input,material"; strsql += " WHERE material_input.Input_date >= '" + dtp_Querydate.Value.ToShortDateString().Trim() + "'"; strsql += " AND material_input.Input_date <= '" + dtp_QuerydateEnd.Value.ToShortDateString().Trim() + "'"; strsql += " AND material_input.Matid = material.Matid"; strsql += " ORDER BY material_input.Input_date ASC"; } else { strsql = "SELECT material_input.Material_id,"; strsql += "material_input.Material_inside_name,material_input.Material_jlsl,"; strsql += "material_input.Material_unit,material_input.Jlzl,material_input.Input_date,"; strsql += "material.Material_class FROM material_input,material"; strsql += " WHERE material_input.Input_date >= '" + dtp_Querydate.Value.ToShortDateString().Trim() + "'"; strsql += " AND material_input.Input_date <= '" + dtp_QuerydateEnd.Value.ToShortDateString().Trim() + "'"; strsql += " AND material_input.Matid = material.Matid"; strsql += " ORDER BY material.Material_class ASC"; } #region ds_mat_stockReport ds = new ds_mat_stockReport(); MySqlConnection conn = new MySqlConnection(connectstr.CONNECTSTR); conn.Open(); try { MySqlCommand cmd = new MySqlCommand(strsql, conn); MySqlDataReader dr = null; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ds.Tables["tb_mat_inputReport"].Load(dr); ReportDataSource rds = new ReportDataSource(); mat_dayReportview.LocalReport.ReportEmbeddedResource = "MTsystem_win.printForm.mat_dayinReportview.rdlc"; rds.Name = "ds_mat_stockReport"; rds.Value = ds.Tables["tb_mat_inputReport"]; mat_dayReportview.LocalReport.DataSources.Add(rds); this.mat_dayReportview.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); this.mat_dayReportview.ZoomMode = ZoomMode.PageWidth; this.mat_dayReportview.ZoomPercent = 100; this.mat_dayReportview.RefreshReport(); } catch (MySqlException ex) { MessageBox.Show("错误代码:" + ex.Number + " 错误信息:" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion } }