生成条码.cs 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488
  1. using NPOI.SS.Util;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Text;
  7. using System.Text.RegularExpressions;
  8. using System.Windows.Forms;
  9. using UAS_LabelMachine.Entity;
  10. using UAS_LabelMachine.PublicMethod;
  11. namespace UAS_LabelMachine
  12. {
  13. public partial class 生成条码 : Form
  14. {
  15. AutoSizeFormClass asc = new AutoSizeFormClass();
  16. DataHelper dh;
  17. DataTable dt;
  18. StringBuilder sql = new StringBuilder();
  19. string pi_id;
  20. //用于提示超出数量的物料
  21. Dictionary<string, string> NotPass = new Dictionary<string, string>();
  22. //前缀条件
  23. string Prefix = "";
  24. string Suffix = "";
  25. //生成条码的流水号
  26. int serialnum = 0;
  27. //客户的流水号
  28. int custserialnum = 0;
  29. //是否生成过条码
  30. bool FirstCode = false;
  31. //客户编号
  32. string CustCode = "";
  33. //编码规则编号
  34. string NrCode = "";
  35. public 生成条码(string PI_INOUTNO)
  36. {
  37. InitializeComponent();
  38. pi_inoutno.Text = PI_INOUTNO;
  39. }
  40. private void 生成条码_Load(object sender, EventArgs e)
  41. {
  42. dh = SystemInf.dh;
  43. ChooseAll.ChooseAll(ProdIoInfDGV);
  44. //如果传进了出入库单号则默认执行一次取数据
  45. if (pi_inoutno.Text != "")
  46. {
  47. bi_inoutno_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  48. }
  49. pr_kind.Text = "全部";
  50. asc.controllInitializeSize(this);
  51. Width = Width - 1;
  52. }
  53. private void bi_inoutno_KeyDown(object sender, KeyEventArgs e)
  54. {
  55. if (e.KeyCode == Keys.Enter)
  56. {
  57. LoadData();
  58. }
  59. }
  60. private void 生成条码_SizeChanged(object sender, EventArgs e)
  61. {
  62. asc.controlAutoSize(this);
  63. }
  64. /// <summary>
  65. /// 筛选按钮
  66. /// </summary>
  67. /// <param name="sender"></param>
  68. /// <param name="e"></param>
  69. private void Screen_Click(object sender, EventArgs e)
  70. {
  71. bi_inoutno_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  72. }
  73. /// <summary>
  74. /// 生成条码
  75. /// </summary>
  76. /// <param name="sender"></param>
  77. /// <param name="e"></param>
  78. private void GenerateBarCode_Click(object sender, EventArgs e)
  79. {
  80. //获取编码规则
  81. DataTable Nr = (DataTable)dh.ExecuteSql("select nrd_detno,nrd_name,nrd_type,nrd_radix,nrd_sql,nrd_length from NoRuleDetail left join norule on nrd_nrid=nr_id where nr_custcode='" + CustCode + "' order by nrd_detno", "select");
  82. //如果没有则取公共规则
  83. if (Nr.Rows.Count == 0)
  84. Nr = (DataTable)dh.ExecuteSql("select nrd_detno,nrd_name,nrd_radix,nrd_type,nrd_sql,nrd_length from NoRuleDetail left join norule on nrd_nrid=nr_id where nr_custcode is null and nr_isdefault <> 0 order by nrd_detno", "select");
  85. //用于过滤参数的正则表达式
  86. Regex match = new Regex("{\\w+}");
  87. //用于存放每一项的明细的数据
  88. string[] NrData = new string[Nr.Rows.Count];
  89. //流水号的索引
  90. int SerialNumIndex = 0;
  91. //流水长度
  92. int SerialNumLength = 0;
  93. //存放键值对
  94. int Radix = 10;
  95. string PrefixFixed = "";
  96. for (int m = 0; m < Nr.Rows.Count; m++)
  97. {
  98. switch (Nr.Rows[m]["nrd_type"].ToString())
  99. {
  100. //常量直接进行拼接
  101. case "常量":
  102. NrData[m] = Nr.Rows[m]["nrd_sql"].ToString();
  103. Prefix += NrData[m];
  104. Suffix += NrData[m];
  105. break;
  106. case "SQL":
  107. string SQL = Nr.Rows[m]["nrd_sql"].ToString();
  108. DataTable Temp;
  109. //如果不包含参数替换
  110. if (SQL.IndexOf("{") == 0)
  111. {
  112. Temp = (DataTable)dh.ExecuteSql(SQL, "select");
  113. }
  114. else
  115. {
  116. //替换参数后重新执行SQL
  117. foreach (Match mch in match.Matches(SQL))
  118. {
  119. SQL = SQL.Replace(mch.Value.Trim(), "'" + pi_inoutno.Text + "'");
  120. }
  121. Temp = (DataTable)dh.ExecuteSql(SQL, "select");
  122. }
  123. if (Temp.Rows.Count > 0)
  124. {
  125. NrData[m] = Temp.Rows[0][0].ToString();
  126. Prefix += NrData[m];
  127. Suffix += NrData[m];
  128. }
  129. else
  130. {
  131. NrData[m] = "";
  132. Prefix += NrData[m];
  133. Suffix += NrData[m];
  134. }
  135. break;
  136. //流水需要通过MaxNumber去取
  137. case "流水":
  138. NrData[m] = dh.getFieldDataByCondition("RuleMaxNum", "rmn_maxnumber", "rmn_nrcode='" + CustCode + "'").ToString();
  139. Suffix ="";
  140. PrefixFixed = Prefix;
  141. //设置当前流水
  142. custserialnum = int.Parse(NrData[m] == "" ? "0" : NrData[m]);
  143. SerialNumIndex = m;
  144. SerialNumLength = int.Parse(Nr.Rows[m]["nrd_length"].ToString());
  145. Radix = int.Parse(Nr.Rows[m]["nrd_radix"].ToString());
  146. break;
  147. default:
  148. break;
  149. }
  150. }
  151. //获取最大的流水号
  152. string maxnum = dh.getFieldDataByCondition("RuleMaxNum", "rmn_maxnumber", "rmn_nrcode='" + NrCode + "' and rmn_prefix='" + Prefix + "'").ToString();
  153. //如果流水号为空则插入一条新记录,从1开始取
  154. if (maxnum == "")
  155. {
  156. dh.ExecuteSql("insert into RuleMaxNum(rmn_id,rmn_nrcode,rmn_prefix,rmn_maxnumber) values(RuleMaxNum_seq.nextval,'" + NrCode + "','" + Prefix + "','1')", "insert");
  157. custserialnum = 1;
  158. }
  159. //如果流水号不为空则取当前流水
  160. else
  161. {
  162. custserialnum = int.Parse(maxnum);
  163. }
  164. //有错误需要提醒的内容
  165. int CheckedRowCount = 0;
  166. string ErrRowIndex = "";
  167. //遍历整个Grid,勾选的项目全部进行条码生成
  168. for (int i = 0; i < ProdIoInfDGV.RowCount; i++)
  169. {
  170. if (ProdIoInfDGV.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True")
  171. {
  172. CheckedRowCount++;
  173. List<string> pib_inqty = new List<string>();
  174. string pd_id = ProdIoInfDGV.Rows[i].Cells["pd_id"].FormattedValue.ToString();
  175. string pd_prodcode = ProdIoInfDGV.Rows[i].Cells["pd_prodcode"].FormattedValue.ToString();
  176. string pr_id = ProdIoInfDGV.Rows[i].Cells["pr_id"].FormattedValue.ToString();
  177. string pd_ordercode = ProdIoInfDGV.Rows[i].Cells["pd_ordercode"].FormattedValue.ToString();
  178. string pd_pdno = ProdIoInfDGV.Rows[i].Cells["pd_pdno"].FormattedValue.ToString();
  179. string pd_orderdetno = ProdIoInfDGV.Rows[i].Cells["pd_orderdetno"].FormattedValue.ToString();
  180. //总数
  181. int pd_totalqty = int.Parse(ProdIoInfDGV.Rows[i].Cells["pd_totalqty"].FormattedValue.ToString());
  182. //本次数量
  183. int pd_qty = int.Parse(ProdIoInfDGV.Rows[i].Cells["pd_qty"].FormattedValue.ToString());
  184. //最小包装数
  185. int pr_zxbzs = int.Parse(ProdIoInfDGV.Rows[i].Cells["pr_zxbzs"].FormattedValue.ToString());
  186. //中盒容量
  187. int mid_qty;
  188. try
  189. {
  190. mid_qty = int.Parse(ProdIoInfDGV.Rows[i].Cells["mid_qty"].FormattedValue.ToString());
  191. }
  192. catch (Exception)
  193. {
  194. MessageBox.Show("请检查中盒容量");
  195. return;
  196. }
  197. //如果中盘盒数量为1且有尾数则表示一箱未装满
  198. int mid_num = int.Parse(ProdIoInfDGV.Rows[i].Cells["mid_num"].FormattedValue.ToString());
  199. //中盒尾数
  200. int mid_remain = int.Parse(ProdIoInfDGV.Rows[i].Cells["mid_remain"].FormattedValue.ToString());
  201. string pib_barcode = dh.getFieldDataByCondition("prodiobarcode", "max(pib_barcode)", "PIB_INOUTNO='" + pi_inoutno.Text + "'").ToString();
  202. //中盒数量*中盒容量=需要打印的单盘标签
  203. ArrayList<string> midcode = new ArrayList<string>();
  204. ArrayList<string> barcode = new ArrayList<string>();
  205. ArrayList<string> custbarcode = new ArrayList<string>();
  206. //循环中盒号的个数,取当前出入库单最大 的中盒号+1
  207. for (int j = 0; j < mid_num; j++)
  208. {
  209. //获取中盘的编号
  210. string mid_code = dh.getFieldDataByCondition("PRODIOBARCODE", "nvl(max(to_number(PIB_OUTBOXCODE1)),0)+" + (j + 1), "PIB_INOUTNO='" + pi_inoutno.Text + "'").ToString();
  211. //如果尾数不为0,并且已经遍历到了最后一箱(未装满的箱)
  212. int count = 0;
  213. int AddNum = pr_zxbzs;
  214. if (mid_remain != 0 && j + 1 == mid_num)
  215. {
  216. //剩下的尾数刚好够整数的最小包或者加上一个未装满的最小包
  217. count = mid_remain % pr_zxbzs == 0 ? mid_remain / pr_zxbzs : (mid_remain / pr_zxbzs) + 1;
  218. }
  219. else
  220. {
  221. //循环中盒的箱内容量
  222. count = mid_qty;
  223. }
  224. for (int k = 0; k < count; k++)
  225. {
  226. //将箱号添加进List
  227. barcode.Add(BarcodeMethod1(pd_id, pr_id, pib_barcode));
  228. custbarcode.Add(BarcodeMethod1(PrefixFixed, Suffix, SerialNumIndex, SerialNumLength, Radix));
  229. midcode.Add(mid_code);
  230. if (mid_remain % pr_zxbzs != 0 && k + 1 == count && j + 1 == mid_num)
  231. AddNum = mid_remain % pr_zxbzs;
  232. pib_inqty.Add(AddNum.ToString());
  233. }
  234. }
  235. if (barcode.Count > 0)
  236. {
  237. //插入条码
  238. sql.Clear();
  239. sql.Append("insert into prodiobarcode (PIB_ID,PIB_PRODCODE,PIB_INDATE,PIB_INOUTNO,PIB_PIID,PIB_BARCODE,PIB_CUSTBARCODE,PIB_PDNO,");
  240. sql.Append("PIB_PDID,PIB_PICLASS,PIB_QTY,PIB_PRODID,PIB_OUTBOXCODE1,PIB_IFPRINT,PIB_IFPICK,PIB_ORDERCODE,PIB_CUSTPO,pib_orderdetno)");
  241. sql.Append(" values (prodiobarcode_seq.nextval,'" + pd_prodcode + "',sysdate,'" + pi_inoutno.Text + "'," + pi_id + ",:barcode,:custbarcode,'" + pd_pdno + "','" + pd_id + "',");
  242. sql.Append("'" + pi_class.Text + "',:pib_inqty,'" + pr_id + "',:midcode,0,0,'" + pd_ordercode + "','','" + pd_orderdetno + "')");
  243. dh.BatchInsert(sql.ToString(), new string[] { "barcode", "custbarcode", "pib_inqty", "midcode" }, barcode.ToArray(), custbarcode.ToArray(), pib_inqty.ToArray(), midcode.ToArray());
  244. //更新最大流水号
  245. dh.UpdateByCondition("RuleMaxNum", "rmn_maxnumber='" + custserialnum + "'", "rmn_nrcode='" + NrCode + "' and rmn_prefix='" + Prefix + "'");
  246. }
  247. else
  248. {
  249. ErrRowIndex += (i + 1) + ",";
  250. }
  251. }
  252. }
  253. if (ErrRowIndex != "")
  254. {
  255. MessageBox.Show(ErrRowIndex + "行无可用条码,请检查本次数量");
  256. return;
  257. }
  258. if (CheckedRowCount > 0)
  259. {
  260. LoadData();
  261. MessageBox.Show("生成条码成功!");
  262. }
  263. else
  264. {
  265. MessageBox.Show("未勾选需要生成的明细!");
  266. }
  267. //如果含有内容不符合的选项,进行提示
  268. string str = "";
  269. foreach (string ss in NotPass.Values)
  270. {
  271. str += ss + "\n";
  272. }
  273. if (str != "")
  274. MessageBox.Show(str);
  275. }
  276. //生成唯一条码
  277. public string BarcodeMethod1(string pd_id, string pr_id, string pib_barcode)
  278. {
  279. if (pib_barcode != "")
  280. {
  281. if (FirstCode)
  282. {
  283. serialnum = serialnum + 1;
  284. }
  285. //第一次的时候去获取数据库查询出来的值
  286. else
  287. {
  288. serialnum = int.Parse(pib_barcode.Substring(pib_barcode.Length - 4)) + 1;
  289. FirstCode = true;
  290. }
  291. }
  292. else
  293. {
  294. serialnum = serialnum + 1;
  295. }
  296. string serialcode = serialnum.ToString();
  297. for (int i = serialnum.ToString().Length; i < 4; i++)
  298. {
  299. serialcode = "0" + serialcode;
  300. }
  301. return pd_id + "-" + pr_id + "-" + serialcode;
  302. }
  303. //生成客户条码
  304. public string BarcodeMethod1(string Prefix,string Suffix,int Index, int Length, int radix)
  305. {
  306. string str = Prefix;
  307. //如果是流水则需要在前面加0
  308. string serialcode = BaseUtil.DToAny(custserialnum, radix);
  309. for (int j = serialcode.ToString().Length; j < Length; j++)
  310. {
  311. serialcode = "0" + serialcode;
  312. }
  313. str += serialcode;
  314. str += Suffix;
  315. custserialnum = custserialnum + 1;
  316. return str;
  317. }
  318. private static string lpad(int length, string number)
  319. {
  320. while (number.Length < length)
  321. {
  322. number = "0" + number;
  323. }
  324. number = number.Substring(number.Length - length, length);
  325. return number;
  326. }
  327. /// <summary>
  328. /// 重绘指定列的背景色
  329. /// </summary>
  330. /// <param name="sender"></param>
  331. /// <param name="e"></param>
  332. private void ProdIoInfDGV_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
  333. {
  334. bool mouseOver = e.CellBounds.Contains(this.PointToClient(Cursor.Position));
  335. if (e.ColumnIndex > 0)
  336. if (ProdIoInfDGV.Columns[e.ColumnIndex].Name == "pr_zxbzs" || ProdIoInfDGV.Columns[e.ColumnIndex].Name == "pd_qty" || ProdIoInfDGV.Columns[e.ColumnIndex].Name == "mid_qty")
  337. {
  338. SolidBrush solidBrush = new SolidBrush(Color.FromArgb(51, 153, 255));
  339. e.Graphics.FillRectangle(mouseOver ? solidBrush : Brushes.LightSeaGreen, e.CellBounds);
  340. Rectangle border = e.CellBounds;
  341. border.Width -= 1;
  342. e.Graphics.DrawRectangle(Pens.White, border);
  343. e.PaintContent(e.CellBounds);
  344. e.Handled = true;
  345. }
  346. }
  347. /// <summary>
  348. /// 计算中盘尾数的方法
  349. /// </summary>
  350. /// <param name="sender"></param>
  351. /// <param name="e"></param>
  352. private void ProdIoInfDGV_CellEndEdit(object sender, DataGridViewCellEventArgs e)
  353. {
  354. object pr_zxbzs = ProdIoInfDGV.Rows[e.RowIndex].Cells["pr_zxbzs"].Value;
  355. object pd_qty = ProdIoInfDGV.Rows[e.RowIndex].Cells["pd_qty"].Value;
  356. object mid_qty = ProdIoInfDGV.Rows[e.RowIndex].Cells["mid_qty"].Value;
  357. object pd_totalqty = ProdIoInfDGV.Rows[e.RowIndex].Cells["pd_totalqty"].Value;
  358. if (pr_zxbzs != null && pd_qty != null && mid_qty != null)
  359. {
  360. int 最小包装量 = int.Parse(pr_zxbzs.ToString());
  361. int 中盘容量 = int.Parse(mid_qty.ToString());
  362. int 本次数量 = int.Parse(pd_qty.ToString());
  363. int 总数 = int.Parse(pd_totalqty.ToString());
  364. if (最小包装量 > 0)
  365. {
  366. if (本次数量 > 总数)
  367. {
  368. MessageBox.Show("本次数量不能大于总数");
  369. return;
  370. }
  371. if (中盘容量 <= 0 || 最小包装量 <= 0)
  372. {
  373. MessageBox.Show("中盘容量和单盘数量必须是正整数");
  374. return;
  375. }
  376. //计算中盘数量
  377. int mid_num = 本次数量 / (最小包装量 * 中盘容量);
  378. //计算中盘尾数
  379. if (本次数量 % (最小包装量 * 中盘容量) == 0)
  380. ProdIoInfDGV.Rows[e.RowIndex].Cells["mid_num"].Value = mid_num;
  381. else
  382. ProdIoInfDGV.Rows[e.RowIndex].Cells["mid_num"].Value = mid_num + 1;
  383. ProdIoInfDGV.Rows[e.RowIndex].Cells["mid_remain"].Value = 本次数量 - mid_num * 最小包装量 * 中盘容量;
  384. }
  385. }
  386. }
  387. //设置全部中盒容量
  388. private void SetMidCapacity_Click(object sender, EventArgs e)
  389. {
  390. for (int i = 0; i < ProdIoInfDGV.Rows.Count; i++)
  391. {
  392. ProdIoInfDGV.Rows[i].Cells["mid_qty"].Value = MidCapacity.Text;
  393. if (ProdIoInfDGV.Rows[i].Cells["pr_zxbzs"].Value.ToString() != "" && ProdIoInfDGV.Rows[i].Cells["pd_qty"].Value.ToString() != "" && ProdIoInfDGV.Rows[i].Cells["mid_qty"].Value.ToString() != "" && ProdIoInfDGV.Rows[i].Cells["pr_zxbzs"].Value.ToString() != "0")
  394. {
  395. object pr_zxbzs = ProdIoInfDGV.Rows[i].Cells["pr_zxbzs"].Value;
  396. object pd_qty = ProdIoInfDGV.Rows[i].Cells["pd_qty"].Value;
  397. object mid_qty = ProdIoInfDGV.Rows[i].Cells["mid_qty"].Value;
  398. object pd_totalqty = ProdIoInfDGV.Rows[i].Cells["pd_totalqty"].Value;
  399. if (pr_zxbzs != null && pd_qty != null && mid_qty != null)
  400. {
  401. int 最小包装量 = int.Parse(pr_zxbzs.ToString());
  402. int 中盘容量 = int.Parse(mid_qty.ToString());
  403. int 本次数量 = int.Parse(pd_qty.ToString());
  404. int 总数 = int.Parse(pd_totalqty.ToString());
  405. //计算中盘数量
  406. int mid_num = 本次数量 / (最小包装量 * 中盘容量);
  407. //计算中盘尾数
  408. if (本次数量 % (最小包装量 * 中盘容量) == 0)
  409. ProdIoInfDGV.Rows[i].Cells["mid_num"].Value = mid_num;
  410. else
  411. ProdIoInfDGV.Rows[i].Cells["mid_num"].Value = mid_num + 1;
  412. ProdIoInfDGV.Rows[i].Cells["mid_remain"].Value = 本次数量 - mid_num * 最小包装量 * 中盘容量;
  413. }
  414. }
  415. }
  416. }
  417. private void LoadData()
  418. {
  419. //获取客户编号
  420. CustCode = dh.getFieldDataByCondition("ProdInOut", "pi_cardcode", "pi_inoutno='" + pi_inoutno.Text + "'").ToString();
  421. //获取编码规则编号
  422. NrCode = dh.getFieldDataByCondition("NoRule", "nr_code", "nr_custcode='" + CustCode + "'").ToString();
  423. //用于存放每一项的明细的数据
  424. dt = (DataTable)dh.ExecuteSql("select pi_class,pi_id from prodinout where pi_inoutno='" + pi_inoutno.Text + "'", "select");
  425. if (dt.Rows.Count > 0)
  426. {
  427. pi_id = dt.Rows[0]["pi_id"].ToString();
  428. BaseUtil.SetFormValue(this.Controls, dt);
  429. //查询出入库的类型
  430. dt = (DataTable)dh.ExecuteSql("select ds_inorout from documentsetup where ds_name='" + pi_class.Text + "'", "select");
  431. sql.Clear();
  432. sql.Append("select pd_piid,pd_id,pr_id,pr_brand,pr_unit,pr_detail,pr_spec,pr_zxbzs,outqty pd_totalqty,pd_ordercode,pd_orderdetno,pd_pdno,pd_prodcode,pd_piclass,pd_qty from (select ");
  433. sql.Append("pd_piid,pd_id,pr_id,pr_brand,pr_unit,pr_detail,pr_spec,pr_zxbzs,outqty,pd_ordercode,pd_orderdetno,pd_pdno,pd_prodcode,pd_piclass,");
  434. sql.Append("outqty-nvl((select sum(nvl(pib_qty,0)) from PRODIOBARCODE where PIB_PIID=pd_piid and pib_ordercode=pd_ordercode ");
  435. sql.Append("and pib_orderdetno=pd_orderdetno),0)pd_qty from (select pd_piid,min(pd_id) pd_id,sum(pd_outqty)outqty,");
  436. sql.Append("pd_ordercode,pd_orderdetno,pd_pdno,max(pd_prodcode)pd_prodcode,max(pd_piclass)pd_piclass ");
  437. sql.Append("from prodiodetail where pd_piclass='出货单' group by pd_piid,pd_ordercode,pd_orderdetno,pd_pdno)T left join product on pr_code=pd_prodcode ");
  438. sql.Append("where nvl(pr_zxbzs,0)>0) where pd_piid='" + pi_id + "'");
  439. dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  440. BaseUtil.FillDgvWithDataTable(ProdIoInfDGV, dt);
  441. }
  442. else
  443. {
  444. MessageBox.Show("当前单据不存在");
  445. pi_inoutno.Text = "";
  446. }
  447. }
  448. private void ResetSerialNum_Click(object sender, EventArgs e)
  449. {
  450. dt = (DataTable)dh.ExecuteSql("select pi_class,pi_id from prodinout where pi_inoutno='" + pi_inoutno.Text + "'", "select");
  451. if (dt.Rows.Count > 0)
  452. {
  453. if (NrCode != "")
  454. {
  455. dh.UpdateByCondition("RuleMaxNum", "rmn_maxnumber=1", "rmn_nrcode='" + NrCode + "' and rmn_prefix='" + Prefix + "'");
  456. MessageBox.Show("流水重置成功");
  457. }
  458. else
  459. MessageBox.Show("当前客户无对应条码规则");
  460. }
  461. else
  462. {
  463. MessageBox.Show("当前单据不存在");
  464. pi_inoutno.Text = "";
  465. }
  466. }
  467. }
  468. }