-
Notifications
You must be signed in to change notification settings - Fork 0
/
ReportCommonRepairForm.cs
69 lines (67 loc) · 3 KB
/
ReportCommonRepairForm.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
//文件名:ReportCommonRepairForm.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Reflection;
using System.Data.SqlClient;
using System.Drawing.Printing;
using MyCommunity.Common;
namespace MyCommunity
{
public partial class ReportCommonRepairForm : DevComponents.DotNetBar.Office2007Form
{
private DataTable dtData = new DataTable();
private DataGridViewPrinter print = null;
private string MyCommunity;
private string MyPrintIcon;
public ReportCommonRepairForm(string myCommunity, string myPrintIcon)
{
this.MyCommunity = myCommunity;
this.MyPrintIcon = myPrintIcon;
InitializeComponent();
this.开始日期DateTimePicker.Value = DateTime.Now.Date;
this.结束日期DateTimePicker.Value = DateTime.Now.Date;
}
private void 查询Button_Click(object sender, EventArgs e)
{//查询公共维修信息
dtData.Rows.Clear();
string query = "Select * FROM 公共维修 WHERE (报修日期 BETWEEN '" + this.开始日期DateTimePicker.Value.ToString("yyyy-MM-dd") +
"' AND '" + this.结束日期DateTimePicker.Value.ToString("yyyy-MM-dd") + "') AND (故障现象 LIKE '%" + this.故障现象TextBox.Text + "%') ORDER BY 报修日期";
dtData = DataHelper.GetDataTable(query);
this.公共维修报表DataGridView.DataSource = dtData;
}
private void 打印Button_Click(object sender, EventArgs e)
{//打印公共维修信息
string title = this.MyCommunity + "公共维修信息表";
printDocument.DocumentName = title;
printDocument.PrinterSettings = printDialog.PrinterSettings;
printDocument.DefaultPageSettings = printDialog.PrinterSettings.DefaultPageSettings;
//太大横向打印
printDocument.DefaultPageSettings.Landscape = true;
printDocument.DefaultPageSettings.Margins = new Margins(10, 10, 20, 20);
print = new DataGridViewPrinter(this.公共维修报表DataGridView, printDocument, title);
PrintPreviewDialog printPreviewDialog = new PrintPreviewDialog();
printPreviewDialog.WindowState = FormWindowState.Maximized;
printPreviewDialog.Icon = new Icon(this.MyPrintIcon);
printPreviewDialog.Document = printDocument;
printPreviewDialog.ShowDialog();
}
private void printDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
try
{
bool more = print.DrawDataGridView(e.Graphics);
if (more == true)
e.HasMorePages = true;
}
catch (Exception ex)
{
LogHelper.LogError(ex);
}
}
}
}