private void button对账_Click(object sender, EventArgs e) { 对账 win = new 对账(); win.ShowDialog(); }
public 打印对账单(对账 parent, DataTable dt, int pages) : this() { int page = pages;//设置10行分页 string customerName = parent.comboBox客户.Text; DateTime startDate = parent.dateTimePicker对账起始日.Value; DateTime endDate = parent.dateTimePicker对账截止日.Value; DateTime today = DateTime.Today; string contact = parent.com客户联系人.Text; string phone = parent.text联系电话.Text; string addr = parent.text收货地址.Text; string fax = parent.textBox传真.Text; string payMod = parent.textBox结算方式.Text; string year = endDate.Year.ToString(); string month = endDate.Month.ToString(); string result = Utils.GetTemplateContent(templatePath); //string result = ""; string value = ""; bool nextpage = false; int pagenum = 0; double totalSum = 0; string 发货时间 = ""; string 送货单号 = ""; string 产品名称 = ""; string 订单编号 = ""; string 规格 = ""; string 材质 = ""; string 数量 = ""; string 成交价 = ""; string 金额 = ""; for (int p = 0; p < dt.Rows.Count / page + 1; p++) { for (int i = 0; i < page; i++) { if (dt.Rows.Count == i + p * page) { nextpage = false; break; } nextpage = true; value += "<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:14.2pt'>"; 发货时间 = dt.Rows[i + p * page]["发货时间"].ToString(); 送货单号 = dt.Rows[i + p * page]["送货单号"].ToString(); 产品名称 = dt.Rows[i + p * page]["产品名称"].ToString(); 订单编号 = dt.Rows[i + p * page]["订单编号"].ToString(); 规格 = dt.Rows[i + p * page]["规格"].ToString(); 材质 = dt.Rows[i + p * page]["材质"].ToString(); 数量 = dt.Rows[i + p * page]["数量"].ToString(); 成交价 = dt.Rows[i + p * page]["成交价"].ToString(); 金额 = Convert.ToString(Convert.ToDouble(成交价) * Convert.ToInt32(数量)); totalSum += Convert.ToDouble(成交价) * Convert.ToUInt32(数量); value += Utils.GetTableTD(发货时间) + Utils.GetTableTD(送货单号) + Utils.GetTableTD(产品名称) + Utils.GetTableTD(订单编号) + Utils.GetTableTD(规格) + Utils.GetTableTD(材质) + Utils.GetTableTD(数量) + Utils.GetTableTD(成交价) + Utils.GetTableTD(金额) + "</tr>"; } if ((p + 1) * page == dt.Rows.Count) { nextpage = false; } if (+dt.Rows.Count % page > 0) { pagenum = dt.Rows.Count / page + 1; } else { pagenum = dt.Rows.Count / page; } result = result.Replace("{页码}", Convert.ToString(p + 1) + "/" + Convert.ToString(pagenum)); result = result.Replace("{table_content}", value); if (nextpage) { result += "<p style=\"page-break-after:always;\"> </p>";//分页 result += Utils.GetTemplateContent(templatePath); value = ""; } } result = result.Replace("{年份}", year); result = result.Replace("{月份}", month); result = result.Replace("{客户名称}", customerName); result = result.Replace("{结算方式}", payMod); result = result.Replace("{列印日期}", today.ToShortDateString()); result = result.Replace("{联系人}", contact); result = result.Replace("{性质}", " "); result = result.Replace("{联系电话}", phone); result = result.Replace("{起始日期}", startDate.ToShortDateString()); result = result.Replace("{币种}", "RMB"); result = result.Replace("{传真}", fax); result = result.Replace("{截止日期}", endDate.ToShortDateString()); result = result.Replace("{单位}", " "); result = result.Replace("{地址}", addr); result = result.Replace("{总金额}", totalSum.ToString()); result = result.Replace("{财务}", Utils.GetLogonToken().Name); Utils.WriteToTemplate(targetPath, result); webBrowser预览.Url = new Uri(targetPath);//显示网页 }