FrmGlPriceCarry.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341
  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 FrmGlPriceCarry : FrmBase
  23. {
  24. public FrmGlPriceCarry()
  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.QueryHeadAndLine", 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 proPlanId = ultraGrid1.ActiveRow.Cells["PRO_PLAN_ID"].Value.ToString();
  121. CoreClientParam ccp = new CoreClientParam();
  122. ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage";
  123. ccp.MethodName = "addGlPriceInfo";
  124. ccp.ServerParams = new object[] { list, ordLnPk, proPlanId,UserInfo.GetUserName() };
  125. ccp.IfShowErrMsg = false;
  126. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  127. if (ccp != null)
  128. {
  129. if (ccp.ReturnCode == -1)
  130. {
  131. MessageUtil.ShowWarning(ccp.ReturnInfo);
  132. return;
  133. }
  134. MessageUtil.ShowTips("挂账成功!");
  135. doQuery();
  136. }
  137. }
  138. private void doDelete()
  139. {
  140. if (ultraGrid3.ActiveRow == null)
  141. return;
  142. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销挂账?") == DialogResult.No) return;
  143. String balanceNo = ultraGrid3.ActiveRow.Cells["BALANCE_NO"].Value.ToString();
  144. CoreClientParam ccp = new CoreClientParam();
  145. ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage";
  146. ccp.MethodName = "doCancelCarry";
  147. ccp.ServerParams = new object[] { balanceNo };
  148. ccp.IfShowErrMsg = false;
  149. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  150. if (ccp != null)
  151. {
  152. if (ccp.ReturnCode == -1)
  153. {
  154. MessageUtil.ShowWarning(ccp.ReturnInfo);
  155. return;
  156. }
  157. MessageUtil.ShowTips("撤销成功!");
  158. doQuery();
  159. }
  160. }
  161. private void FrmGlPriceCarry_Load(object sender, EventArgs e)
  162. {
  163. //默认查询当前日期-1月——当前日期数据。
  164. udtStart.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString());
  165. udtEnd.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
  166. utDate1.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString());
  167. utDate2.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
  168. ValueList list2 = new ValueList();
  169. ValueListItem[] items2 = new ValueListItem[] {
  170. new ValueListItem("0", "否"),
  171. new ValueListItem("1", "是")
  172. };
  173. list2.ValueListItems.AddRange(items2);
  174. ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCER_FL"].ValueList = list2;
  175. GridHelper.SetAllColumnsActive(ultraGrid1);
  176. //if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; }
  177. ComHelper.SetComboItemHeight(txt_isPrint);
  178. }
  179. private void uchkDate_CheckedChanged(object sender, EventArgs e)
  180. {
  181. if (uchkDate.Checked)
  182. {
  183. udtStart.ReadOnly = false;
  184. udtEnd.ReadOnly = false;
  185. }
  186. else
  187. {
  188. udtStart.ReadOnly = true;
  189. udtEnd.ReadOnly = true;
  190. }
  191. }
  192. private void uchkOrderNo_CheckedChanged(object sender, EventArgs e)
  193. {
  194. if (uchkOrderNo.Checked)
  195. utxtOrderNo.ReadOnly = false;
  196. else
  197. utxtOrderNo.ReadOnly = true;
  198. }
  199. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  200. {
  201. queryOutInfo();
  202. }
  203. private void queryOutInfo(){
  204. if (ultraGrid1.ActiveRow == null)
  205. return;
  206. String planId = ultraGrid1.ActiveRow.Cells["PRO_PLAN_ID"].Value.ToString();
  207. DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryBcOutList", new Object[] { planId }, this.ob);
  208. GridHelper.CopyDataToDatatable(ref dt, ref this.outList, true);
  209. }
  210. private void ckBalanceNo_CheckedChanged(object sender, EventArgs e)
  211. {
  212. if (ckBalanceNo.Checked)
  213. utBalanceNo.ReadOnly = false;
  214. else
  215. utBalanceNo.ReadOnly = true;
  216. }
  217. private void ckOrderNo_CheckedChanged(object sender, EventArgs e)
  218. {
  219. if (ckOrderNo.Checked)
  220. utOrderNo.ReadOnly = false;
  221. else
  222. utOrderNo.ReadOnly = true;
  223. }
  224. private void ckDate_CheckedChanged(object sender, EventArgs e)
  225. {
  226. if (ckDate.Checked)
  227. {
  228. utDate1.ReadOnly = false;
  229. utDate2.ReadOnly = false;
  230. }
  231. else
  232. {
  233. utDate1.ReadOnly = true;
  234. utDate2.ReadOnly = true;
  235. }
  236. }
  237. private void doPrint()
  238. {
  239. if (ultraGrid3.ActiveRow == null)
  240. return;
  241. List<string> list = new List<string>();
  242. foreach (UltraGridRow row in ultraGrid3.Rows.Where(t => t.Selected))
  243. {
  244. list.Add(row.Cells["BALANCE_NO"].Value.ToString());
  245. }
  246. if (list.Count <= 0)
  247. {
  248. MessageUtil.ShowTips("请选择需要打印的数据");
  249. return;
  250. }
  251. CoreClientParam ccp = new CoreClientParam();
  252. ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage";
  253. ccp.MethodName = "doPrint";
  254. ccp.ServerParams = new object[] { list };
  255. ccp.IfShowErrMsg = false;
  256. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  257. if (ccp != null)
  258. {
  259. if (ccp.ReturnCode == -1)
  260. {
  261. MessageUtil.ShowWarning(ccp.ReturnInfo);
  262. return;
  263. }
  264. string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInvoiceTicketTHGL.cpt&op=view" + "&PRINT_NO=" + ccp.ReturnInfo;
  265. FrmOrderRepExcel fBug = new FrmOrderRepExcel(this.ob, strurl);
  266. fBug.AutoSize = true;
  267. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  268. fBug.WindowState = FormWindowState.Maximized;
  269. fBug.Text = "半成品结算清单";
  270. fBug.Show();
  271. doQuery();
  272. doQuery();
  273. }
  274. }
  275. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  276. {
  277. if (toolMenu == null)
  278. return;
  279. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  280. {
  281. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.True; }
  282. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; }
  283. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
  284. }
  285. else
  286. {
  287. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.False; }
  288. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.True; }
  289. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
  290. }
  291. }
  292. private void FrmGlPriceCarry_Shown(object sender, EventArgs e)
  293. {
  294. if (toolMenu == null)
  295. return;
  296. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  297. {
  298. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.True; }
  299. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.False; }
  300. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
  301. }
  302. else
  303. {
  304. if (toolMenu.Toolbars[0].Tools.Exists("doAdd")) { toolMenu.Toolbars[0].Tools["doAdd"].InstanceProps.Visible = DefaultableBoolean.False; }
  305. if (toolMenu.Toolbars[0].Tools.Exists("doDelete")) { toolMenu.Toolbars[0].Tools["doDelete"].InstanceProps.Visible = DefaultableBoolean.True; }
  306. if (toolMenu.Toolbars[0].Tools.Exists("doPrint")) { toolMenu.Toolbars[0].Tools["doPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
  307. }
  308. }
  309. }
  310. }