FrmCutBilletDetail.cs 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Drawing;
  4. using System.Linq;
  5. using System.Windows.Forms;
  6. using Core.Mes.Client.Comm;
  7. using Core.Mes.Client.Comm.Server;
  8. using Core.Mes.Client.Comm.Tool;
  9. using Core.StlMes.Client.LgClassModel;
  10. using Core.StlMes.Client.LgCommon;
  11. using CoreFS.CA06;
  12. using Infragistics.Win.UltraWinGrid;
  13. namespace Core.StlMes.Client.LgResMgt
  14. {
  15. public partial class FrmCutBilletDetail : FrmBase
  16. {
  17. private bool _bRelated; //关联查看/单独查询
  18. private List<string> Pline; // 数据权限
  19. private OpeBase pssOb = null;
  20. public string StoveNo = "";
  21. private int SplitterWidth =426;
  22. public FrmCutBilletDetail()
  23. {
  24. InitializeComponent();
  25. }
  26. private bool BRelated
  27. {
  28. get { return _bRelated; }
  29. set
  30. {
  31. _bRelated = value;
  32. ugpQuery.Visible = !_bRelated;
  33. cbx_STOVE_NO.Checked = _bRelated && !string.IsNullOrEmpty(StoveNo);
  34. cbx_STOVE_NO.Enabled = !_bRelated;
  35. tbSTOVE_NO.Text = _bRelated ? StoveNo : "";
  36. tbSTOVE_NO.Enabled = !_bRelated;
  37. cbx_Time.Text = _bRelated ? "计划时间从" : "切割时间从";
  38. if (!BRelated)
  39. QueryData();
  40. else
  41. ProductQuery.RefreshAutomatic();
  42. }
  43. }
  44. public override void ToolBar_Click(object sender, string ToolbarKey)
  45. {
  46. switch (ToolbarKey)
  47. {
  48. case "Query":
  49. if (!BRelated)
  50. QueryData();
  51. else
  52. ProductQuery.RefreshAutomatic();
  53. break;
  54. case "Delete":
  55. Delete();
  56. break;
  57. case "Comfirm":
  58. if (!BRelated)
  59. Confirm();
  60. else
  61. ProductQuery.Confirm();
  62. break;
  63. case "UndoConfirm":
  64. if (!BRelated)
  65. UndoConfirm();
  66. else
  67. ProductQuery.UndoConfirm();
  68. break;
  69. case "AddComfirm":
  70. ProductQuery.AddComfirm();
  71. break;
  72. case "AddUndoConfirm":
  73. ProductQuery.AddUndoConfirm();
  74. break;
  75. case "Exit":
  76. Close();
  77. break;
  78. }
  79. }
  80. private void Delete()
  81. {
  82. ugCutData.UpdateData();
  83. var list = stlIncisionEntityBindingSource.DataSource as List<StlIncisionEntity>;
  84. if (list == null)
  85. {
  86. MessageBox.Show("请勾选需要删除的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  87. return;
  88. }
  89. ;
  90. var checkList = list.Where(p => p.Check).ToList();
  91. if (!checkList.Any())
  92. {
  93. MessageBox.Show("请勾选需要删除的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  94. return;
  95. }
  96. if (checkList.Count(p => p.CcmState != "00") > 0)
  97. {
  98. MessageBox.Show("勾选的数据已结炉!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  99. return;
  100. }
  101. if (
  102. MessageBox.Show(
  103. "确定要删除这" + checkList.Count + "条切割实绩吗?", "提示",
  104. MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
  105. return;
  106. try
  107. {
  108. ServerHelper.SetData(
  109. "Core.LgMes.Server.LgDeviceManager.PerformanceManage.DeleteBilltetCut",
  110. new object[] {checkList.Select(p => p.IncisionNo).ToList()}, ob);
  111. MessageBox.Show("删除成功!\n", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  112. QueryData();
  113. OrderSelectHandler(ProductQuery.PlnSteelforOrdEntity);
  114. }
  115. catch (Exception ex)
  116. {
  117. if (ex is MESException)
  118. {
  119. }
  120. else
  121. MessageBox.Show("删除失败!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  122. }
  123. }
  124. private void UndoConfirm()
  125. {
  126. ugCutData.UpdateData();
  127. var list = stlIncisionEntityBindingSource.DataSource as List<StlIncisionEntity>;
  128. if (list == null)
  129. {
  130. MessageBox.Show("请勾选需要撤销结炉的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  131. return;
  132. }
  133. ;
  134. var checkList = list.Where(p => p.Check).ToList();
  135. if (!checkList.Any())
  136. {
  137. MessageBox.Show("请勾选需要撤销结炉的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  138. return;
  139. }
  140. if (checkList.Count(p => p.CcmState == "00") > 0)
  141. {
  142. MessageBox.Show("勾选的数据有未结炉,无法撤销!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  143. return;
  144. }
  145. if (checkList.Count(p => p.CcmState == "20") > 0)
  146. {
  147. MessageBox.Show("勾选的数据有表检结束,无法撤销!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  148. return;
  149. }
  150. if (checkList.Count(p => p.CcmState == "30") > 0)
  151. {
  152. MessageBox.Show("勾选的数据已经下线,无法撤销!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  153. return;
  154. }
  155. if (checkList.Count(p => p.CcmState != "10") > 0)
  156. {
  157. MessageBox.Show("勾选的数据不在结炉状态,无法撤销!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  158. return;
  159. }
  160. if (
  161. MessageBox.Show(
  162. "确定撤销结炉" + checkList.Select(p => p.StoveNo).Distinct().Aggregate((a, b) => a + " " + b) +
  163. "熔炼炉号的切割实绩吗?", "提示",
  164. MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
  165. return;
  166. try
  167. {
  168. CoreClientParam ccp = new CoreClientParam();
  169. ccp.ServerName = "com.steering.pss.plnsaleord.stove.ComPlanFurnace";
  170. ccp.MethodName = "updatePlnZyM";
  171. ccp.ServerParams = new object[] { checkList.Select(p => p.Furnaceno).Distinct().ToArray(), UserInfo.GetUserName(), "0" };
  172. ccp = pssOb.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  173. if (ccp.ReturnInfo != "修改成功")
  174. {
  175. MessageBox.Show("无法更新轧管炉号! \n" + ccp.ReturnInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  176. return;
  177. }
  178. ServerHelper.SetData(
  179. "Core.LgMes.Server.LgDeviceManager.PerformanceManage.UndoBilltetCutConfirm",
  180. new object[] {checkList.Select(p => p.Furnaceno).Distinct().ToList()}, ob);
  181. MessageBox.Show("撤销结炉成功!\n", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  182. QueryData();
  183. }
  184. catch (Exception ex)
  185. {
  186. if (ex is MESException)
  187. {
  188. }
  189. else
  190. MessageBox.Show("撤销结炉失败!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  191. }
  192. }
  193. private void Confirm()
  194. {
  195. ugCutData.UpdateData();
  196. var list = stlIncisionEntityBindingSource.DataSource as List<StlIncisionEntity>;
  197. if (list == null)
  198. {
  199. MessageBox.Show("请勾选需要结炉的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  200. return;
  201. }
  202. var checkList = list.Where(p => p.Check).ToList();
  203. if (!checkList.Any())
  204. {
  205. MessageBox.Show("请勾选需要结炉的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  206. return;
  207. }
  208. if (checkList.Count(p => p.CcmState != "00") > 0)
  209. {
  210. MessageBox.Show("勾选的数据已结炉!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  211. return;
  212. }
  213. if (checkList.Count(p => p.JudgeStoveNo == "") > 0)
  214. {
  215. MessageBox.Show("勾选的数据无判定炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  216. return;
  217. }
  218. if (
  219. MessageBox.Show(
  220. "确定结炉" + checkList.Select(p => p.StoveNo).Distinct().Aggregate((a, b) => a + " " + b) +
  221. "熔炼炉号的切割实绩吗?", "提示",
  222. MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
  223. return;
  224. try
  225. {
  226. CoreClientParam ccp = new CoreClientParam();
  227. ccp.ServerName = "com.steering.pss.plnsaleord.stove.ComPlanFurnace";
  228. ccp.MethodName = "updatePlnZyM";
  229. ccp.ServerParams = new object[] { checkList.Select(p => p.Furnaceno).Distinct().ToArray(), UserInfo.GetUserName(), "1" };
  230. ccp = pssOb.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  231. if (ccp.ReturnInfo != "修改成功")
  232. {
  233. MessageBox.Show("无法更新轧管炉号! \n" + ccp.ReturnInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  234. return;
  235. }
  236. ServerHelper.SetData(
  237. "Core.LgMes.Server.LgDeviceManager.PerformanceManage.BilltetCutConfirm",
  238. new object[] {checkList.Select(p => p.Furnaceno).Distinct().ToList(),UserInfo.GetUserName(),UserInfo.GetUserGroup() + UserInfo.GetUserOrder()
  239. }, ob);
  240. MessageBox.Show("结炉成功!\n", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  241. QueryData();
  242. }
  243. catch (Exception ex)
  244. {
  245. if (ex is MESException)
  246. {
  247. }
  248. else
  249. MessageBox.Show("结炉失败!\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  250. }
  251. }
  252. private void QueryData()
  253. {
  254. var datas =
  255. EntityHelper.GetData<StlIncisionEntity>(
  256. "Core.LgMes.Server.LgDeviceManager.PerformanceManage.SelectStlIncisionEntity",
  257. BRelated
  258. ? new object[]
  259. {
  260. cbx_STOVE_NO.Checked ? tbSTOVE_NO.Text : "",
  261. Pline
  262. }
  263. : new object[]
  264. {
  265. cbx_STOVE_NO.Checked ? tbSTOVE_NO.Text : "",
  266. Pline,
  267. dtStart.Value,
  268. dtEnd.Value
  269. }, ob);
  270. ugCutData.DataBindings.Clear();
  271. stlIncisionEntityBindingSource.DataSource = datas;
  272. PublicMethod.RefreshAndAutoSize(ugCutData);
  273. }
  274. protected override void OnLoad(EventArgs e)
  275. {
  276. base.OnLoad(e);
  277. ugCutData.DisplayLayout.Appearance.FontData.SizeInPoints = 10;
  278. dtStart.Value = DateTime.ParseExact(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") + " 00:00:00",
  279. "yyyy-MM-dd HH:mm:ss", null);
  280. dtEnd.Value = DateTime.ParseExact(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " 23:59:59",
  281. "yyyy-MM-dd HH:mm:ss", null);
  282. Pline = ClsBusinessPack.InitDropPlinePower("B", null, this.ValidDataPurviewIds, this.ob);
  283. ProductQuery.Pline = Pline;
  284. BRelated = true;
  285. pssOb = new OpeBase {MainUrl = CoreCommon.coreCommon.UrlList["pssserver"].Url};
  286. ProductQuery.reportSelect = proc_HeatPlanInfoChanged;
  287. ProductQuery.OrderSelectHandler += OrderSelectHandler;
  288. ProductQuery.ShiftCode = UserInfo.GetUserGroup() + UserInfo.GetUserOrder();
  289. ProductQuery.Operator = UserInfo.GetUserName();
  290. ProductQuery.ob = ob;
  291. ProductQuery.pssOb = pssOb;
  292. ProductQuery.GetWeightPerMeterFormula();
  293. ProductQuery.RefreshAutomatic();
  294. ProductQuery.Ini();
  295. ClsControlPack.SetReadOnly(ugCutData);
  296. ugCutData.DisplayLayout.Bands[0].Columns["Check"].CellActivation = Activation.AllowEdit;
  297. // ugCutData.DisplayLayout.Bands[0].Columns["ActCount"].CellActivation = Activation.AllowEdit;
  298. EntityHelper.ShowGridCaption<StlIncisionEntity>(ugCutData.DisplayLayout.Bands[0]);
  299. PublicMethod.RefreshAndAutoSize(ugCutData);
  300. IniVauleList();
  301. }
  302. private void OrderSelectHandler(PlnSteelforOrdEntity plnSteelforOrdEntity)
  303. {
  304. List<StlIncisionEntity> datas = stlIncisionEntityBindingSource.DataSource as List<StlIncisionEntity>;
  305. if (datas==null) return;
  306. List<StlIncisionEntity> CurrentData = new List<StlIncisionEntity>();
  307. foreach (var row in ugCutData.Rows)
  308. {
  309. StlIncisionEntity StlIncisionEntity = row.ListObject as StlIncisionEntity;
  310. if (StlIncisionEntity==null) continue;
  311. if (plnSteelforOrdEntity != null && StlIncisionEntity.Furnaceno == plnSteelforOrdEntity.Furnaceno &&
  312. plnSteelforOrdEntity.Sequenceno == StlIncisionEntity.Sequenceno)
  313. {
  314. row.Cells["Check"].Value = true;
  315. row.Appearance.BackColor = Color.LightGreen;
  316. CurrentData.Add(StlIncisionEntity);
  317. }
  318. else
  319. {
  320. row.Cells["Check"].Value = false;
  321. row.Appearance.ResetBackColor();
  322. }
  323. }
  324. ProductQuery.ListStlIncisionEntity = CurrentData;
  325. }
  326. private void IniVauleList()
  327. {
  328. var list = ClsBusinessPack.GetCcmState();
  329. ClsControlPack.SetGridValuelist(ref ugCutData, "CcmState", ref list);
  330. list = ClsBusinessPack.GetCastingtype();
  331. ClsControlPack.SetGridValuelist(ref ugCutData, "Castingtype", ref list);
  332. list = ClsBusinessPack.GetGptype();
  333. ClsControlPack.SetGridValuelist(ref ugCutData, "Gptype", ref list);
  334. list = ClsBusinessPack.GetValuelistBanci();
  335. ClsControlPack.SetGridValuelist(ref ugCutData, "ProShift", ref list);
  336. list = ClsBusinessPack.GetValuelistBanzu();
  337. ClsControlPack.SetGridValuelist(ref ugCutData, "ProGroup", ref list);
  338. }
  339. private void proc_HeatPlanInfoChanged(string stoveNo)
  340. {
  341. cbx_STOVE_NO.Checked = true;
  342. cbx_STOVE_NO.Enabled = false;
  343. tbSTOVE_NO.Text = stoveNo;
  344. tbSTOVE_NO.Enabled = false;
  345. StoveNo = stoveNo;
  346. if (stoveNo == "")
  347. {
  348. ugCutData.DataBindings.Clear();
  349. stlIncisionEntityBindingSource.DataSource = new List<StlIncisionEntity>();
  350. }
  351. else
  352. QueryData();
  353. }
  354. private void cbx_STOVE_NO_CheckedChanged(object sender, EventArgs e)
  355. {
  356. if (cbx_STOVE_NO.Checked)
  357. {
  358. tbSTOVE_NO.Enabled = true;
  359. tbSTOVE_NO.BackColor = Color.LightCyan;
  360. }
  361. else
  362. {
  363. tbSTOVE_NO.Enabled = false;
  364. tbSTOVE_NO.BackColor = SystemColors.Control;
  365. }
  366. }
  367. private void FrmCutBilletDetail_Shown(object sender, EventArgs e)
  368. {
  369. splitContainer1.SplitterDistance = SplitterWidth;
  370. }
  371. private void MainContainer_ExpandedStateChanged(object sender, EventArgs e)
  372. {
  373. if (MainContainer.Expanded)
  374. {
  375. splitContainer1.SplitterDistance = SplitterWidth;
  376. BRelated = true;
  377. }
  378. else
  379. {
  380. BRelated = false;
  381. SplitterWidth = splitContainer1.SplitterDistance;
  382. splitContainer1.SplitterDistance = 25;
  383. }
  384. }
  385. }
  386. }