FrmOutList.cs 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using CoreFS.CA06;
  10. using Core.StlMes.Client.YdmPipeManage.Tool;
  11. using System.Collections;
  12. using Core.StlMes.Client.YdmPipeManage.Entity;
  13. using Core.Mes.Client.Comm.Tool;
  14. using Infragistics.Win.UltraWinGrid;
  15. using Core.Mes.Client.Comm.Server;
  16. namespace Core.StlMes.Client.YdmPipeManage
  17. {
  18. public partial class FrmOutList : FrmBase
  19. {
  20. public FrmOutList()
  21. {
  22. InitializeComponent();
  23. this.IsLoadUserView = true;
  24. }
  25. private void FrmOutList_Load(object sender, EventArgs e)
  26. {
  27. //StartTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM") + "-01" + " 00:00:00");
  28. //EndTime.Value = DateTime.Parse(DateTime.Now.AddMonths(1).AddDays(1 - DateTime.Now.Day).AddHours(-24).ToString("yyyy-MM-dd") + " 23:59:59");
  29. StartTime.Value = DateTime.Parse(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString());
  30. DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
  31. EndTime.Value = DateTime.Parse(d1.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + " 23:59:59");
  32. EntityHelper.ShowGridCaption<YdmZcOutlistEntity>(ultraGrid1.DisplayLayout.Bands[0]);
  33. }
  34. public override void ToolBar_Click(object sender, string ToolbarKey)
  35. {
  36. switch (ToolbarKey)
  37. {
  38. case "Query":
  39. QueryOutLst();
  40. break;
  41. case "updateYear":
  42. updateYear();
  43. break;
  44. case "Close":
  45. this.Close();
  46. break;
  47. }
  48. }
  49. /// <summary>
  50. /// 销售出库查询
  51. /// </summary>
  52. private void QueryOutLst()
  53. {
  54. string heatNo = "";
  55. string orderNo = "";
  56. string beginTim = "";
  57. string endTim = "";
  58. string outType = "";
  59. string supplyUnit = this.CustomInfo;
  60. ArrayList parm = new ArrayList();
  61. if (ultraCheckEditor5.Checked)
  62. {
  63. beginTim = StartTime.Value.ToString();
  64. endTim = EndTime.Value.ToString();
  65. }
  66. if (chkJudge.Checked)
  67. {
  68. heatNo = this.cmbJudge.Text.Trim();
  69. }
  70. if (chkOrder.Checked)
  71. {
  72. orderNo = this.cmbOrder.Text.Trim();
  73. }
  74. if (chkOutType.Checked)
  75. {
  76. outType = this.txtOutType.Value.ToString();
  77. }
  78. string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds,ob);
  79. parm.Add(heatNo);
  80. parm.Add(orderNo);
  81. List<YdmZcOutlistEntity> listSource = EntityHelper.GetData<YdmZcOutlistEntity>(
  82. "com.steering.pss.ydm.pipemanage.FrmOutList.getOutList", new object[] { beginTim, endTim, parm, arr, outType ,supplyUnit}, this.ob);
  83. YdmZcOutlistEntitybindingSource.DataSource = listSource;
  84. }
  85. /// <summary>
  86. /// 调整结转年月
  87. /// </summary>
  88. private void updateYear()
  89. {
  90. this.ultraGrid1.UpdateData();
  91. UltraGridRow uRow = this.ultraGrid1.ActiveRow;
  92. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  93. if (checkMagRows.Count() == 0)
  94. {
  95. MessageUtil.ShowTips("请选择需要操作的数据!");
  96. return;
  97. }
  98. string yearMoth = "";
  99. string adjustDoc = "";
  100. string heatNo = "";
  101. string bacthNo = "";
  102. string bacthGroupNo = "";
  103. string carNo = "";
  104. string moth = "";
  105. string outCode = "";
  106. string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds,ob);
  107. ArrayList newParm = new ArrayList();
  108. foreach (UltraGridRow row in checkMagRows)
  109. {
  110. ArrayList list = new ArrayList();
  111. ArrayList parm = new ArrayList();
  112. yearMoth = row.Cells["balYearMonth"].Text.Substring(0, 4) + row.Cells["balYearMonth"].Text.Substring(5, 2);
  113. adjustDoc = row.Cells["OutstockDoc"].Value.ToString();
  114. heatNo = row.Cells["judgeStoveNo"].Value.ToString();
  115. bacthNo = row.Cells["batchNo"].Value.ToString();
  116. bacthGroupNo = row.Cells["batchGroudNo"].Value.ToString();
  117. carNo = row.Cells["VehicleNo"].Value.ToString();
  118. outCode = row.Cells["OutstockTypeCode"].Value.ToString();
  119. moth = DateTime.Parse(row.Cells["balYearMonth"].Text).AddMonths(1).ToString("yyyyMM");
  120. parm.Add(moth);
  121. DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeAdjust.selectYearMoth", new object[] { parm, arr,this.CustomInfo }, ob);
  122. if (int.Parse(ds.Rows[0]["ACOUNT"].ToString()) > 0)
  123. {
  124. MessageUtil.ShowTips("此炉【" + heatNo + "】已进行结转,不允许调整结转年月!");
  125. return;
  126. }
  127. list.Add(yearMoth);
  128. list.Add(yearMoth + "02 12:00:00");
  129. list.Add(adjustDoc);
  130. list.Add(heatNo);
  131. list.Add(bacthNo);
  132. list.Add(bacthGroupNo);
  133. list.Add(carNo);
  134. list.Add(outCode);
  135. newParm.Add(list);
  136. }
  137. CoreClientParam ccp = new CoreClientParam();
  138. ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmOutList";
  139. ccp.MethodName = "updateYear";
  140. ccp.ServerParams = new object[] { newParm };
  141. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  142. if (ccp.ReturnCode != -1)
  143. {
  144. if (ccp.ReturnInfo.Equals("修改成功!"))
  145. {
  146. QueryOutLst();
  147. MessageUtil.ShowTips("修改成功!");
  148. }
  149. else
  150. {
  151. MessageUtil.ShowTips(ccp.ReturnInfo);
  152. }
  153. }
  154. }
  155. private void chkJudge_CheckedChanged(object sender, EventArgs e)
  156. {
  157. cmbJudge.Enabled = this.chkJudge.Checked;
  158. }
  159. private void chkOrder_CheckedChanged(object sender, EventArgs e)
  160. {
  161. cmbOrder.Enabled = this.chkOrder.Checked;
  162. }
  163. private void cmbJudge_KeyDown(object sender, KeyEventArgs e)
  164. {
  165. if (e.KeyValue == 13)
  166. {
  167. QueryOutLst();
  168. }
  169. }
  170. private void cmbOrder_KeyDown(object sender, KeyEventArgs e)
  171. {
  172. if (e.KeyValue == 13)
  173. {
  174. QueryOutLst();
  175. }
  176. }
  177. private void chkOutType_CheckedChanged(object sender, EventArgs e)
  178. {
  179. this.txtOutType.Enabled = this.chkOutType.Checked;
  180. }
  181. private void txtOutType_KeyDown(object sender, KeyEventArgs e)
  182. {
  183. if (e.KeyValue == 13)
  184. {
  185. QueryOutLst();
  186. }
  187. }
  188. private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  189. {
  190. foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
  191. {
  192. if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
  193. {
  194. uRow.Cells["CHK"].Value = true;
  195. }
  196. }
  197. }
  198. private void ultraGrid1_KeyUp(object sender, KeyEventArgs e)
  199. {
  200. BaseMethod.setGridCopyActColumn(ultraGrid1, e, "BalYearMonth");
  201. }
  202. private void ultraCheckEditor5_CheckedChanged(object sender, EventArgs e)
  203. {
  204. StartTime.Enabled = this.ultraCheckEditor5.Checked;
  205. EndTime.Enabled = this.ultraCheckEditor5.Checked;
  206. }
  207. }
  208. }