1 using Aspose.Cells;
2 using MSSQLDAL.Globals;
3 using System;
4 using System.Collections.Generic;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace MSSQLDAL.Helpers
12 {
13 public static class GridHelps
14 {
15 /// <summary>
16 /// 入库类别：质检入库
17 /// </summary>
18 public static ComboBox GetRuKuLeiBie(ComboBox comboBox)
19 {
20 DataTable dt = new DataTable();
21 dt.Columns.Add(new DataColumn("S", typeof(string)));
22 dt.Columns.Add(new DataColumn("V", typeof(string)));
23 DataRow row1 = dt.NewRow(); row1["S"] = "调拨入库"; row1["V"] = "0"; dt.Rows.Add(row1);
24 DataRow row2 = dt.NewRow(); row2["S"] = "质检入库"; row2["V"] = "1"; dt.Rows.Add(row2);
25 comboBox.DisplayMember = "S";
26 comboBox.ValueMember = "V";
27 comboBox.DataSource = dt;
28 return comboBox;
29 }
30 /// <summary>
31 /// 出库类别：质检入库
32 /// </summary>
33 public static ComboBox GetChuKuLeiBie(ComboBox comboBox)
34 {
35 DataTable dt = new DataTable();
36 dt.Columns.Add(new DataColumn("S", typeof(string)));
37 dt.Columns.Add(new DataColumn("V", typeof(string)));
38 DataRow row1 = dt.NewRow(); row1["S"] = "质检出库"; row1["V"] = "0"; dt.Rows.Add(row1);
39 DataRow row2 = dt.NewRow(); row2["S"] = "报废出库"; row2["V"] = "1"; dt.Rows.Add(row2);
40 comboBox.DisplayMember = "S";
41 comboBox.ValueMember = "V";
42 comboBox.DataSource = dt;
43 return comboBox;
44 }
45 /// <summary>
46 /// 发车状态
47 /// </summary>
48 public static ComboBox GetFaCheZhuangTai(ComboBox comboBox, string QuanBu)
49 {
50 DataTable dt = new DataTable();
51 dt.Columns.Add(new DataColumn("DisplayMember", typeof(string)));
52 dt.Columns.Add(new DataColumn("ValueMember", typeof(string)));
53 if (QuanBu == "全部")
54 {
55 DataRow dr0 = dt.NewRow(); dr0[0] = "全部"; dr0[1] = "State0"; dt.Rows.Add(dr0);
56 }
57 DataRow dr1 = dt.NewRow(); dr1[0] = "待定"; dr1[1] = "State1"; dt.Rows.Add(dr1);
58 DataRow dr2 = dt.NewRow(); dr2[0] = "排队中"; dr2[1] = "State2"; dt.Rows.Add(dr2);
59 DataRow dr3 = dt.NewRow(); dr3[0] = "正在装车"; dr3[1] = "State3"; dt.Rows.Add(dr3);
60 DataRow dr4 = dt.NewRow(); dr4[0] = "已发车"; dr4[1] = "State4"; dt.Rows.Add(dr4);
61 comboBox.DisplayMember = "DisplayMember";
62 comboBox.ValueMember = "ValueMember";
63 comboBox.DataSource = dt;
64 return comboBox;
65 }
66 /// <summary>
67 /// 销售大区
68 /// </summary>
69 public static ComboBox GetXiaoShouDaQu(ComboBox comboBox)
70 {
71 DataTable dt = SuperDLL.XieHuoQuYu_ORM.GetDaQu("全部");
72 DataRow dr = dt.NewRow();
73 dr["DaQu"] = "全部";
74 dt.Rows.InsertAt(dr, 0);
75 comboBox.DisplayMember = "DaQu";
76 comboBox.ValueMember = "DaQu";
77 comboBox.DataSource = dt;
78 return comboBox;
79 }
80 #region 库存盘点
81 /// <summary>
82 /// 盘点状态
83 /// </summary>
84 public static ComboBox GetPanDianZhuangTai(ComboBox comboBox, string i)
85 {
86 DataTable Table = new DataTable();
87 Table.Columns.Add(new DataColumn("S", typeof(string)));
88 Table.Columns.Add(new DataColumn("V", typeof(string)));
89 if (i == "全部")
90 {
91 DataRow row1 = Table.NewRow(); row1["S"] = "全部"; row1["V"] = "0"; Table.Rows.Add(row1);
92 }
93 DataRow row2 = Table.NewRow(); row2["S"] = "计划"; row2["V"] = "1"; Table.Rows.Add(row2);
94 DataRow row3 = Table.NewRow(); row3["S"] = "执行"; row3["V"] = "2"; Table.Rows.Add(row3);
95 DataRow row4 = Table.NewRow(); row4["S"] = "完成"; row4["V"] = "3"; Table.Rows.Add(row4);
96 comboBox.DisplayMember = "S";
97 comboBox.ValueMember = "V";
98 comboBox.DataSource = Table;
99 return comboBox;
100 }
101 #endregion
102 #region 入库单管理
103 /// <summary>
104 /// 获取(类型)下拉列表
105 /// </summary>
106 public static ComboBox GetLeiXing(ComboBox comboBox)
107 {
108 DataTable dt = new DataTable();
109 dt.Columns.Add(new DataColumn("S", typeof(string)));
110 dt.Columns.Add(new DataColumn("V", typeof(string)));
111 DataRow dr0 = dt.NewRow(); dr0[0] = " P（普板）"; dr0[1] = "P"; dt.Rows.Add(dr0);
112 DataRow dr1 = dt.NewRow(); dr1[0] = " Y（圆片）"; dr1[1] = "Y"; dt.Rows.Add(dr1);
113 DataRow dr2 = dt.NewRow(); dr2[0] = " M（幕墙板）"; dr2[1] = "M"; dt.Rows.Add(dr2);
114 DataRow dr3 = dt.NewRow(); dr3[0] = " H（花纹）"; dr3[1] = "H"; dt.Rows.Add(dr3);
115 DataRow dr4 = dt.NewRow(); dr4[0] = " B（备料）"; dr4[1] = "B"; dt.Rows.Add(dr4);
116 DataRow dr5 = dt.NewRow(); dr5[0] = " C（彩涂）"; dr5[1] = "C"; dt.Rows.Add(dr5);
117 comboBox.DisplayMember = "S";
118 comboBox.ValueMember = "V";
119 comboBox.DataSource = dt;
120 return comboBox;
121 }
122 /// <summary>
123 /// 获取(品名)下拉列表
124 /// </summary>
125 public static ComboBox GetPinMing(ComboBox comboBox)
126 {
127 DataTable Table = new DataTable();
128 Table.Columns.Add(new DataColumn("S", typeof(string)));
129 Table.Columns.Add(new DataColumn("V", typeof(string)));
130 DataRow r1 = Table.NewRow(); r1[0] = "热轧"; r1[1] = "0"; Table.Rows.Add(r1);
131 DataRow r2 = Table.NewRow(); r2[0] = "铸轧"; r2[1] = "1"; Table.Rows.Add(r2);
132 comboBox.DisplayMember = "S";
133 comboBox.ValueMember = "V";
134 comboBox.DataSource = Table;
135 return comboBox;
136 }
137 /// <summary>
138 /// 获取(计量单位)下拉列表
139 /// </summary>
140 public static ComboBox GetComboBoxJiLiangDanWei(ComboBox comboBox)
141 {
142 DataTable Table = new DataTable();
143 Table.Columns.Add(new DataColumn("S", typeof(string)));
144 Table.Columns.Add(new DataColumn("V", typeof(string)));
145 DataRow r1 = Table.NewRow(); r1[0] = "吨"; r1[1] = "0"; Table.Rows.Add(r1);
146 DataRow r2 = Table.NewRow(); r2[0] = "片"; r2[1] = "1"; Table.Rows.Add(r2);
147 DataRow r3 = Table.NewRow(); r3[0] = "件"; r3[1] = "2"; Table.Rows.Add(r3);
148 DataRow r4 = Table.NewRow(); r4[0] = "面积"; r4[1] = "3"; Table.Rows.Add(r4);
149 comboBox.DisplayMember = "S";
150 comboBox.ValueMember = "V";
151 comboBox.DataSource = Table;
152 return comboBox;
153 }
154 /// <summary>
155 /// 获取(入库状态)下拉列表
156 /// </summary>
157 public static ComboBox GetComboBoxRuKuZhuangTai(ComboBox comboBox, string i)
158 {
159 DataTable Table = new DataTable();
160 Table.Columns.Add(new DataColumn("S", typeof(string)));
161 Table.Columns.Add(new DataColumn("V", typeof(string)));
162 if (i == "全部")
163 {
164 DataRow row1 = Table.NewRow(); row1["S"] = "全部"; row1["V"] = "0"; Table.Rows.Add(row1);
165 }
166 DataRow row2 = Table.NewRow(); row2["S"] = "未入库"; row2["V"] = "1"; Table.Rows.Add(row2);
167 DataRow row3 = Table.NewRow(); row3["S"] = "已入库"; row3["V"] = "2"; Table.Rows.Add(row3);
168 comboBox.DisplayMember = "S";
169 comboBox.ValueMember = "V";
170 comboBox.DataSource = Table;
171 return comboBox;
172 }
173 /// <summary>
174 /// 获取(出库状态)下拉列表
175 /// </summary>
176 public static ComboBox GetComboBoxChuKuZhuangTai(ComboBox comboBox, string i)
177 {
178 DataTable Table = new DataTable();
179 Table.Columns.Add(new DataColumn("S", typeof(string)));
180 Table.Columns.Add(new DataColumn("V", typeof(string)));
181 if (i == "全部")
182 {
183 DataRow row1 = Table.NewRow(); row1["S"] = "全部"; row1["V"] = "0"; Table.Rows.Add(row1);
184 }
185 DataRow row2 = Table.NewRow(); row2["S"] = "未出库"; row2["V"] = "1"; Table.Rows.Add(row2);
186 DataRow row3 = Table.NewRow(); row3["S"] = "已出库"; row3["V"] = "2"; Table.Rows.Add(row3);
187 comboBox.DisplayMember = "S";
188 comboBox.ValueMember = "V";
189 comboBox.DataSource = Table;
190 return comboBox;
191 }
192 /// <summary>
193 /// 获取(跨号)下拉列表
194 /// </summary>
195 public static ComboBox GetComboBoxKuaHao(ComboBox comboBox)
196 {
197 DataTable Table = SuperDLL.XieHuoQuYu_ORM.GetKuaHao();
198 DataRow row = Table.NewRow();
199 row["KuaHao"] = "全部";
200 Table.Rows.InsertAt(row, 0);
201 comboBox.DisplayMember = "KuaHao";
202 comboBox.ValueMember = "KuaHao";
203 comboBox.DataSource = Table;
204 return comboBox;
205 }
206 /// <summary>
207 /// 获取(货位区号)下拉列表
208 /// </summary>
209 public static ComboBox GetComboBoxHuoWeiQuHao(ComboBox comboBox, string KuaHao)
210 {
211 DataTable Table = SuperDLL.XieHuoQuYu_ORM.GetQuHao(KuaHao);
212 DataRow row = Table.NewRow();
213 row["QuHao"] = "全部";
214 Table.Rows.InsertAt(row, 0);
215 comboBox.DisplayMember = "QuHao";
216 comboBox.ValueMember = "QuHao";
217 comboBox.DataSource = Table;
218 return comboBox;
219 }
220 #endregion
221
222 #region 出库单管理
223 /// <summary>
224 /// 获取(取货方式)下拉列表
225 /// </summary>
226 public static ComboBox GetComboBoxQuHuoFangShi(ComboBox comboBox, string i)
227 {
228 DataTable Table = new DataTable();
229 Table.Columns.Add(new DataColumn("S", typeof(string)));
230 Table.Columns.Add(new DataColumn("V", typeof(string)));
231 if (i == "全部")
232 {
233 DataRow row1 = Table.NewRow(); row1["S"] = "全部"; row1["V"] = "0"; Table.Rows.Add(row1);
234 }
235 DataRow row2 = Table.NewRow(); row2["S"] = "货运"; row2["V"] = "1"; Table.Rows.Add(row2);
236 DataRow row3 = Table.NewRow(); row3["S"] = "自提"; row3["V"] = "2"; Table.Rows.Add(row3);
237 comboBox.DisplayMember = "S";
238 comboBox.ValueMember = "V";
239 comboBox.DataSource = Table;
240 return comboBox;
241 }
242 /// <summary>
243 /// 是否下拉列表
244 /// </summary>
245 public static ComboBox GetComboBoxShiFou(ComboBox comboBox)
246 {
247 DataTable Table = new DataTable();
248 Table.Columns.Add(new DataColumn("S", typeof(string)));
249 Table.Columns.Add(new DataColumn("V", typeof(string)));
250 DataRow row2 = Table.NewRow(); row2["S"] = "是"; row2["V"] = "1"; Table.Rows.Add(row2);
251 DataRow row3 = Table.NewRow(); row3["S"] = "否"; row3["V"] = "0"; Table.Rows.Add(row3);
252 comboBox.DisplayMember = "S";
253 comboBox.ValueMember = "V";
254 comboBox.DataSource = Table;
255 return comboBox;
256 }
257 #endregion
258 /// <summary>
259 /// 数据网格默认设置
260 /// </summary>
261 /// <param name="dgv"></param>
262 public static void SetDataGridView(DataGridView dgv)
263 {
264 dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect;//选中整行
265 if (dgv.Rows.Count != 0)
266 {
267 dgv.Rows[0].Selected = false;//默认不选中
268 for (int i = 0; i < dgv.ColumnCount; i++)
269 {
270 dgv.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;//列宽自适应
271 }
272 }
273 }
274 /// <summary>
275 /// 默认搜索时间设置
276 /// </summary>
277 public static void SetDateTimePicker(DateTimePicker S, DateTimePicker E)
278 {
279 S.Text = DateTime.Now.AddDays(1 - DateTime.Now.Day).ToString("yyyy-MM-dd 00:00:00");
280 E.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
281 }
282 /// <summary>
283 /// 数据网格隐藏列
284 /// </summary>
285 public static void DataGridViewHideColumns(DataGridView dgv, int lie)
286 {
287 if (dgv.ColumnCount != 0)
288 {
289 dgv.Columns[lie].Visible = false;
290 }
291 }
292 /// <summary>
293 /// 编制报表Aspose.Cells组件
294 /// </summary>
295 /// <param name="dataSet"></param>
296 public static void SetAsposeCells(DataSet dataSet, DateTime S, DateTime E, string templateFileName)
297 {
298 //数据整合
299 DataSet ExcelData = dataSet.Copy();//复制表数据
300 DataTable Table = new DataTable();//创建Table表
301 Table.Columns.Add(new DataColumn("StartData", typeof(string)));//添加列
302 Table.Columns.Add(new DataColumn("EtartData", typeof(string)));//添加列
303 DataRow row = Table.NewRow();//创建Table表新行
304 row["StartData"] = S;//开始时间
305 row["EtartData"] = E;//结束时间
306 Table.Rows.Add(row);//表新行添加数据
307 ExcelData.Tables.Add(Table);//添加新表
308 //保存对话框
309 SaveFileDialog sfd = new SaveFileDialog();//创建保存对话框
310 sfd.Title = "请选择";//标题
311 sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
312 sfd.Filter = "Excel 文件(*.xlt)|*.xlt|Excel 文件(*.xls)|*.xls|Excel 文件(*.xlsx)|*.xlsx|所有文件(*.*)|*.*";//选择文件类型
313 sfd.ShowDialog();//显示对话框
314 string saveFilename = sfd.FileName;//获取保存文件名
315 if (saveFilename == "") { return; }//如果没有文件名则退出
316 //string templateFileName = @"\Template\入库单管理\入库单管理表.xlsx";//获取Debug文件夹模板路径名
317 if (ExcelData.Tables.Count > 0)//如果数据不为空
318 {
319 try
320 {
321 Workbook Template = new Workbook(Application.StartupPath.ToLower() + templateFileName);//全路径
322 WorkbookDesigner Designer = new WorkbookDesigner(Template);//创建导出类(填入模板)
323 Designer.SetDataSource(ExcelData);//填入数据
324 Designer.Process(); Designer.Workbook.Save(saveFilename);//导出保存数据(文件名)
325 MessageBox.Show("导出成功！");
326 System.Diagnostics.Process.Start(saveFilename);
327 }
328 catch (Exception)
329 {
330 MessageBox.Show("导出失败！");
331 }
332 }
333 }
334 }
335 }
浙公网安备 33010602011771号