客户标签维护.cs 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407
  1. using LabelManager2;
  2. using System;
  3. using System.Data;
  4. using System.Drawing;
  5. using System.Text;
  6. using System.IO;
  7. using System.Windows.Forms;
  8. using UAS_LabelMachine.CustomControl;
  9. using UAS_LabelMachine.Properties;
  10. using UAS_LabelMachine.PublicMethod;
  11. using UAS_LabelMachine.Entity;
  12. namespace UAS_LabelMachine
  13. {
  14. public partial class 客户标签维护 : Form
  15. {
  16. DataHelper dh;
  17. DataTable dt;
  18. //设置Grid中Combox的静态数据,这个格式是必须的,#前面是展示值,#后面是实际值
  19. string[] labeltype = { "单盘#单盘", "中盒#中盒", "外箱#外箱", "全部#" };
  20. //记录上次筛选时的条件,如果本次和上次相同则不进行查询
  21. string LastCondition = "";
  22. //用于拼接条件查询
  23. StringBuilder condition = new StringBuilder();
  24. StringBuilder sql = new StringBuilder();
  25. /*BarTender新建打印机引擎*/
  26. //private Engine engine = null;
  27. //private LabelFormatDocument format ;
  28. //点击行的LabelCode
  29. string LabelCode = "";
  30. //模板的路径
  31. string LabelPath = "";
  32. //模板编号的ID
  33. string CL_ID1;
  34. string CL_ID2;
  35. //Label表的主键,用于弹窗的传参
  36. string La_id1;
  37. //添加在grid末列的操作列
  38. DataGridViewImageColumn PreviewColumn = new DataGridViewImageColumn
  39. {
  40. Image = Resources.preview_16px_25980_easyicon_net,
  41. Width = 40,
  42. Name = "预览",
  43. ToolTipText = "预览模板参数",
  44. Tag = "Read",
  45. AutoSizeMode = DataGridViewAutoSizeColumnMode.None
  46. };
  47. DataGridViewImageColumn OperateColumn = new DataGridViewImageColumn
  48. {
  49. Image = Resources.write_15_893687707641px_1181413_easyicon_net,
  50. Width = 40,
  51. Name = "编辑",
  52. ToolTipText = "编辑模板",
  53. Tag = "Read",
  54. AutoSizeMode = DataGridViewAutoSizeColumnMode.None
  55. };
  56. AutoSizeFormClass asc = new AutoSizeFormClass();
  57. public 客户标签维护()
  58. {
  59. InitializeComponent();
  60. cu_code.FormName = Name;
  61. cu_code.SetValueField = new string[] { "cu_code", "cu_name" };
  62. cu_code.TableName = "(select distinct cu_code,cu_name from customer left join customerlabel on cu_code=cl_custcode)";
  63. cu_code.SelectField = "cu_code # 客户编号,cu_name # 客户名称";
  64. 客户编号.FormName = Name;
  65. 客户编号.SetValueField = new string[] { "客户编号" };
  66. 客户编号.TableName = "(select distinct cu_code,cu_name from customer left join customerlabel on cu_code=cl_custcode)";
  67. 客户编号.SelectField = "cu_code # 客户编号,cu_name # 客户名称";
  68. la_code.FormName = Name;
  69. la_code.SetValueField = new string[] { "la_code" };
  70. la_code.TableName = "(select * from label order by la_id)";
  71. la_code.SelectField = "la_code # 模板编号,la_name # 模板名称";
  72. //NetURL.Text = Settings.Default.ShareUrl;
  73. }
  74. private void 条码维护_Load(object sender, EventArgs e)
  75. {
  76. if (Settings.Default.FTPAddress == "")
  77. {
  78. FTPShare.Visible = false;
  79. }
  80. dh = SystemInf.dh;
  81. condition.Append("");
  82. ChooseAll.ChooseAll(LabelDataGridView);
  83. BaseUtil.SetComboxData(la_type, "display", "value", labeltype);
  84. //加载下拉框的静态值
  85. LoadData();
  86. Width = Width + 1;
  87. asc.controllInitializeSize(this);
  88. Width = Width + 1;
  89. }
  90. private void LabelDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
  91. {
  92. if (LabelDataGridView.Columns[e.ColumnIndex].HeaderText == "预览")
  93. {
  94. //获取路径和标签名称
  95. LabelPath = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelurl"].Value.ToString();
  96. LabelCode = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelcode"].Value.ToString();
  97. CL_ID1 = LabelDataGridView.Rows[e.RowIndex].Cells["cl_id"].Value.ToString();
  98. La_id1 = LabelDataGridView.Rows[e.RowIndex].Cells["la_id"].Value.ToString();
  99. System.DateTime time;
  100. try
  101. {
  102. time = Convert.ToDateTime(LabelDataGridView.Rows[e.RowIndex].Cells["cl_date"].Value.ToString());
  103. }
  104. catch (Exception)
  105. {
  106. time = System.DateTime.Now;
  107. }
  108. }
  109. //asc.controllInitializeSize(this);
  110. }
  111. private void Screen_Click(object sender, EventArgs e)
  112. {
  113. sql.Clear();
  114. condition.Clear();
  115. //如果条件全部为空的时候
  116. if (cu_code.Text == "" && cu_name.Text == "" && la_type.Text == "")
  117. {
  118. LoadData();
  119. }
  120. else
  121. {
  122. sql.Append("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cu_name,cl_labelurl,cl_labeltype,cl_isdefault,cl_custcode,cl_labelname,cl_id,cl_labelcode,cl_detno,cl_labelsoft,la_id from customerlabel left join customer on cl_custcode=cu_code left join label on la_code=cl_custcode order by cl_custcode ");
  123. //设置筛选的条件
  124. condition.Append(BaseUtil.GetScreenSqlCondition(cu_code, la_type));
  125. //最终刷选条件拼接成的sql
  126. LoadData();
  127. }
  128. }
  129. private void Update_Click(object sender, EventArgs e)
  130. {
  131. string LabelSoft = "";
  132. //需要处理新增的行和原有数据然后更新的行
  133. if (FastReport.Checked)
  134. {
  135. LabelSoft = "FastReport";
  136. }
  137. DataTable dt = (DataTable)LabelDataGridView.DataSource;
  138. //如果有改变的行才传递到后台
  139. if (dt.GetChanges() != null)
  140. {
  141. //如果是新增的默认加上Radio当前选中的打印软件
  142. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  143. {
  144. if (LabelDataGridView.Rows[i].Cells["cl_labelsoft"].Value.ToString() == "")
  145. {
  146. LabelDataGridView.Rows[i].Cells["cl_labelsoft"].Value = LabelSoft;
  147. }
  148. }
  149. string sql = "Insert into customerlabel (cl_ID,cl_custCODE,cl_LABELTYPE,cl_LABELCODE,cl_LABELURL,cl_DETNO,cl_LABELSOFT,cl_ISDEFAULT, cl_date) values(customerlabel_seq.nextval,'" + cu_code.Text + "',:cl_LABELTYPE,:cl_LABELCODE,:cl_LABELURL,:cl_DETNO,:cl_LABELSOFT,:cl_ISDEFAULT,sysdate)";
  150. dh.UpDateTableByCondition(dt.GetChanges(), "customerlabel", "cl_id", sql.ToLower());
  151. LoadData();
  152. }
  153. }
  154. private void DeleteDetail_Click(object sender, EventArgs e)
  155. {
  156. string[] deleteid = new string[LabelDataGridView.RowCount];
  157. for (int i = 0; i < LabelDataGridView.RowCount; i++)
  158. {
  159. deleteid[i] = LabelDataGridView.Rows[i].Cells["cl_id"].Value.ToString();
  160. }
  161. dh.DeleteDataByID("customerlabel", "cl_id", deleteid);
  162. LoadData();
  163. }
  164. private void OpenFolder_Click(object sender, EventArgs e)
  165. {
  166. //根据勾选的不同设置不同的文件后缀过滤
  167. if (FastReport.Checked)
  168. {
  169. openFileDialog1.Filter = "(*.frx)|*.frx";
  170. }
  171. DialogResult result = openFileDialog1.ShowDialog();
  172. if (result == DialogResult.OK)
  173. {
  174. FolderPath.Text = openFileDialog1.FileName;
  175. la_name.Text = FolderPath.Text.Substring(FolderPath.Text.LastIndexOf("\\") + 1);
  176. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  177. {
  178. if (LabelDataGridView.Rows[i].Cells["Choose"].Value != null)
  179. {
  180. if ((bool)LabelDataGridView.Rows[i].Cells["Choose"].Value == true)
  181. {
  182. LabelDataGridView.Rows[i].Cells["cl_labelurl"].Value = FolderPath.Text;
  183. }
  184. }
  185. }
  186. }
  187. }
  188. private void LabelDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
  189. {
  190. if (LabelDataGridView.Columns[e.ColumnIndex].Name == "cl_isdefault")
  191. {
  192. if (e.Value != null)
  193. {
  194. switch (e.Value.ToString())
  195. {
  196. case "0":
  197. e.Value = "否";
  198. break;
  199. case "1":
  200. e.Value = "是";
  201. break;
  202. default:
  203. break;
  204. }
  205. }
  206. }
  207. }
  208. private void LabelDataGridView_DataError(object sender, DataGridViewDataErrorEventArgs e)
  209. {
  210. //覆盖参数错误的事件,使得不会报错
  211. }
  212. private void LoadData()
  213. {
  214. //如果条件和上次一样则不进行数据读取
  215. //if (LastCondition != condition.ToString())
  216. {
  217. //如果没有任何筛选条件直接选取customerlabel的数据
  218. if (sql.Length == 0)
  219. {
  220. dt = (DataTable)dh.ExecuteSql("select to_char(nvl(cl_date,sysdate),'YYYY-MM-DD HH24:Mi:SS') cl_date,cu_name,cl_labelurl,cl_labeltype,cl_isdefault,cl_labelname,cl_custcode,cl_id,cl_labelcode,cl_detno,cl_labelsoft,la_id from customerlabel left join customer on cl_custcode=cu_code left join label on la_code=CL_LABELCODE order by cl_custcode", "select");
  221. }
  222. else
  223. {
  224. dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  225. }
  226. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt);
  227. string Field = BaseUtil.GetGridViewSelectContent(LabelDataGridView);
  228. pagination1.BindDataToNavigator(LabelDataGridView, "CustomerLabel left join customer on cl_custcode=cu_code left join label on la_code=CL_LABELCODE", Field, "cl_id", "", condition.Replace("where", "").ToString(), PreviewColumn, OperateColumn);
  229. LastCondition = condition.ToString();
  230. }
  231. }
  232. private void PrintTest_Click(object sender, EventArgs e)
  233. {
  234. if (LabelCode != "")
  235. {
  236. }
  237. }
  238. private void 产品标签维护_FormClosing(object sender, FormClosingEventArgs e)
  239. {
  240. try
  241. {
  242. }
  243. catch (Exception)
  244. {
  245. }
  246. }
  247. private void Save_Click(object sender, EventArgs e)
  248. {
  249. if (la_type1.Text != "" && FolderPath.Text != "" && la_code.Text != "")
  250. {
  251. //文件名
  252. string fileName;
  253. //源路径
  254. string sourcePath;
  255. //未选择文件的之后默认是这个,从Text输入框中取
  256. if (openFileDialog1.FileName == "openFileDialog1")
  257. {
  258. fileName = la_name.Text;
  259. sourcePath = FolderPath.Text;
  260. }
  261. else
  262. {
  263. sourcePath = openFileDialog1.FileName.Substring(0, openFileDialog1.FileName.LastIndexOf(@"\"));
  264. fileName = openFileDialog1.FileName.Substring(openFileDialog1.FileName.LastIndexOf(@"\") + 1);
  265. }
  266. if (FTPShare.Checked)
  267. {
  268. ftpOperater ftp = new ftpOperater();
  269. ftp.UpLoadFile(sourcePath, fileName);
  270. string SoftWare = "FastReport";
  271. if (CL_ID2 != null)
  272. {
  273. sql.Clear();
  274. sql.Append("update customerlabel set cl_labelcode='" + la_code.Text + "',cl_custcode='" + 客户编号.Text + "',");
  275. sql.Append("cl_labeltype='" + la_type1.Text + "',cl_labelname='" + la_name.Text + "',cl_date=sysdate where cl_id=" + CL_ID2);
  276. }
  277. else
  278. {
  279. sql.Clear();
  280. sql.Append("insert into customerlabel (cl_id,cl_labelcode,cl_custcode,cl_labeltype,cl_labelurl,cl_labelname,cl_labelsoft,cl_date) values( customerlabel_seq.nextval, ");
  281. sql.Append("'" + la_code.Text + "','" + (客户编号.Text == "" ? "" : 客户编号.Text) + "','" + la_type1.Text + "','" + ftpOperater.FTPAddress + "','" + la_name.Text + "','" + SoftWare + "',sysdate)");
  282. }
  283. dh.ExecuteSql(sql.ToString(), "insert");
  284. sql.Clear();
  285. }
  286. else
  287. {
  288. //目标路径
  289. string targetPath = NetURL.Text;
  290. //var file = Directory.GetFiles(targetPath);
  291. string sourceFile = Path.Combine(sourcePath, fileName);
  292. string destFile = Path.Combine(targetPath, fileName);
  293. //获取指定路径下的全部文件名
  294. var file = Directory.GetFiles(targetPath);
  295. string overwrite = "";
  296. for (int i = 0; i < file.Length; i++)
  297. {
  298. if (file[i].Substring(file[i].LastIndexOf(@"\") + 1) == fileName)
  299. {
  300. overwrite = MessageBox.Show(this.ParentForm, "已存在名为" + fileName + "的文件,是否覆盖", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  301. break;
  302. }
  303. }
  304. if (overwrite == "Yes" || overwrite == "")
  305. {
  306. //不存在文件家的话进行创建
  307. if (!Directory.Exists(targetPath))
  308. Directory.CreateDirectory(targetPath);
  309. //将文件复制到指定位置
  310. File.Copy(sourceFile, destFile, true);
  311. string SoftWare = "FastReport";
  312. if (CL_ID2 != null)
  313. {
  314. sql.Clear();
  315. sql.Append("update customerlabel set cl_labelcode='" + la_code.Text + "',cl_custcode='" + 客户编号.Text + "',");
  316. sql.Append("cl_labeltype='" + la_type1.Text + "',cl_labelname='" + la_name.Text + "',cl_date=sysdate where cl_id=" + CL_ID2);
  317. }
  318. else
  319. {
  320. sql.Clear();
  321. sql.Append("insert into customerlabel (cl_id,cl_labelcode,cl_custcode,cl_labeltype,cl_labelurl,cl_labelname,cl_labelsoft,cl_date) values( customerlabel_seq.nextval, ");
  322. sql.Append("'" + la_code.Text + "','" + (客户编号.Text == "" ? "" : 客户编号.Text) + "','" + la_type1.Text + "','" + (NetURL.Text + la_name.Text) + "','" + la_name.Text + "','" + SoftWare + "',sysdate)");
  323. }
  324. dh.ExecuteSql(sql.ToString(), "insert");
  325. sql.Clear();
  326. }
  327. }
  328. MessageBox.Show("保存成功!");
  329. LoadData();
  330. }
  331. else
  332. {
  333. MessageBox.Show("请填写完整参数!");
  334. }
  335. }
  336. private void 产品标签维护_SizeChanged(object sender, EventArgs e)
  337. {
  338. asc.controlAutoSize(this);
  339. }
  340. private void NetURL_TextChanged(object sender, EventArgs e)
  341. {
  342. Settings.Default.ShareUrl = NetURL.Text;
  343. Settings.Default.Save();
  344. }
  345. private void NewLabel_Click(object sender, EventArgs e)
  346. {
  347. 客户编号.Text = "";
  348. la_type1.Text = "";
  349. la_code.Text = "";
  350. la_name.Text = "";
  351. FolderPath.Text = "";
  352. CL_ID2 = null;
  353. }
  354. private void LabelDataGridView_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
  355. {
  356. if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
  357. {
  358. CL_ID2 = LabelDataGridView.Rows[e.RowIndex].Cells["cl_id"].Value.ToString();
  359. LabelPath = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelurl"].Value.ToString();
  360. string LabelName = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelname"].Value.ToString();
  361. System.DateTime time;
  362. try
  363. {
  364. time = Convert.ToDateTime(LabelDataGridView.Rows[e.RowIndex].Cells["cl_date"].Value.ToString());
  365. }
  366. catch (Exception)
  367. {
  368. time = System.DateTime.Now;
  369. }
  370. File.Copy(LabelPath, ftpOperater.DownLoadTo + LabelName, true);
  371. System.Diagnostics.Process.Start(ftpOperater.DownLoadTo + LabelName);
  372. 客户编号.Text = LabelDataGridView.Rows[e.RowIndex].Cells["CL_CUSTCODE2"].Value.ToString();
  373. la_type1.Text = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labeltype"].Value.ToString();
  374. la_code.Text = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelcode"].Value.ToString();
  375. la_name.Text = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelname"].Value.ToString();
  376. FolderPath.Text = ftpOperater.DownLoadTo;
  377. }
  378. }
  379. }
  380. }