FrmFirmInList.cs 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279
  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 System.Collections;
  10. using CoreFS.CA06;
  11. using Core.Mes.Client.Comm.Server;
  12. using Infragistics.Win.UltraWinGrid;
  13. using Core.Mes.Client.Comm.Tool;
  14. using Core.Mes.Client.Comm.Control;
  15. namespace Core.StlMes.Client.YdmPipeManage
  16. {
  17. public partial class FrmFirmInList : FrmBase
  18. {
  19. public FrmFirmInList()
  20. {
  21. this.IsLoadUserView = true;
  22. InitializeComponent();
  23. }
  24. private void FrmFirmInList_Load(object sender, EventArgs e)
  25. {
  26. this.StartTime.Enabled = false;
  27. this.EndTime.Enabled = false;
  28. StartTime.Value = DateTime.Parse(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString());
  29. DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
  30. EndTime.Value = DateTime.Parse(d1.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + " 23:59:59");
  31. }
  32. public override void ToolBar_Click(object sender, string ToolbarKey)
  33. {
  34. switch (ToolbarKey)
  35. {
  36. case"Query":
  37. queryData();
  38. break;
  39. case"Confim":
  40. confimData();
  41. break;
  42. case"cancelComfim":
  43. cancelConfim();
  44. break;
  45. case"Export":
  46. exportData();
  47. break;
  48. case"Close":
  49. this.Close();
  50. break;
  51. }
  52. }
  53. /// <summary>
  54. /// 导出
  55. /// </summary>
  56. private void exportData()
  57. {
  58. GridHelper.ulGridToExcel(ultraGrid4, "缴库实绩");
  59. }
  60. /// <summary>
  61. /// 查询
  62. /// </summary>
  63. private void queryData()
  64. {
  65. string heatNo = "";
  66. string orderNo = "";
  67. string startTim = "";
  68. string endTim = "";
  69. ArrayList list = new ArrayList();
  70. if (ultraCheckEditor5.Checked)
  71. {
  72. startTim = StartTime.Value.ToString();
  73. endTim = EndTime.Value.ToString();
  74. }
  75. if (this.chkStove.Checked)
  76. {
  77. if (this.cmbStoveNo.Text == "")
  78. {
  79. MessageUtil.ShowTips("请选择炉号!");
  80. return;
  81. }
  82. else
  83. {
  84. heatNo = this.cmbStoveNo.Text.Trim();
  85. }
  86. }
  87. if (chkOrder.Checked)
  88. {
  89. if (this.cmbOrder.Text == "")
  90. {
  91. MessageUtil.ShowTips("请选择合同号!");
  92. return;
  93. }
  94. else
  95. {
  96. orderNo = this.cmbOrder.Text.Trim();
  97. }
  98. }
  99. string coustom = this.CustomInfo;
  100. string[] arr = getPlinCode(coustom);
  101. list.Add(heatNo);
  102. list.Add(orderNo);
  103. DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFirmInList.queryInListData", new object[] { list, arr, startTim, endTim }, this.ob);
  104. GridHelper.CopyDataToDatatable(ref dt, ref dataTable4, true);
  105. }
  106. /// <summary>
  107. /// 获取产线代码
  108. /// </summary>
  109. /// <param name="coustom"></param>
  110. /// <returns></returns>
  111. private string[] getPlinCode(string coustom)
  112. {
  113. string[] arr = null;
  114. DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFirmInList.getPline", new object[] { coustom }, ob);
  115. arr = new string[dt.Rows.Count];
  116. if(dt.Rows.Count>0)
  117. {
  118. for (int i = 0; i < dt.Rows.Count;i++ )
  119. {
  120. arr[i] = dt.Rows[i]["PLINE_CODE"].ToString();
  121. }
  122. }
  123. return arr;
  124. }
  125. /// <summary>
  126. /// 审核
  127. /// </summary>
  128. private void confimData()
  129. {
  130. this.ultraGrid4.UpdateData();
  131. int m = 0;
  132. ArrayList parm = new ArrayList();
  133. foreach(UltraGridRow row in ultraGrid4.Rows)
  134. {
  135. if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
  136. {
  137. m++;
  138. }
  139. }
  140. if (m < 1)
  141. {
  142. MessageUtil.ShowTips("请选择需要审核的数据!");
  143. return;
  144. }
  145. foreach (UltraGridRow uRow in ultraGrid4.Rows)
  146. {
  147. if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true)
  148. {
  149. ArrayList list = new ArrayList();
  150. list.Add(uRow.Cells["INSTOCK_DOC"].Value.ToString());
  151. parm.Add(list);
  152. }
  153. }
  154. CoreClientParam ccp = new CoreClientParam();
  155. ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFirmInList";
  156. ccp.MethodName = "updateAffimLog";
  157. ccp.ServerParams = new object[] { parm };
  158. ccp = ob.ExecuteNonQuery(ccp,CoreInvokeType.Internal);
  159. if (ccp.ReturnCode != -1)
  160. {
  161. if (ccp.ReturnInfo.Equals("审核成功!"))
  162. {
  163. queryData();
  164. MessageUtil.ShowTips("审核成功");
  165. }
  166. else
  167. {
  168. MessageUtil.ShowTips(ccp.ReturnInfo);
  169. }
  170. }
  171. }
  172. /// <summary>
  173. /// 取消审核
  174. /// </summary>
  175. private void cancelConfim()
  176. {
  177. this.ultraGrid4.UpdateData();
  178. int m = 0;
  179. ArrayList parm = new ArrayList();
  180. foreach (UltraGridRow row in ultraGrid4.Rows)
  181. {
  182. if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
  183. {
  184. m++;
  185. }
  186. }
  187. if (m < 1)
  188. {
  189. MessageUtil.ShowTips("请选择需要审核的数据!");
  190. return;
  191. }
  192. foreach (UltraGridRow uRow in ultraGrid4.Rows)
  193. {
  194. if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true)
  195. {
  196. ArrayList list = new ArrayList();
  197. list.Add(uRow.Cells["INSTOCK_DOC"].Value.ToString());
  198. parm.Add(list);
  199. }
  200. }
  201. CoreClientParam ccp = new CoreClientParam();
  202. ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFirmInList";
  203. ccp.MethodName = "cancelUpdateAffimLog";
  204. ccp.ServerParams = new object[] { parm };
  205. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  206. if (ccp.ReturnCode != -1)
  207. {
  208. if (ccp.ReturnInfo.Equals("反审成功!"))
  209. {
  210. queryData();
  211. MessageUtil.ShowTips("撤销成功!");
  212. }
  213. else
  214. {
  215. MessageUtil.ShowTips(ccp.ReturnInfo);
  216. }
  217. }
  218. }
  219. private void chkOrder_CheckedChanged(object sender, EventArgs e)
  220. {
  221. this.cmbOrder.Enabled = chkOrder.Checked;
  222. }
  223. private void chkStove_CheckedChanged(object sender, EventArgs e)
  224. {
  225. this.cmbStoveNo.Enabled = this.chkStove.Checked;
  226. }
  227. private void cmbOrder_KeyDown(object sender, KeyEventArgs e)
  228. {
  229. if(e.KeyValue == 13)
  230. {
  231. queryData();
  232. }
  233. }
  234. private void cmbStoveNo_KeyDown(object sender, KeyEventArgs e)
  235. {
  236. if(e.KeyValue == 13)
  237. {
  238. queryData();
  239. }
  240. }
  241. /// <summary>
  242. /// 托选
  243. /// </summary>
  244. /// <param name="sender"></param>
  245. /// <param name="e"></param>
  246. private void ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
  247. {
  248. try
  249. {
  250. ultraGrid4.UpdateData();
  251. foreach (UltraGridRow r in ultraGrid4.Rows)
  252. {
  253. r.Cells["CHK"].Value = r.Selected;
  254. }
  255. }
  256. catch { }
  257. }
  258. private void ultraCheckEditor5_CheckedChanged(object sender, EventArgs e)
  259. {
  260. StartTime.Enabled = this.ultraCheckEditor5.Checked;
  261. this.EndTime.Enabled = this.ultraCheckEditor5.Checked;
  262. }
  263. }
  264. }