FrmOutManagJg.cs 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671
  1. using com.steering.mes.mcp.entity;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Server;
  4. using Core.Mes.Client.Comm.Tool;
  5. using Core.StlMes.Client.Mcp.CollarMaterial;
  6. using Core.StlMes.Client.Mcp.Common;
  7. using Core.StlMes.Client.Mcp.Control;
  8. using Core.StlMes.Client.Mcp.Entity;
  9. using CoreFS.CA06;
  10. using Infragistics.Win;
  11. using Infragistics.Win.UltraWinGrid;
  12. using System;
  13. using System.Collections;
  14. using System.Collections.Generic;
  15. using System.ComponentModel;
  16. using System.Data;
  17. using System.Drawing;
  18. using System.Linq;
  19. using System.Text;
  20. using System.Windows.Forms;
  21. namespace Core.StlMes.Client.Mcp.CollarLibrary
  22. {
  23. public partial class FrmOutManagJg : FrmBase
  24. {
  25. private string strOutbound = "800803";//出库类型编码
  26. private string strOutname = "";//出库类型名称
  27. public FrmOutManagJg()
  28. {
  29. InitializeComponent();
  30. this.IsLoadUserView = true;
  31. }
  32. private void FrmCollarOutBound_Load(object sender, EventArgs e)
  33. {
  34. StorInfo();
  35. getStoreAll();
  36. DateTime now = DateTime.Now;
  37. RegStartTime.Value = DateTime.Parse(now.AddDays(1 - now.Day).ToString("yyyy-MM-dd"));
  38. RegEndTime.Value = DateTime.Parse(DateTime.Today.AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd") + " 23:59:59");
  39. EntityHelper.ShowGridCaption<CouplingMatDealEntity>(ultraGrid2.DisplayLayout.Bands[0]);
  40. PipeManageClass.setUltraGridColumnInput(ultraGrid2, new string[] { "DealNum" });//支数
  41. PipeManageClass.setUltraGridColumnMaxInput(ultraGrid2, new string[] { "DealWt" });//重量
  42. }
  43. /// <summary>
  44. /// 重写基类方法
  45. /// </summary>
  46. /// <param name="sender"></param>
  47. /// <param name="ToolbarKey"></param>
  48. public override void ToolBar_Click(object sender, string ToolbarKey)
  49. {
  50. switch (ToolbarKey)
  51. {
  52. case "Query":
  53. doQuery();
  54. break;
  55. case "Add":
  56. doAdd();
  57. break;
  58. case "Delete":
  59. doDelete();
  60. break;
  61. case "BackLibrary"://回库
  62. doBackLibrary();
  63. break;
  64. case "DoHandle"://标识已处理
  65. doHandle("1");
  66. break;
  67. case "DoHandle0"://标识未处理
  68. doHandle("0");
  69. break;
  70. //case "Refresh":
  71. // doRefresh();
  72. // break;
  73. case "Export":
  74. if (ultraTabControl1.SelectedTab.Key.Equals("Library1"))
  75. {
  76. GridHelper.ulGridToExcel(ultraGrid1, "库存实绩");
  77. }
  78. else
  79. {
  80. GridHelper.ulGridToExcel(ultraGrid2, "领用出库实绩");
  81. }
  82. break;
  83. case "Close":
  84. this.Close();
  85. break;
  86. }
  87. }
  88. /// <summary>
  89. /// 查询
  90. /// </summary>
  91. private void doQuery()
  92. {
  93. string strRegStart = "";
  94. string strRegEnd = "";
  95. string orderNo = "";
  96. string strFurnace = "";
  97. ArrayList pram = new ArrayList();
  98. if (!CheckQuery()) return;
  99. if (chkOrderNo.Checked)
  100. {
  101. orderNo = txtOrderNo.Value.ToString();
  102. }
  103. string codeJg = "";
  104. if (chcCodeJg.Checked)
  105. {
  106. codeJg = txtCodeJg.Value.ToString();
  107. }
  108. if (chkRegTime.Checked)
  109. {
  110. strRegStart = RegStartTime.Value.ToString();
  111. strRegEnd = RegEndTime.Value.ToString();
  112. }
  113. if (chkFurnace.Checked)
  114. {
  115. strFurnace = txtFurnace.Text.Trim();
  116. }
  117. pram.Clear();
  118. pram.Add(strFurnace);
  119. pram.Add(strRegStart);
  120. pram.Add(strRegStart);
  121. pram.Add(strRegStart);
  122. pram.Add(strRegEnd);
  123. pram.Add(strRegEnd);
  124. string[] str = this.ValidDataPurviewIds;
  125. //获取用户对应科室ID
  126. string User = this.UserInfo.GetDeptid();
  127. string StorageType = "";//根据传递的参数获取仓库类别
  128. string StorageAttr = "";////根据传递的参数获取仓库类型
  129. if (CustomInfo != "")
  130. {
  131. string[] strflg = CustomInfo.ToString().Split(new char[] { ',' });
  132. StorageType = strflg[0];
  133. StorageAttr = strflg[1];
  134. }
  135. string[] arr = null;
  136. DataTable ds = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getStoreNo", new object[] { StorageType, StorageAttr, str }, this.ob);
  137. if (ds.Rows.Count > 0)
  138. {
  139. arr = new string[ds.Rows.Count];
  140. for (int i = 0; i < ds.Rows.Count; i++)
  141. {
  142. arr[i] = ds.Rows[i][0].ToString();
  143. }
  144. }
  145. if (arr == null)
  146. {
  147. MessageUtil.ShowTips("无仓库权限!");
  148. return;
  149. }
  150. if (arr.Length < 1)
  151. {
  152. return;
  153. }
  154. if (ultraTabControl1.SelectedTab.Key.Equals("Library1"))
  155. {
  156. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.CollarLibrary.FrmOutManagJg.doQueryInfoResult", new object[] { pram, arr, orderNo,codeJg }, ob);
  157. GridHelper.CopyDataToDatatable(dt, this.dataStorage, true);
  158. }
  159. else
  160. {
  161. string flag = "0";
  162. string handleflag = "0";
  163. if (ultraCheckEditor1.Checked)
  164. {
  165. flag = "1";
  166. }
  167. if (ultraHandleFlag.Checked == false)
  168. {
  169. handleflag = "";
  170. }
  171. //pram.Add(strOutbound);
  172. List<CouplingMatDealEntity> listSource = EntityHelper.GetData<CouplingMatDealEntity>
  173. ("com.steering.mes.mcp.CollarLibrary.FrmOutManagJg.queryOutPerfo", new object[] { pram, arr, orderNo, codeJg, flag, handleflag }, this.ob);
  174. couplingMatDealEntityBindingSource.DataSource = listSource;
  175. GridHelper.RefreshAndAutoSize(ultraGrid2);
  176. }
  177. }
  178. /// <summary>
  179. /// 获取仓库
  180. /// </summary>
  181. private void StorInfo()
  182. {
  183. string[] str = this.ValidDataPurviewIds;
  184. ArrayList arList = new ArrayList();
  185. //获取用户对应科室ID
  186. string User = this.UserInfo.GetDeptid();
  187. string StorageType = "";//根据传递的参数获取仓库类别
  188. string StorageAttr = "";////根据传递的参数获取仓库类型
  189. if (CustomInfo != "")
  190. {
  191. string[] strflg = CustomInfo.ToString().Split(new char[] { ',' });
  192. StorageType = strflg[0];
  193. StorageAttr = strflg[1];
  194. }
  195. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getStoreNo", new object[] { StorageType, StorageAttr, str }, this.ob);
  196. CKstorage.DataSource = dt;
  197. CKstorage.DisplayMember = "STORAGE_NAME";
  198. CKstorage.ValueMember = "STORAGE_NO";
  199. PipeManageClass.SetComboItemHeight(CKstorage);
  200. }
  201. /// <summary>
  202. /// 获取所有的目标库
  203. /// </summary>
  204. private void getStoreAll()
  205. {
  206. string StorageType = "";//根据传递的参数获取仓库类别
  207. string StorageAttr = "";////根据传递的参数获取仓库类型
  208. if (CustomInfo != "")
  209. {
  210. string[] strflg = CustomInfo.ToString().Split(new char[] { ',' });
  211. StorageType = strflg[0];
  212. StorageAttr = strflg[1];
  213. }
  214. string[] arr = McpBaseHelper.WarehousePermissions(this.CustomInfo, this.ValidDataPurviewIds, this.ob);
  215. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getStoreAll", new object[] { StorageType, "800302", arr }, this.ob);
  216. mbStorage.DataSource = dt;
  217. mbStorage.DisplayMember = "STORAGE_NAME";
  218. mbStorage.ValueMember = "STORAGE_NO";
  219. PipeManageClass.SetComboItemHeight(mbStorage);
  220. }
  221. ///查询时验证必填项
  222. private bool CheckQuery()
  223. {
  224. if (chkRegTime.Checked&&DataTimeUtil.JudgeTime(DateTime.Parse(RegStartTime.Value.ToString()), DateTime.Parse(RegEndTime.Value.ToString())) == 0)
  225. {
  226. MessageUtil.ShowTips("开始时间不能大于结束时间!");
  227. return false;
  228. }
  229. if (chkOrderNo.Checked && string.IsNullOrEmpty(txtOrderNo.Text.Trim()))
  230. {
  231. MessageBox.Show("请输入合同号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  232. return false;
  233. }
  234. if (chcCodeJg.Checked && string.IsNullOrEmpty(txtCodeJg.Text.Trim()))
  235. {
  236. MessageBox.Show("请输入接箍码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  237. return false;
  238. }
  239. //if (chkMaterial.Checked && string.IsNullOrEmpty(cmbMaterial.Text.Trim()))
  240. //{
  241. // MessageBox.Show("请选择框号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  242. // return false;
  243. //}
  244. if (chkFurnace.Checked && string.IsNullOrEmpty(txtFurnace.Text.Trim()))
  245. {
  246. MessageBox.Show("请输入炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  247. return false;
  248. }
  249. return true;
  250. }
  251. /// <summary>
  252. /// 验证Checked是否勾选,显示控件可编辑 打勾表示可编辑,不打勾表示不可编辑
  253. /// </summary>
  254. /// <param name="sender"></param>
  255. /// <param name="e"></param>
  256. private void chk_CheckedChanged(object sender, EventArgs e)
  257. {
  258. if (chkOrderNo.Checked) { txtOrderNo.Enabled = true; } else { txtOrderNo.Enabled = false; }
  259. if (chcCodeJg.Checked) { txtCodeJg.Enabled = true; } else { txtCodeJg.Enabled = false; }
  260. if (chkFurnace.Checked) { txtFurnace.Enabled = true; } else { txtFurnace.Enabled = false; }
  261. if (chkRegTime.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; }
  262. }
  263. private void FrmCollarOutBound_Shown(object sender, EventArgs e)
  264. {
  265. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  266. toolMenu.Toolbars[0].Tools["BackLibrary"].InstanceProps.Visible = DefaultableBoolean.False;
  267. toolMenu.Toolbars[0].Tools["DoHandle"].InstanceProps.Visible = DefaultableBoolean.False;
  268. toolMenu.Toolbars[0].Tools["DoHandle0"].InstanceProps.Visible = DefaultableBoolean.False;
  269. ultraCheckEditor1.Visible = false;
  270. ultraHandleFlag.Visible = false;
  271. }
  272. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  273. {
  274. if (toolMenu == null) return;
  275. if (ultraTabControl1.SelectedTab.Key.Equals("Library1"))
  276. {
  277. this.chkRegTime.Text = "入库时间";
  278. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  279. toolMenu.Toolbars[0].Tools["BackLibrary"].InstanceProps.Visible = DefaultableBoolean.False;
  280. toolMenu.Toolbars[0].Tools["DoHandle"].InstanceProps.Visible = DefaultableBoolean.False;
  281. toolMenu.Toolbars[0].Tools["DoHandle0"].InstanceProps.Visible = DefaultableBoolean.False;
  282. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  283. ultraCheckEditor1.Visible = false;
  284. ultraHandleFlag.Visible = false;
  285. }
  286. else
  287. {
  288. this.chkRegTime.Text = "出库时间";
  289. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
  290. toolMenu.Toolbars[0].Tools["BackLibrary"].InstanceProps.Visible = DefaultableBoolean.True;
  291. toolMenu.Toolbars[0].Tools["DoHandle"].InstanceProps.Visible = DefaultableBoolean.True;
  292. toolMenu.Toolbars[0].Tools["DoHandle0"].InstanceProps.Visible = DefaultableBoolean.True;
  293. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  294. ultraCheckEditor1.Visible = true;
  295. ultraHandleFlag.Visible = true;
  296. }
  297. }
  298. /// <summary>
  299. /// 回车键查询
  300. /// </summary>
  301. /// <param name="sender"></param>
  302. /// <param name="e"></param>
  303. private void txtFurnace_KeyDown(object sender, KeyEventArgs e)
  304. {
  305. if (e.KeyValue == 13)
  306. {
  307. doQuery();
  308. }
  309. }
  310. private void ultraGrid1_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e)
  311. {
  312. foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
  313. {
  314. if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
  315. {
  316. uRow.Cells["CHOOSE"].Value = true;
  317. }
  318. }
  319. }
  320. /// <summary>
  321. /// 领用出库
  322. /// </summary>
  323. private void doAdd()
  324. {
  325. this.ultraGrid1.UpdateData();
  326. ArrayList list = new ArrayList();
  327. //查询出库类型
  328. //DataTable dt = PipeManageClass.getComTypeInfo(strOutbound, ob);
  329. //if (dt.Rows.Count >= 1)
  330. //{
  331. // strOutname = dt.Rows[0]["BASENAME"].ToString();
  332. //}
  333. //else
  334. //{
  335. // MessageUtil.ShowTips("出库类型不能为空,请确认基础信息是否有对应出库类型信息!");
  336. // return;
  337. //}
  338. int num = 0;
  339. ArrayList List = new ArrayList();
  340. foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid1.Rows)
  341. {
  342. if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
  343. {
  344. num++;
  345. if (uRow.Cells["PLA_COUNT"].Text.Trim() == "")
  346. {
  347. MessageUtil.ShowTips("请输入个数!");
  348. return;
  349. }
  350. if (double.Parse(uRow.Cells["PLA_COUNT"].Value.ToString()) > double.Parse(uRow.Cells["PRO_NUM"].Value.ToString()))
  351. {
  352. MessageUtil.ShowTips("领用出库个数不能大于库存个数!");
  353. return;
  354. }
  355. ArrayList matList = new ArrayList();
  356. matList.Add(uRow.Cells["JUDGE_STOVE_NO"].Text);
  357. matList.Add(uRow.Cells["BATCH_NO"].Text);
  358. //DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMoveOut.getMatStaus", new object[] { matList }, this.ob);
  359. //if (int.Parse(ds.Rows[0]["ACOUNT"].ToString())>0)
  360. //{
  361. // MessageUtil.ShowTips("此炉【" + uRow.Cells["JUDGE_STOVE_NO"].Text + "】已被做计划,不允许进行倒库!");
  362. // return;
  363. //}
  364. ArrayList pram = new ArrayList();
  365. pram.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim());
  366. pram.Add(uRow.Cells["BATCH_NO"].Text.Trim());
  367. pram.Add(uRow.Cells["RESULT_NO"].Text.Trim());
  368. pram.Add(uRow.Cells["ZY_PLAN_ID"].Text.Trim());
  369. pram.Add(this.UserInfo.GetUserOrder());
  370. pram.Add(this.UserInfo.GetUserGroup());
  371. pram.Add(this.UserInfo.GetUserName());
  372. pram.Add(uRow.Cells["PLA_COUNT"].Value.ToString());
  373. pram.Add(uRow.Cells["WO_ID"].Value.ToString());
  374. pram.Add(uRow.Cells["MAT_NO"].Value.ToString());
  375. pram.Add(uRow.Cells["MAT_NO_XH"].Value.ToString());
  376. pram.Add(uRow.Cells["PLA_WEIGHT"].Value.ToString());
  377. pram.Add(uRow.Cells["GUID"].Value.ToString());
  378. pram.Add(uRow.Cells["GOWHERE_NAME"].Value.ToString());
  379. List.Add(pram);
  380. }
  381. }
  382. if (num == 0)
  383. {
  384. MessageUtil.ShowTips("请选择需要操作的数据!");
  385. return;
  386. }
  387. if (MessageUtil.ShowYesNoAndQuestion("是否确认领用?") == DialogResult.No) return;
  388. CoreClientParam ccp = new CoreClientParam();
  389. try
  390. {
  391. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  392. if (Constant.WaitingForm == null)
  393. {
  394. Constant.WaitingForm = new WaitingForm();
  395. }
  396. Constant.WaitingForm.ShowToUser = true;
  397. Constant.WaitingForm.Show();
  398. Constant.WaitingForm.Update();
  399. ccp.ServerName = "com.steering.mes.mcp.CollarLibrary.FrmOutManagJg";
  400. ccp.MethodName = "addOutLibResult";
  401. ccp.ServerParams = new object[] { List };
  402. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  403. this.Cursor = Cursors.Default;
  404. Constant.WaitingForm.ShowToUser = false;
  405. Constant.WaitingForm.Close();
  406. Constant.WaitingForm = null;
  407. }
  408. catch (Exception ex)
  409. {
  410. this.Cursor = Cursors.Default;
  411. Constant.WaitingForm.ShowToUser = false;
  412. Constant.WaitingForm.Close();
  413. Constant.WaitingForm = null;
  414. }
  415. if (ccp.ReturnCode == -1) return;
  416. MessageUtil.ShowTips(ccp.ReturnInfo);
  417. if (ccp.ReturnInfo.Equals("领用出库成功!"))
  418. {
  419. doQuery();
  420. }
  421. }
  422. /// <summary>
  423. /// 撤销出库
  424. /// </summary>
  425. private void doDelete()
  426. {
  427. UltraGridRow ugr = this.ultraGrid2.ActiveRow;
  428. int count = 0;
  429. if (ugr == null) return;
  430. ArrayList list = new ArrayList();
  431. foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid2.Rows)
  432. {
  433. if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
  434. {
  435. if (int.Parse(uRow.Cells["UsedNum"].Value.ToString()) > 0)
  436. {
  437. MessageUtil.ShowTips("领用个数已使用,不能撤销领用!"); return;
  438. }
  439. count += 1;
  440. ArrayList pram = new ArrayList();
  441. pram.Add(uRow.Cells["resultNo"].Text.Trim());
  442. pram.Add(uRow.Cells["matNo"].Text.Trim());
  443. pram.Add(uRow.Cells["kepNo"].Value.ToString());
  444. pram.Add(this.UserInfo.GetUserOrder());
  445. pram.Add(this.UserInfo.GetUserGroup());
  446. pram.Add(this.UserInfo.GetUserName());
  447. pram.Add(uRow.Cells["dealOrde"].Text.ToString());
  448. pram.Add(uRow.Cells["MatNoXh"].Value.ToString());
  449. pram.Add(uRow.Cells["JgOrderno"].Value.ToString());
  450. list.Add(pram);
  451. }
  452. }
  453. if (count == 0) { MessageUtil.ShowTips("请选择要撤销的数据"); return; }
  454. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销?") == DialogResult.No) return;
  455. CoreClientParam ccp = new CoreClientParam();
  456. try
  457. {
  458. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  459. if (Constant.WaitingForm == null)
  460. {
  461. Constant.WaitingForm = new WaitingForm();
  462. }
  463. Constant.WaitingForm.ShowToUser = true;
  464. Constant.WaitingForm.Show();
  465. Constant.WaitingForm.Update();
  466. ccp.ServerName = "com.steering.mes.mcp.CollarLibrary.FrmOutManagJg";
  467. ccp.MethodName = "deleteOutLibResult";
  468. ccp.ServerParams = new object[] { list };
  469. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  470. this.Cursor = Cursors.Default;
  471. Constant.WaitingForm.ShowToUser = false;
  472. Constant.WaitingForm.Close();
  473. Constant.WaitingForm = null;
  474. }
  475. catch (Exception ex)
  476. {
  477. this.Cursor = Cursors.Default;
  478. Constant.WaitingForm.ShowToUser = false;
  479. Constant.WaitingForm.Close();
  480. Constant.WaitingForm = null;
  481. }
  482. if (ccp.ReturnCode == -1) return;
  483. MessageUtil.ShowTips(ccp.ReturnInfo);
  484. if (ccp.ReturnInfo.Equals("撤销成功!"))
  485. {
  486. doQuery();
  487. }
  488. }
  489. /// <summary>
  490. /// 回库
  491. /// </summary>
  492. private void doBackLibrary()
  493. {
  494. UltraGridRow ugr = this.ultraGrid2.ActiveRow;
  495. int count = 0;
  496. if (ugr == null) return;
  497. ArrayList list = new ArrayList();
  498. foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid2.Rows)
  499. {
  500. if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
  501. {
  502. //if (int.Parse(uRow.Cells["UsedNum"].Value.ToString()) == 0)
  503. //{
  504. // MessageUtil.ShowTips("领用个数未使用,不能回库!"); return;
  505. //}
  506. if (int.Parse(uRow.Cells["DealNum"].Value.ToString()) - int.Parse(uRow.Cells["UsedNum"].Value.ToString()) <= 0)
  507. {
  508. MessageUtil.ShowTips("领用个数已全部使用,不能回库!"); return;
  509. }
  510. count += 1;
  511. ArrayList pram = new ArrayList();
  512. pram.Add(this.UserInfo.GetUserName());
  513. pram.Add(uRow.Cells["dealOrde"].Text.ToString());
  514. pram.Add(uRow.Cells["ButBackNum"].Text.ToString());
  515. list.Add(pram);
  516. }
  517. }
  518. if (count == 0) { MessageUtil.ShowTips("请选择要回库数据"); return; }
  519. if (MessageUtil.ShowYesNoAndQuestion("是否确认回库?") == DialogResult.No) return;
  520. CoreClientParam ccp = new CoreClientParam();
  521. try
  522. {
  523. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  524. if (Constant.WaitingForm == null)
  525. {
  526. Constant.WaitingForm = new WaitingForm();
  527. }
  528. Constant.WaitingForm.ShowToUser = true;
  529. Constant.WaitingForm.Show();
  530. Constant.WaitingForm.Update();
  531. ccp.ServerName = "com.steering.mes.mcp.CollarLibrary.FrmOutManagJg";
  532. ccp.MethodName = "doBackLibrary";
  533. ccp.ServerParams = new object[] { list };
  534. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  535. this.Cursor = Cursors.Default;
  536. Constant.WaitingForm.ShowToUser = false;
  537. Constant.WaitingForm.Close();
  538. Constant.WaitingForm = null;
  539. }
  540. catch (Exception ex)
  541. {
  542. this.Cursor = Cursors.Default;
  543. Constant.WaitingForm.ShowToUser = false;
  544. Constant.WaitingForm.Close();
  545. Constant.WaitingForm = null;
  546. }
  547. if (ccp.ReturnCode == -1) return;
  548. MessageUtil.ShowTips(ccp.ReturnInfo);
  549. if (ccp.ReturnInfo.Equals("回库成功!"))
  550. {
  551. doQuery();
  552. }
  553. }
  554. /// <summary>
  555. /// 处理状态(0:未处理,1:已处理)
  556. /// </summary>
  557. /// <param name="handleflag"></param>
  558. private void doHandle(string handleflag)
  559. {
  560. this.ultraGrid2.UpdateData();
  561. ArrayList list = new ArrayList();
  562. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHOOSE = 'True'");
  563. foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in checkMagRows)
  564. {
  565. ArrayList pram = new ArrayList();
  566. pram.Add(this.UserInfo.GetUserName());
  567. pram.Add(uRow.Cells["dealOrde"].Text.ToString());
  568. pram.Add(handleflag);
  569. list.Add(pram);
  570. }
  571. CoreClientParam ccp = new CoreClientParam();
  572. try
  573. {
  574. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  575. if (Constant.WaitingForm == null)
  576. {
  577. Constant.WaitingForm = new WaitingForm();
  578. }
  579. Constant.WaitingForm.ShowToUser = true;
  580. Constant.WaitingForm.Show();
  581. Constant.WaitingForm.Update();
  582. ccp.ServerName = "com.steering.mes.mcp.CollarLibrary.FrmOutManagJg";
  583. ccp.MethodName = "doHandle";
  584. ccp.ServerParams = new object[] { list };
  585. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  586. this.Cursor = Cursors.Default;
  587. Constant.WaitingForm.ShowToUser = false;
  588. Constant.WaitingForm.Close();
  589. Constant.WaitingForm = null;
  590. }
  591. catch (Exception ex)
  592. {
  593. this.Cursor = Cursors.Default;
  594. Constant.WaitingForm.ShowToUser = false;
  595. Constant.WaitingForm.Close();
  596. Constant.WaitingForm = null;
  597. }
  598. if (ccp.ReturnCode == -1) return;
  599. MessageUtil.ShowTips(ccp.ReturnInfo);
  600. if (ccp.ReturnInfo.Equals("处理成功!"))
  601. {
  602. doQuery();
  603. }
  604. }
  605. private void ultraGrid2_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  606. {
  607. foreach (UltraGridRow uRow in ultraGrid2.Selected.Rows)
  608. {
  609. if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
  610. {
  611. uRow.Cells["CHOOSE"].Value = true;
  612. }
  613. }
  614. }
  615. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  616. {
  617. ultraGrid1.UpdateData();
  618. if (e.Cell.Column.Key.Equals("PLA_COUNT"))
  619. {
  620. if (e.Cell.Row.Cells["PLA_COUNT"].Text.ToString().Trim() == "")
  621. {
  622. e.Cell.Row.Cells["PLA_COUNT"].Value = "0";
  623. }
  624. e.Cell.Row.Cells["PLA_WEIGHT"].Value = double.Parse(e.Cell.Row.Cells["PLA_COUNT"].Value.ToString()) * (double.Parse(e.Cell.Row.Cells["SINGLEWEIGHT"].Value.ToString())/1000);
  625. }
  626. }
  627. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  628. {
  629. UltraGridRow ugr = this.ultraGrid1.ActiveRow;
  630. if (ugr == null) return;
  631. string ordLnDPk = ugr.Cells["ORD_LN_DLY_PK"].Text.Trim().ToString();
  632. //获取成品产线
  633. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.CollarLibrary.FrmOutManagJg.getGoWhereName", new object[] { ordLnDPk }, this.ob);
  634. txtGowhere.DataSource = dt;
  635. txtGowhere.DisplayMember = "PLINE_NAME";
  636. txtGowhere.ValueMember = "PLINE_NAME";
  637. PipeManageClass.SetComboItemHeight(txtGowhere);
  638. }
  639. }
  640. }