客户标签维护.cs 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397
  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. if (LabelDataGridView.Columns[e.ColumnIndex].HeaderText == "编辑")
  110. {
  111. if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
  112. {
  113. CL_ID2 = LabelDataGridView.Rows[e.RowIndex].Cells["cl_id"].Value.ToString();
  114. LabelPath = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelurl"].Value.ToString();
  115. string LabelName = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelname"].Value.ToString();
  116. System.DateTime time;
  117. try
  118. {
  119. time = Convert.ToDateTime(LabelDataGridView.Rows[e.RowIndex].Cells["cl_date"].Value.ToString());
  120. }
  121. catch (Exception)
  122. {
  123. time = System.DateTime.Now;
  124. }
  125. BaseUtil.GetLabelUrl(LabelPath, LabelName, time);
  126. System.Diagnostics.Process.Start(ftpOperater.DownLoadTo + LabelName);
  127. 客户编号.Text = LabelDataGridView.Rows[e.RowIndex].Cells["CL_CUSTCODE2"].Value.ToString();
  128. la_type1.Text = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labeltype"].Value.ToString();
  129. la_code.Text = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelcode"].Value.ToString();
  130. la_name.Text = LabelDataGridView.Rows[e.RowIndex].Cells["cl_labelname"].Value.ToString();
  131. FolderPath.Text = ftpOperater.DownLoadTo;
  132. }
  133. }
  134. //asc.controllInitializeSize(this);
  135. }
  136. private void Screen_Click(object sender, EventArgs e)
  137. {
  138. sql.Clear();
  139. condition.Clear();
  140. //如果条件全部为空的时候
  141. if (cu_code.Text == "" && cu_name.Text == "" && la_type.Text == "")
  142. {
  143. LoadData();
  144. }
  145. else
  146. {
  147. 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 ");
  148. //设置筛选的条件
  149. condition.Append(BaseUtil.GetScreenSqlCondition(cu_code, la_type));
  150. //最终刷选条件拼接成的sql
  151. LoadData();
  152. }
  153. }
  154. private void Update_Click(object sender, EventArgs e)
  155. {
  156. string LabelSoft = "";
  157. //需要处理新增的行和原有数据然后更新的行
  158. if (FastReport.Checked)
  159. {
  160. LabelSoft = "FastReport";
  161. }
  162. DataTable dt = (DataTable)LabelDataGridView.DataSource;
  163. //如果有改变的行才传递到后台
  164. if (dt.GetChanges() != null)
  165. {
  166. //如果是新增的默认加上Radio当前选中的打印软件
  167. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  168. {
  169. if (LabelDataGridView.Rows[i].Cells["cl_labelsoft"].Value.ToString() == "")
  170. {
  171. LabelDataGridView.Rows[i].Cells["cl_labelsoft"].Value = LabelSoft;
  172. }
  173. }
  174. 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)";
  175. dh.UpDateTableByCondition(dt.GetChanges(), "customerlabel", "cl_id", sql.ToLower());
  176. LoadData();
  177. }
  178. }
  179. private void DeleteDetail_Click(object sender, EventArgs e)
  180. {
  181. string[] deleteid = new string[LabelDataGridView.RowCount];
  182. for (int i = 0; i < LabelDataGridView.RowCount; i++)
  183. {
  184. deleteid[i] = LabelDataGridView.Rows[i].Cells["cl_id"].Value.ToString();
  185. }
  186. dh.DeleteDataByID("customerlabel", "cl_id", deleteid);
  187. LoadData();
  188. }
  189. private void OpenFolder_Click(object sender, EventArgs e)
  190. {
  191. //根据勾选的不同设置不同的文件后缀过滤
  192. if (FastReport.Checked)
  193. {
  194. openFileDialog1.Filter = "(*.frx)|*.frx";
  195. }
  196. DialogResult result = openFileDialog1.ShowDialog();
  197. if (result == DialogResult.OK)
  198. {
  199. FolderPath.Text = openFileDialog1.FileName;
  200. la_name.Text = FolderPath.Text.Substring(FolderPath.Text.LastIndexOf("\\") + 1);
  201. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  202. {
  203. if (LabelDataGridView.Rows[i].Cells["Choose"].Value != null)
  204. {
  205. if ((bool)LabelDataGridView.Rows[i].Cells["Choose"].Value == true)
  206. {
  207. LabelDataGridView.Rows[i].Cells["cl_labelurl"].Value = FolderPath.Text;
  208. }
  209. }
  210. }
  211. }
  212. }
  213. private void LabelDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
  214. {
  215. if (LabelDataGridView.Columns[e.ColumnIndex].Name == "cl_isdefault")
  216. {
  217. if (e.Value != null)
  218. {
  219. switch (e.Value.ToString())
  220. {
  221. case "0":
  222. e.Value = "否";
  223. break;
  224. case "1":
  225. e.Value = "是";
  226. break;
  227. default:
  228. break;
  229. }
  230. }
  231. }
  232. }
  233. private void LabelDataGridView_DataError(object sender, DataGridViewDataErrorEventArgs e)
  234. {
  235. //覆盖参数错误的事件,使得不会报错
  236. }
  237. private void LoadData()
  238. {
  239. //如果条件和上次一样则不进行数据读取
  240. //if (LastCondition != condition.ToString())
  241. {
  242. //如果没有任何筛选条件直接选取customerlabel的数据
  243. if (sql.Length == 0)
  244. {
  245. 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");
  246. }
  247. else
  248. {
  249. dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  250. }
  251. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt);
  252. string Field = BaseUtil.GetGridViewSelectContent(LabelDataGridView);
  253. 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);
  254. LastCondition = condition.ToString();
  255. }
  256. }
  257. private void PrintTest_Click(object sender, EventArgs e)
  258. {
  259. if (LabelCode != "")
  260. {
  261. }
  262. }
  263. private void 产品标签维护_FormClosing(object sender, FormClosingEventArgs e)
  264. {
  265. try
  266. {
  267. }
  268. catch (Exception)
  269. {
  270. }
  271. }
  272. private void Save_Click(object sender, EventArgs e)
  273. {
  274. if (la_type1.Text != "" && FolderPath.Text != "" && la_code.Text != "")
  275. {
  276. //文件名
  277. string fileName;
  278. //源路径
  279. string sourcePath;
  280. //未选择文件的之后默认是这个,从Text输入框中取
  281. if (openFileDialog1.FileName == "openFileDialog1")
  282. {
  283. fileName = la_name.Text;
  284. sourcePath = FolderPath.Text;
  285. }
  286. else
  287. {
  288. sourcePath = openFileDialog1.FileName.Substring(0, openFileDialog1.FileName.LastIndexOf(@"\"));
  289. fileName = openFileDialog1.FileName.Substring(openFileDialog1.FileName.LastIndexOf(@"\") + 1);
  290. }
  291. if (FTPShare.Checked)
  292. {
  293. ftpOperater ftp = new ftpOperater();
  294. ftp.UpLoadFile(sourcePath, fileName);
  295. string SoftWare = "FastReport";
  296. if (CL_ID2 != null)
  297. {
  298. sql.Clear();
  299. sql.Append("update customerlabel set cl_labelcode='" + la_code.Text + "',cl_custcode='" + 客户编号.Text + "',");
  300. sql.Append("cl_labeltype='" + la_type1.Text + "',cl_labelname='" + la_name.Text + "',cl_date=sysdate where cl_id=" + CL_ID2);
  301. }
  302. else
  303. {
  304. sql.Clear();
  305. 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, ");
  306. sql.Append("'" + la_code.Text + "','" + (客户编号.Text == "" ? "" : 客户编号.Text) + "','" + la_type1.Text + "','" + ftpOperater.FTPAddress + "','" + la_name.Text + "','" + SoftWare + "',sysdate)");
  307. }
  308. dh.ExecuteSql(sql.ToString(), "insert");
  309. sql.Clear();
  310. }
  311. else
  312. {
  313. //目标路径
  314. string targetPath = NetURL.Text;
  315. //var file = Directory.GetFiles(targetPath);
  316. string sourceFile = Path.Combine(sourcePath, fileName);
  317. string destFile = Path.Combine(targetPath, fileName);
  318. //获取指定路径下的全部文件名
  319. var file = Directory.GetFiles(targetPath);
  320. string overwrite = "";
  321. for (int i = 0; i < file.Length; i++)
  322. {
  323. if (file[i].Substring(file[i].LastIndexOf(@"\") + 1) == fileName)
  324. {
  325. overwrite = MessageBox.Show(this.ParentForm, "已存在名为" + fileName + "的文件,是否覆盖", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  326. break;
  327. }
  328. }
  329. if (overwrite == "Yes" || overwrite == "")
  330. {
  331. //不存在文件家的话进行创建
  332. if (!Directory.Exists(targetPath))
  333. Directory.CreateDirectory(targetPath);
  334. //将文件复制到指定位置
  335. File.Copy(sourceFile, destFile, true);
  336. string SoftWare = "FastReport";
  337. sql.Clear();
  338. 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, ");
  339. sql.Append("'" + la_code.Text + "','" + (客户编号.Text == "" ? "共用" : 客户编号.Text) + "','" + la_type1.Text + "','" + destFile + "','" + la_name.Text + "','" + SoftWare + "',sysdate)");
  340. dh.ExecuteSql(sql.ToString(), "insert");
  341. sql.Clear();
  342. }
  343. }
  344. MessageBox.Show("保存成功!");
  345. LoadData();
  346. }
  347. else
  348. {
  349. MessageBox.Show("请填写完整参数!");
  350. }
  351. }
  352. private void 产品标签维护_SizeChanged(object sender, EventArgs e)
  353. {
  354. asc.controlAutoSize(this);
  355. }
  356. private void NetURL_TextChanged(object sender, EventArgs e)
  357. {
  358. Settings.Default.ShareUrl = NetURL.Text;
  359. Settings.Default.Save();
  360. }
  361. private void NewLabel_Click(object sender, EventArgs e)
  362. {
  363. 客户编号.Text = "";
  364. la_type1.Text = "";
  365. la_code.Text = "";
  366. la_name.Text = "";
  367. FolderPath.Text = "";
  368. CL_ID2 = null;
  369. }
  370. }
  371. }