-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathnew 入库汇总.cs
230 lines (224 loc) · 10 KB
/
new 入库汇总.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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
using Sunny.UI;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Warehouse
{
public partial class new_入库汇总 : UITitlePage
{
BLL.enter_storage bllenter = new BLL.enter_storage();
public new_入库汇总()
{
InitializeComponent();
//加载几个下拉框
//加载库位编号
//comStorage.DisplayMember = "enter_sl_id";
//加载物品名称
//comStorage.DisplayMember = "enter_mat_name";
//加载经办人
//comStorage.DisplayMember = "enter_agent_name";
//加载入库批次编号
//comStorage.DisplayMember = "enter_batch_id";
//进行数据绑定
grid.AddColumn("入库编号", "enter_id");
grid.AddColumn("入库批次编号", "enter_batch_id");
grid.AddColumn("库位编号", "enter_sl_id");
grid.AddColumn("入库量", "enter_amount");
grid.AddColumn("单位体积", "enter_unit_bulk");
grid.AddColumn("供应商编号", "supplier_id");
grid.AddColumn("入库物料id", "enter_mat_id");
grid.AddColumn("物料名称", "enter_mat_name");
grid.AddColumn("封记号", "enter_fengji_num");
grid.AddColumn("入库日期", "enter_date");
grid.AddColumn("经办人id", "enter_agent_id");
grid.AddColumn("经办人姓名", "enter_agent_name");
grid.AddColumn("备注", "enter_comment");
//自适应列距离
for (int i = 0; i < grid.ColumnCount; i++) { grid.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; }
AddRow();
}
private void AddRow()
{
BLL.enter_storage bllenter = new BLL.enter_storage();
this.grid.DataSource = bllenter.GetModelList("");
uiPagination1.DataSource = bllenter.GetModelList("");
uiPagination1.ActivePage = 1;
}
private void uiLabel5_Click(object sender, EventArgs e)
{
}
//查询
private void uiButton2_Click(object sender, EventArgs e)
{
//StringBuilder strSql = new StringBuilder();
string strSql = "";
//用于判断时间是否填写
if (startTime1.Value.ToString() != null)
{
if (endTime1.Value.ToString() != null)
{
//时间戳的查询
//SELECT * FROM enter_storage WHERE UNIX_TIMESTAMP(enter_date) BETWEEN UNIX_TIMESTAMP('2019-07-25 00:00:33') AND UNIX_TIMESTAMP('2019-07-25 00:54:33')
//如果时间输入不合法则判断错误
DateTime time1 = DateTime.Parse(startTime1.Value.ToString());
DateTime time2 = DateTime.Parse(endTime1.Value.ToString());
if (time1 > time2)
{
//提示错误
UIMessageBox.ShowSuccess("时间填写错误");
}
}
//strSql += "and date between '" + startTime1.Text.ToString() + " 00:00:00.000000' and '" + endTime1.Text.ToString() + " 00:00:00.000000";
//strSql += "and date between '"+ startTime1.Text.ToString() + "' and '"+ endTime1.Text.ToString() + "' ";
strSql += "UNIX_TIMESTAMP(enter_date) between UNIX_TIMESTAMP('" + (startTime1.Text.ToString()) + "')and UNIX_TIMESTAMP('" + (endTime1.Text.ToString()) + "')";
}
//用于判断物品名称是否选择
if (comMatName.Text != "")
{
strSql += "and enter_storage.enter_mat_name='" + comMatName.SelectedValue.ToString() + "'";
}
//用于判断库位编号是否选择
if (comStorage.Text != "")
{
strSql += "and enter_storage.enter_sl_id='" + comStorage.SelectedValue.ToString() + "'";
}
//用于判断经办人是否选择
if (comStaffName.Text != "")
{
strSql += "and enter_storage.enter_agent_name='" + comStaffName.SelectedValue.ToString() + "'";
}
//入库批次是否选择
if (comBatch.Text != "")
{
strSql += "and enter_storage.enter_batch_id='" + comBatch.SelectedValue.ToString() + "'";
}
grid.ClearAll();
grid.AddColumn("入库编号", "enter_id");
grid.AddColumn("入库批次编号", "enter_batch_id");
grid.AddColumn("库位编号", "enter_sl_id");
grid.AddColumn("入库量", "enter_amount");
grid.AddColumn("单位体积", "enter_unit_bulk");
grid.AddColumn("供应商编号", "supplier_id");
grid.AddColumn("入库物料id", "enter_mat_id");
grid.AddColumn("物料名称", "enter_mat_name");
grid.AddColumn("封记号", "enter_fengji_num");
grid.AddColumn("入库日期", "enter_date");
grid.AddColumn("经办人id", "enter_agent_id");
grid.AddColumn("经办人姓名", "enter_agent_name");
grid.AddColumn("备注", "enter_comment");
uiPagination1.DataSource = bllenter.GetModelList(strSql);
grid.DataSource = bllenter.GetModelList(strSql);
}
//重置
private void uiButton1_Click(object sender, EventArgs e)
{
comBatch.Text = "";
comMatName.Text = "";
comStorage.Text = "";
comStaffName.Text = "";
}
//加载物品名称
private void comMatName_Load(object sender, EventArgs e)
{
BLL.material_info bllenter1 = new BLL.material_info();
comMatName.DataSource = bllenter1.GetModelList("");
comMatName.DisplayMember = "mat_name";
comMatName.ValueMember = "mat_name";
}
//加载库位编号
private void comStorage_Load(object sender, EventArgs e)
{
BLL.storagelocation bllenter1 = new BLL.storagelocation();
comStorage.DataSource = bllenter1.GetModelList("");
comStorage.DisplayMember = "sl_id";
comStorage.ValueMember = "sl_id";
//comStorage.DataSource = bllenter.GetModelList("");
//comStorage.DisplayMember = "enter_sl_id";
//comStorage.ValueMember = "enter_sl_id";
}
//加载经办人
private void comStaffName_Load(object sender, EventArgs e)
{
BLL.staff bllenter1 = new BLL.staff();
comStaffName.DataSource = bllenter1.GetModelList("");
comStaffName.DisplayMember = "staff_name";
comStaffName.ValueMember = "staff_name";
}
//加载入库批次编号
private void comBatch_Load(object sender, EventArgs e)
{
comBatch.DataSource = bllenter.GetModelList("");
comBatch.DisplayMember = "enter_batch_id";
comBatch.ValueMember = "enter_batch_id";
}
//导出数据
private void uiButton3_Click(object sender, EventArgs e)
{
//文件位置
string a = "D:" + "\\入库汇总.xls";
//调用文件导出函数
ExportExcels(a, grid);
}
/// <summary>
///
/// </summary>
/// <param name="fileName">文件路径</param>
/// <param name="myDGV">控件DataGridView</param>
private void ExportExcels(string fileName, DataGridView myDGV)
{
string saveFileName = "";
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.DefaultExt = "xls";
saveDialog.Filter = "Excel文件|*.xls";
saveDialog.FileName = fileName;
saveDialog.ShowDialog();
saveFileName = saveDialog.FileName;
if (saveFileName.IndexOf(":") < 0) return; //被点了取消
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
MessageBox.Show("无法创建Excel对象，可能您的机子未安装Excel");
return;
}
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
//写入标题
for (int i = 0; i < myDGV.ColumnCount; i++)
{
worksheet.Cells[1, i + 1] = myDGV.Columns[i].HeaderText;
}
//写入数值
for (int r = 0; r < myDGV.Rows.Count; r++)
{
for (int i = 0; i < myDGV.ColumnCount; i++)
{
worksheet.Cells[r + 2, i + 1] = myDGV.Rows[r].Cells[i].Value;
}
System.Windows.Forms.Application.DoEvents();
}
worksheet.Columns.EntireColumn.AutoFit();//列宽自适应
if (saveFileName != "")
{
try
{
workbook.Saved = true;
workbook.SaveCopyAs(saveFileName);
}
catch (Exception ex)
{
MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);
}
}
xlApp.Quit();
GC.Collect();//强行销毁
MessageBox.Show("文件： " + fileName + ".xls 保存成功", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}