FrmInlistInfo.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324
  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.Mes.Client.Comm.Tool;
  11. using Core.Mes.Client.Comm.Server;
  12. using Infragistics.Win.UltraWinGrid;
  13. using System.Collections;
  14. using Core.Mes.Client.Comm.Format;
  15. using Infragistics.Win.UltraWinEditors;
  16. using Core.Mes.Client.Comm.Control;
  17. using Infragistics.Win;
  18. namespace Core.StlMes.Client.GlBusiness.Dialog
  19. {
  20. /// <summary>
  21. /// 现货合同客户端
  22. /// </summary>
  23. public partial class FrmMatInfo : FrmBase
  24. {
  25. public FrmMatInfo()
  26. {
  27. InitializeComponent();
  28. }
  29. /// <summary>
  30. /// 构造函数
  31. /// </summary>
  32. /// <param name="_ob">OB对象</param>
  33. public FrmMatInfo(OpeBase _ob)
  34. {
  35. InitializeComponent();
  36. this.ob = _ob;
  37. }
  38. /// <summary>
  39. /// 合同头PK值
  40. /// </summary>
  41. private string ordPk;
  42. /// <summary>
  43. /// 合同头PK值
  44. /// </summary>
  45. public string OrdPk
  46. {
  47. get { return ordPk; }
  48. set { ordPk = value; }
  49. }
  50. /// <summary>
  51. /// 贸易类型
  52. /// </summary>
  53. private string tradeType;
  54. /// <summary>
  55. /// 贸易类型
  56. /// </summary>
  57. public string TradeType
  58. {
  59. get { return tradeType; }
  60. set { tradeType = value; }
  61. }
  62. private string orderNo;
  63. /// <summary>
  64. /// 合同号
  65. /// </summary>
  66. public string OrderNo
  67. {
  68. get { return orderNo; }
  69. set { orderNo = value; }
  70. }
  71. private string flag;
  72. /// <summary>
  73. /// 合同号
  74. /// </summary>
  75. public string Flag
  76. {
  77. get { return flag; }
  78. set { flag = value; }
  79. }
  80. /// <summary>
  81. /// 窗体关闭属性 默认关闭
  82. /// </summary>
  83. private string closeEvent = "formClose";
  84. /// <summary>
  85. /// 窗体关闭属性
  86. /// </summary>
  87. public string CloseEvent
  88. {
  89. get { return closeEvent; }
  90. set { closeEvent = value; }
  91. }
  92. private string createDept = "";
  93. /// <summary>
  94. /// 创建部门
  95. /// </summary>
  96. public string CreateDept
  97. {
  98. get { return createDept; }
  99. set { createDept = value; }
  100. }
  101. private string createName = "";
  102. /// <summary>
  103. /// 创建人
  104. /// </summary>
  105. public string CreateName
  106. {
  107. get { return createName; }
  108. set { createName = value; }
  109. }
  110. /// <summary>
  111. /// 重写基类load事件,屏蔽平台过滤功能。
  112. /// </summary>
  113. /// <param name="e"></param>
  114. protected override void OnLoad(EventArgs e)
  115. {
  116. base.OnLoad(e);
  117. gdMat.DisplayLayout.Override.FilterUIType = Infragistics.Win.UltraWinGrid.FilterUIType.FilterRow;
  118. gdMat.DisplayLayout.Override.FilterOperatorDefaultValue = Infragistics.Win.UltraWinGrid.FilterOperatorDefaultValue.Contains;
  119. }
  120. private void FrmMatInfo_Load(object sender, EventArgs e)
  121. {
  122. if (flag == "1")
  123. {
  124. this.ultraToolbarsManager1.Tools[1].SharedProps.Visible = false;
  125. this.ultraToolbarsManager1.Tools[2].SharedProps.Visible = false;
  126. }
  127. //默认查询当前日期-1月——当前日期数据。
  128. udtStart.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString());
  129. udtEnd.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
  130. utDelivery.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
  131. if (TradeType.Equals("122301"))
  132. {
  133. this.gdMat.DisplayLayout.Rows.Band.Columns["OUTWL_DESC"].Header.Caption = "投入物料";
  134. }
  135. ValueList list = new ValueList();
  136. ValueListItem[] items = new ValueListItem[] {
  137. new ValueListItem("0", "否"),
  138. new ValueListItem("1", "是"),
  139. };
  140. list.ValueListItems.AddRange(items);
  141. gdMat.DisplayLayout.Bands[0].Columns["PRODUCER_FL"].ValueList = list;
  142. GridHelper.SetColumnsActivateAndColor(this.gdMat.Rows.Band, "Choose");
  143. }
  144. /// <summary>
  145. /// 库存信息查询
  146. /// </summary>
  147. public void QueryMat()
  148. {
  149. string orderNoQuery = "";
  150. string proName = "";
  151. string specName = "";
  152. string orderStart = "";
  153. string orderEnd = "";
  154. //orderStart = udtStart.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
  155. //orderEnd = udtEnd.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
  156. if (chkOrderNo.Checked)
  157. orderNoQuery = txtOrderNo.Text.Trim();
  158. DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.QueryPlnOrderInfo", new Object[] { tradeType, orderNoQuery }, this.ob);
  159. GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable1, true);
  160. GridHelper.RefreshAndAutoSize(this.gdMat);
  161. }
  162. /// <summary>
  163. /// 新增现货合同行
  164. /// </summary>
  165. public void AddOrderLine()
  166. {
  167. gdMat.UpdateData();
  168. UltraGridRow[] rows = gdMat.Rows.AsQueryable().Where(a => a.Cells["Choose"].Value.ToString() == "True").ToArray();
  169. if (rows.Length <= 0)
  170. {
  171. MessageUtil.ShowWarning("请选择计划信息!");
  172. return;
  173. }
  174. ArrayList parm = new ArrayList();
  175. foreach (UltraGridRow line in rows)
  176. {
  177. ArrayList list = new ArrayList();
  178. list.Add(ordPk);
  179. list.Add("");
  180. list.Add(ordPk);
  181. list.Add("/");
  182. list.Add(line.Cells["OUTWL_DESC"].Value.ToString());
  183. list.Add(line.Cells["PRODUCCODE"].Value.ToString());
  184. list.Add(line.Cells["PRODUCNAME"].Value.ToString());
  185. list.Add(line.Cells["STD_CODE"].Value.ToString());
  186. list.Add(line.Cells["STD_NAME"].Value.ToString());
  187. list.Add(line.Cells["STEELCODE"].Value.ToString());
  188. list.Add(line.Cells["STEELNAME"].Value.ToString());
  189. list.Add(line.Cells["STD_STYLE"].Value.ToString());
  190. list.Add(line.Cells["STD_STYLE_DESC"].Value.ToString());
  191. list.Add(line.Cells["SPEC_CODE"].Value.ToString());
  192. list.Add(line.Cells["SPEC_NAME"].Value.ToString());
  193. list.Add(line.Cells["SPEC_CODE"].Value.ToString());
  194. list.Add(line.Cells["SPEC_NAME"].Value.ToString());
  195. list.Add(line.Cells["OUTDIAMETER"].Value.ToString());
  196. list.Add(line.Cells["WALLTHICK"].Value.ToString());
  197. list.Add(line.Cells["LENGTHDISC"].Value.ToString());
  198. list.Add(line.Cells["WEIGTH_S"].Value.ToString());
  199. list.Add(line.Cells["NUM_S"].Value.ToString());
  200. list.Add(UserInfo.GetUserName());
  201. list.Add("%");
  202. list.Add(numericWTMin.Value.ToString());
  203. list.Add(numericWTMin.Value.ToString());
  204. list.Add(line.Cells["PRODUCER_FL"].Value.ToString());
  205. list.Add(utDelivery.DateTime.ToShortDateString());
  206. list.Add(line.Cells["PRO_ORDER_NO"].Value.ToString());
  207. list.Add(line.Cells["PRO_PLAN_ID"].Value.ToString());
  208. list.Add(line.Cells["PLN_ORDER_NO"].Value.ToString());
  209. list.Add(line.Cells["GRADECODE"].Value.ToString());
  210. list.Add(line.Cells["GRADENAME"].Value.ToString());
  211. list.Add(line.Cells["PROD_STANDARD"].Value.ToString());
  212. list.Add(line.Cells["OUTPUT_STANDARD"].Value.ToString());
  213. list.Add(line.Cells["CRAFT_NO"].Value.ToString());
  214. parm.Add(list);
  215. }
  216. if (MessageUtil.ShowYesNoAndQuestion("是否确认新增合同行?") == DialogResult.No) return;
  217. CoreClientParam ccp = new CoreClientParam();
  218. ccp.ServerName = "com.steering.pss.glbusiness.GlOrderManage";
  219. ccp.MethodName = "addGlOrderLine";
  220. ccp.ServerParams = new object[] { parm, this.OrdPk };
  221. ccp.IfShowErrMsg = false;
  222. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  223. if (ccp != null)
  224. {
  225. if (ccp.ReturnCode == -1)
  226. {
  227. MessageUtil.ShowWarning(ccp.ReturnInfo);
  228. return;
  229. }
  230. MessageUtil.ShowTips("新增成功!");
  231. this.CloseEvent = "Add";
  232. this.Close();
  233. }
  234. }
  235. private void chkJudgeStoveNo_CheckedChanged(object sender, EventArgs e)
  236. {
  237. if (chkOrderNo.Checked)
  238. {
  239. txtOrderNo.ReadOnly = false;
  240. }
  241. else
  242. {
  243. txtOrderNo.ReadOnly = true;
  244. }
  245. }
  246. private void txtJudgeStoveNo_KeyPress(object sender, KeyPressEventArgs e)
  247. {
  248. if (e.KeyChar == 13)
  249. QueryMat();
  250. }
  251. private void txtPro_KeyPress(object sender, KeyPressEventArgs e)
  252. {
  253. if (e.KeyChar == 13)
  254. QueryMat();
  255. }
  256. private void txtSteel_KeyPress(object sender, KeyPressEventArgs e)
  257. {
  258. if (e.KeyChar == 13)
  259. QueryMat();
  260. }
  261. private void txtSpec_KeyPress(object sender, KeyPressEventArgs e)
  262. {
  263. if (e.KeyChar == 13)
  264. QueryMat();
  265. }
  266. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  267. {
  268. switch (e.Tool.Key)
  269. {
  270. case "Query":
  271. QueryMat();
  272. break;
  273. case "Add":
  274. AddOrderLine();
  275. break;
  276. case "Close":
  277. this.Close();
  278. break;
  279. case "Export":
  280. GridHelper.ulGridToExcel(gdMat, "关联交易信息");
  281. break;
  282. }
  283. }
  284. }
  285. }