orderManage.cs 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194
  1. using Core.StlMes.Client.GlBusiness.Dialog;
  2. using CoreFS.CA06;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.ComponentModel;
  6. using System.Data;
  7. using System.Drawing;
  8. using System.Linq;
  9. using System.Text;
  10. using System.Threading.Tasks;
  11. using System.Windows.Forms;
  12. using System.Collections;
  13. using Core.Mes.Client.Comm.Tool;
  14. using Core.Mes.Client.Comm.Server;
  15. using Core.Mes.Client.Comm.Control;
  16. using Infragistics.Win.UltraWinGrid;
  17. namespace Core.StlMes.Client.GlBusiness
  18. {
  19. public partial class orderManage : FrmBase
  20. {
  21. public orderManage()
  22. {
  23. InitializeComponent();
  24. }
  25. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  26. {
  27. switch (e.Tool.Key)
  28. {
  29. case "Query":
  30. doQuery();
  31. break;
  32. case "doConfirm":
  33. doConfirm();
  34. break;
  35. case "Close":
  36. this.Close();
  37. break;
  38. }
  39. }
  40. private string setCreateTimeStart(Object value)
  41. {
  42. DateTime time = Convert.ToDateTime(value);
  43. DateTime endtime = new DateTime(time.Year, time.Month, time.Day, 0, 0, 0);
  44. endtime.ToLongTimeString();
  45. return endtime.ToString();
  46. }
  47. private string setCreateTimeEnd(Object value)
  48. {
  49. DateTime time = Convert.ToDateTime(value);
  50. DateTime endtime = new DateTime(time.Year, time.Month, time.Day, 23, 59, 59);
  51. return endtime.ToString();
  52. }
  53. private void doQuery()
  54. {
  55. this.orderHead.Clear();
  56. ArrayList parm = new ArrayList();
  57. if (uchkOrderNo.Checked == true) {
  58. parm.Add(utxtOrderNo.Text.Trim());
  59. }
  60. if (uchkDate.Checked == true) {
  61. if (QcreateTime_Begin.Value != null)//创建开始时间
  62. {
  63. parm.Add(setCreateTimeStart(QcreateTime_Begin.Value));
  64. }
  65. if (QcreateTime_End.Value != null)//创建结束时间
  66. {
  67. parm.Add(setCreateTimeEnd(QcreateTime_End.Value));
  68. }
  69. }
  70. DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.SlmGlAccrued.doQueryOrderHead", new Object[] { parm }, this.ob);
  71. GridHelper.CopyDataToDatatable(ref dt, ref this.orderHead, true);
  72. }
  73. private void doConfirm()
  74. {
  75. try
  76. {
  77. if (ultraGrid1.ActiveRow == null)
  78. {
  79. MessageUtil.ShowTips("请选择需要增加的数据!");
  80. return;
  81. }
  82. if (MessageUtil.ShowYesNoAndQuestion("是否确定添加?") == DialogResult.No)
  83. {
  84. return;
  85. }
  86. ArrayList all = new ArrayList();
  87. all.Add("BLyyyyMMdd00001");//结算单号
  88. all.Add(ultraGrid1.ActiveRow.Cells["ORDER_NO"].Value.ToString());//合同号
  89. all.Add(ultraGrid1.ActiveRow.Cells["ORDER_TYP"].Value.ToString());//合同类型编码
  90. all.Add(ultraGrid1.ActiveRow.Cells["ORDER_TYP_DESC"].Value.ToString());//合同类型
  91. if (ultraGrid1.ActiveRow.Cells["TRADE_TYPE"].Value.ToString().Equals("122301"))
  92. {
  93. all.Add("123401");//结算类型编码
  94. all.Add("应收");//结算类型
  95. }
  96. else if(ultraGrid1.ActiveRow.Cells["TRADE_TYPE"].Value.ToString().Equals("122302")){
  97. all.Add("123402");//结算类型编码
  98. all.Add("应付");//结算类型
  99. }
  100. all.Add("123301");//费用类型编码
  101. all.Add("货款");//费用类型
  102. all.Add("0");//支付状态
  103. //all.Add();//票据号
  104. all.Add(ultraGrid1.ActiveRow.Cells["CUSTOMER_NO"].Value.ToString());//订货单位编码
  105. all.Add(ultraGrid1.ActiveRow.Cells["CUSTOMER_NM"].Value.ToString());//订货单位
  106. all.Add(ultraGrid1.ActiveRow.Cells["SUPPLY_UNIT"].Value.ToString());//供货单位(制造商)
  107. all.Add(ultraGrid1.ActiveRow.Cells["STLMT_UNIT_NO"].Value.ToString());//结算单位编码
  108. all.Add(ultraGrid1.ActiveRow.Cells["STLMT_UNIT_NM"].Value.ToString());//结算单位
  109. all.Add(ultraGrid1.ActiveRow.Cells["SIGN_DATE"].Value.ToString());//签订日期
  110. all.Add(ultraGrid1.ActiveRow.Cells["ORDER_YEAR"].Value.ToString());//合同年度
  111. all.Add(ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString());//备注
  112. all.Add("1");//数据状态
  113. all.Add(UserInfo.GetUserName());
  114. all.Add(UserInfo.GetDepartment());
  115. double price = 0;
  116. double sumPrice = 0;
  117. foreach (UltraGridRow ugr in ultraGrid2.Rows)
  118. {
  119. Double.TryParse(ugr.Cells["BALNCE_TOL_PRICE"].Value.ToString().Trim(), out price);
  120. sumPrice += price;
  121. }
  122. all.Add(sumPrice);//结算总金额
  123. //all.Add();//多发票号
  124. CoreClientParam ccp = new CoreClientParam();
  125. ccp.ServerName = "com.steering.pss.glbusiness.SlmGlAccrued";
  126. ccp.MethodName = "addBalance";
  127. ccp.ServerParams = new object[] { all };
  128. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  129. if (ccp.ReturnCode == -1) return;
  130. MessageBox.Show("增加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  131. this.Close();
  132. }
  133. catch (System.Exception ex)
  134. {
  135. MessageUtil.ShowTips("操作失败:" + ex.Message);
  136. }
  137. }
  138. private void uchkOrderNo_CheckedChanged(object sender, EventArgs e)
  139. {
  140. if (uchkOrderNo.Checked == true)
  141. {
  142. utxtOrderNo.ReadOnly = false;
  143. }
  144. else {
  145. utxtOrderNo.ReadOnly = true;
  146. }
  147. }
  148. private void uchkDate_CheckedChanged(object sender, EventArgs e)
  149. {
  150. if (uchkDate.Checked == true)
  151. {
  152. QcreateTime_Begin.ReadOnly = false;
  153. QcreateTime_End.ReadOnly = false;
  154. }
  155. else
  156. {
  157. QcreateTime_Begin.ReadOnly = true;
  158. QcreateTime_End.ReadOnly = true;
  159. }
  160. }
  161. private void orderManage_Load(object sender, EventArgs e)
  162. {
  163. QcreateTime_Begin.Value = DateTime.Now.AddDays(-7);
  164. QcreateTime_End.Value = DateTime.Now;
  165. GridHelper.SetAllColumnsActive(ultraGrid1);
  166. GridHelper.SetAllColumnsActive(ultraGrid2);
  167. }
  168. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  169. {
  170. this.orderLine.Clear();
  171. ArrayList parm = new ArrayList();
  172. parm.Add(ultraGrid1.ActiveRow.Cells["ORD_PK"].Value.ToString());
  173. DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.SlmGlAccrued.doQueryOrderLine", new Object[] { parm }, this.ob);
  174. GridHelper.CopyDataToDatatable(ref dt, ref this.orderLine, true);
  175. }
  176. }
  177. }