FrmGpPriceCarry.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343
  1. using Core.Mes.Client.Comm;
  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.GlBusiness.Dialog;
  6. using Core.StlMes.Client.Judge.Forms;
  7. using CoreFS.CA06;
  8. using Infragistics.Win;
  9. using Infragistics.Win.UltraWinGrid;
  10. using System;
  11. using System.Collections;
  12. using System.Collections.Generic;
  13. using System.ComponentModel;
  14. using System.Data;
  15. using System.Drawing;
  16. using System.Linq;
  17. using System.Text;
  18. using System.Threading.Tasks;
  19. using System.Windows.Forms;
  20. namespace Core.StlMes.Client.GlBusiness
  21. {
  22. public partial class FrmGpPriceCarry : FrmBase
  23. {
  24. public FrmGpPriceCarry()
  25. {
  26. InitializeComponent();
  27. }
  28. public override void ToolBar_Click(object sender, string ToolbarKey)
  29. {
  30. switch (ToolbarKey)
  31. {
  32. case "doQuery":
  33. doQuery();//查询
  34. break;
  35. case "doAdd":
  36. doAdd();//挂账
  37. break;
  38. case "doDelete":
  39. doDelete();//取消挂账
  40. break;
  41. case "doPrint":
  42. doPrint();//打印
  43. break;
  44. case "Close":
  45. Close();//关闭
  46. break;
  47. }
  48. }
  49. private void doQuery()
  50. {
  51. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  52. {
  53. string orderNo = ""; //合同号
  54. string orderStart = "";
  55. string orderEnd = "";
  56. if (uchkOrderNo.Checked)
  57. {
  58. orderNo = utxtOrderNo.Text.Trim();
  59. }
  60. if (uchkDate.Checked)
  61. {
  62. orderStart = udtStart.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
  63. orderEnd = udtEnd.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
  64. }
  65. else
  66. {
  67. orderStart = "1000-01-01 00:00:01";
  68. orderEnd = "9999-12-31 23:59:59";
  69. }
  70. DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryHeadAndLineGp", new Object[] { orderNo, orderStart, orderEnd, this.ValidDataPurviewIds }, this.ob);
  71. GridHelper.CopyDataToDatatable(ref dt, ref this.orderLine, true);
  72. GridHelper.RefreshAndAutoSizeExceptColumns(this.ultraGrid1);
  73. }
  74. else
  75. {
  76. string balanceNo = "";
  77. string orderNo = ""; //合同号
  78. string orderStart = "";
  79. string orderEnd = "";
  80. if (ckBalanceNo.Checked)
  81. {
  82. balanceNo = utBalanceNo.Text.Trim();
  83. }
  84. if (ckOrderNo.Checked)
  85. {
  86. orderNo = utOrderNo.Text.Trim();
  87. }
  88. if (ckDate.Checked)
  89. {
  90. orderStart = utDate1.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
  91. orderEnd = utDate2.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
  92. }
  93. else
  94. {
  95. orderStart = "1000-01-01 00:00:01";
  96. orderEnd = "9999-12-31 23:59:59";
  97. }
  98. DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryBalanceInfo", new Object[] { balanceNo, orderNo, orderStart, orderEnd, txt_isPrint.Value.ToString()}, this.ob);
  99. GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable1, true);
  100. GridHelper.RefreshAndAutoSizeExceptColumns(this.ultraGrid3);
  101. }
  102. }
  103. private void doAdd()
  104. {
  105. if (ultraGrid1.ActiveRow == null)
  106. return;
  107. List<string> list = new List<string>();
  108. List<UltraGridRow> rows = ComHelper.UltraGridGetChooseRows(ultraGrid2);
  109. if (rows.Count <= 0)
  110. {
  111. MessageUtil.ShowTips("请勾选需要挂账的数据");
  112. return;
  113. }
  114. foreach (UltraGridRow row in rows)
  115. {
  116. if (!list.Contains(row.Cells["OUTSTOCK_DOC"].Value.ToString()))
  117. list.Add(row.Cells["OUTSTOCK_DOC"].Value.ToString());
  118. }
  119. String ordLnPk = ultraGrid1.ActiveRow.Cells["ORD_LN_PK"].Value.ToString();
  120. String gradeCode = ultraGrid1.ActiveRow.Cells["GRADECODE"].Value.ToString();
  121. String diamter = ultraGrid1.ActiveRow.Cells["DIMATER"].Value.ToString();
  122. CoreClientParam ccp = new CoreClientParam();
  123. ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage";
  124. ccp.MethodName = "addGpPriceInfo";
  125. ccp.ServerParams = new object[] { list, ordLnPk, gradeCode,diamter, UserInfo.GetUserName() };
  126. ccp.IfShowErrMsg = false;
  127. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  128. if (ccp != null)
  129. {
  130. if (ccp.ReturnCode == -1)
  131. {
  132. MessageUtil.ShowWarning(ccp.ReturnInfo);
  133. return;
  134. }
  135. MessageUtil.ShowTips("挂账成功!");
  136. doQuery();
  137. }
  138. }
  139. private void doDelete()
  140. {
  141. if (ultraGrid3.ActiveRow == null)
  142. return;
  143. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销挂账?") == DialogResult.No) return;
  144. String balanceNo = ultraGrid3.ActiveRow.Cells["BALANCE_NO"].Value.ToString();
  145. CoreClientParam ccp = new CoreClientParam();
  146. ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage";
  147. ccp.MethodName = "doCancelCarryGp";
  148. ccp.ServerParams = new object[] { balanceNo };
  149. ccp.IfShowErrMsg = false;
  150. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  151. if (ccp != null)
  152. {
  153. if (ccp.ReturnCode == -1)
  154. {
  155. MessageUtil.ShowWarning(ccp.ReturnInfo);
  156. return;
  157. }
  158. MessageUtil.ShowTips("撤销成功!");
  159. doQuery();
  160. }
  161. }
  162. private void FrmGlPriceCarry_Load(object sender, EventArgs e)
  163. {
  164. //默认查询当前日期-1月——当前日期数据。
  165. udtStart.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString());
  166. udtEnd.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
  167. utDate1.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString());
  168. utDate2.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
  169. txt_isPrint.SelectedIndex = 0;
  170. ValueList list2 = new ValueList();
  171. ValueListItem[] items2 = new ValueListItem[] {
  172. new ValueListItem("0", "否"),
  173. new ValueListItem("1", "是")
  174. };
  175. list2.ValueListItems.AddRange(items2);
  176. ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCER_FL"].ValueList = list2;
  177. GridHelper.SetAllColumnsActive(ultraGrid1);
  178. //if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; }
  179. ComHelper.SetComboItemHeight(txt_isPrint);
  180. }
  181. private void uchkDate_CheckedChanged(object sender, EventArgs e)
  182. {
  183. if (uchkDate.Checked)
  184. {
  185. udtStart.ReadOnly = false;
  186. udtEnd.ReadOnly = false;
  187. }
  188. else
  189. {
  190. udtStart.ReadOnly = true;
  191. udtEnd.ReadOnly = true;
  192. }
  193. }
  194. private void uchkOrderNo_CheckedChanged(object sender, EventArgs e)
  195. {
  196. if (uchkOrderNo.Checked)
  197. utxtOrderNo.ReadOnly = false;
  198. else
  199. utxtOrderNo.ReadOnly = true;
  200. }
  201. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  202. {
  203. queryOutInfo();
  204. }
  205. private void queryOutInfo(){
  206. if (ultraGrid1.ActiveRow == null)
  207. return;
  208. String gradeCode = ultraGrid1.ActiveRow.Cells["GRADECODE"].Value.ToString();
  209. String dimater = ultraGrid1.ActiveRow.Cells["DIMATER"].Value.ToString();
  210. DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryGpOutList", new Object[] { gradeCode,dimater }, this.ob);
  211. GridHelper.CopyDataToDatatable(ref dt, ref this.outList, true);
  212. }
  213. private void ckBalanceNo_CheckedChanged(object sender, EventArgs e)
  214. {
  215. if (ckBalanceNo.Checked)
  216. utBalanceNo.ReadOnly = false;
  217. else
  218. utBalanceNo.ReadOnly = true;
  219. }
  220. private void ckOrderNo_CheckedChanged(object sender, EventArgs e)
  221. {
  222. if (ckOrderNo.Checked)
  223. utOrderNo.ReadOnly = false;
  224. else
  225. utOrderNo.ReadOnly = true;
  226. }
  227. private void ckDate_CheckedChanged(object sender, EventArgs e)
  228. {
  229. if (ckDate.Checked)
  230. {
  231. utDate1.ReadOnly = false;
  232. utDate2.ReadOnly = false;
  233. }
  234. else
  235. {
  236. utDate1.ReadOnly = true;
  237. utDate2.ReadOnly = true;
  238. }
  239. }
  240. private void doPrint()
  241. {
  242. if (ultraGrid3.ActiveRow == null)
  243. return;
  244. List<string> list = new List<string>();
  245. foreach (UltraGridRow row in ultraGrid3.Rows.Where(t => t.Selected))
  246. {
  247. list.Add(row.Cells["BALANCE_NO"].Value.ToString());
  248. }
  249. if (list.Count <= 0)
  250. {
  251. MessageUtil.ShowTips("请选择需要打印的数据");
  252. return;
  253. }
  254. CoreClientParam ccp = new CoreClientParam();
  255. ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage";
  256. ccp.MethodName = "doPrint";
  257. ccp.ServerParams = new object[] { list };
  258. ccp.IfShowErrMsg = false;
  259. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  260. if (ccp != null)
  261. {
  262. if (ccp.ReturnCode == -1)
  263. {
  264. MessageUtil.ShowWarning(ccp.ReturnInfo);
  265. return;
  266. }
  267. string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInvoiceTicketTHGL.cpt&op=view" + "&PRINT_NO=" + ccp.ReturnInfo;
  268. FrmOrderRepExcel fBug = new FrmOrderRepExcel(this.ob, strurl);
  269. fBug.AutoSize = true;
  270. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  271. fBug.WindowState = FormWindowState.Maximized;
  272. fBug.Text = "半成品结算清单";
  273. fBug.Show();
  274. doQuery();
  275. doQuery();
  276. }
  277. }
  278. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  279. {
  280. if (toolMenu == null)
  281. return;
  282. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  283. {
  284. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.True; }
  285. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; }
  286. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
  287. }
  288. else
  289. {
  290. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.False; }
  291. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.True; }
  292. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
  293. }
  294. }
  295. private void FrmGpPriceCarry_Shown(object sender, EventArgs e)
  296. {
  297. if (toolMenu == null)
  298. return;
  299. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  300. {
  301. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.True; }
  302. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; }
  303. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
  304. }
  305. else
  306. {
  307. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.False; }
  308. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.True; }
  309. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
  310. }
  311. }
  312. }
  313. }