frmPopMatSelect.cs 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318
  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 Infragistics.Win.UltraWinGrid;
  10. using Infragistics.Win;
  11. using CoreFS.CA06;
  12. using Pur.Entity;
  13. using Core.Mes.Client.Comm.Control;
  14. using Core.Mes.Client.Comm;
  15. using Core.Mes.Client.Comm.Tool;
  16. using Pur.Entity.configureEntity;
  17. using Infragistics.Win.UltraWinTree;
  18. using Core.Mes.Client.Comm.Server;
  19. using Pur.Pop_upWindow;
  20. using com.hnshituo.pur.vo;
  21. using Pur.configure;
  22. using System.Collections;
  23. using Infragistics.Win.UltraWinToolTip;
  24. using Pur.require_plan;
  25. using Infragistics.Win.UltraWinEditors;
  26. namespace Pur.Pop_upWindow
  27. {
  28. public partial class frmPopMatSelect : FrmPmsBase
  29. {
  30. String selectType = "0";//0:全选,1:单个选
  31. private void frmPopMatSelect_Load(object sender, EventArgs e)
  32. {
  33. //初始化
  34. cmbNum.SelectedIndex = 0;
  35. GridHelper.SetExcludeColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] { "Check" });
  36. if (selectType == "1")
  37. {
  38. GridHelper.HidenColumns(ultraGrid1.DisplayLayout.Bands[0], new string[] { "Check" });
  39. }
  40. //查询物料分类树
  41. GetPUR_MAT_Class();
  42. }
  43. public frmPopMatSelect(OpeBase ob)
  44. {
  45. this.ob = ob;
  46. InitializeComponent();
  47. }
  48. public frmPopMatSelect(OpeBase ob,String strType)
  49. {
  50. this.selectType = strType;
  51. this.ob = ob;
  52. InitializeComponent();
  53. }
  54. Boolean QClickCellOrQuery = false;//是否点击查询按钮或grid数据单元格,控制是否刷新右侧物料数据,true为不刷新
  55. DataTable dt_Purmatclass = null;
  56. private string QstrItemUnique = "";
  57. UltraTreeNode qUltraNode = null;
  58. public ArrayList List_item=new ArrayList();
  59. public String selectedItemCode="";
  60. public String SelectedItemName="";
  61. public string tips="0";
  62. /// <summary>
  63. /// 查询物料分类和物料
  64. /// </summary>
  65. public void GetPUR_MAT_Class()
  66. {
  67. //查询物料分类
  68. PurmatclassEntity matclassEntity = new PurmatclassEntity();
  69. matclassEntity.Validflag="1";
  70. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.configure.service.MatClassService", "getMatClass", new object[] { matclassEntity });
  71. dt_Purmatclass = dt;
  72. getultree(dt);//绑定物料分类表
  73. //查询物料
  74. MatEntity mat = new MatEntity();
  75. mat.Validflag = "1";
  76. //物料分类
  77. if (checkBox1.Checked)
  78. {
  79. mat.UpdateName = txt_ARC_CODE.Text;
  80. }
  81. mat.ItemCode = txt_wlbm.Text;
  82. mat.DeleteName = txt_wlmc.Text;
  83. getMat(mat);
  84. }
  85. /// <summary>
  86. /// 获取物料分类树形结构
  87. /// </summary>
  88. public void getultree(DataTable dt)
  89. {
  90. ulTreeMat.Nodes.Clear();
  91. if (dt == null || dt.Rows.Count < 1)
  92. {
  93. return;
  94. }
  95. dt_Purmatclass = dt;//保存物料分类全局变量
  96. DataTable dt_A = new DataTable();//物料分类
  97. //筛选出根节点
  98. DataRow[] rows = dt.Select("PARENTCODE='' or PARENTCODE is null");
  99. dt_A = dt.Clone(); //克隆A的结构
  100. foreach (DataRow row in rows)
  101. {
  102. dt_A.ImportRow(row);//复制行数据
  103. }
  104. //添加物料大类
  105. for (int j = 0; j < dt_A.Rows.Count; j++)
  106. {
  107. UltraTreeNode Ultnode = ulTreeMat.Nodes.Add(dt_A.Rows[j]["BASECODE"].ToString(), dt_A.Rows[j]["BASENAME"].ToString());
  108. getChildNodes(Ultnode);
  109. }
  110. }
  111. /// <summary>
  112. /// 查询物料
  113. /// </summary>
  114. private void getMat(MatEntity mat)
  115. {
  116. if (mat != null)
  117. {
  118. if (cmbNum.Value != null && cmbNum.Value.ToString() != "")
  119. {
  120. mat.ItemUomConefficient = double.Parse(cmbNum.Value.ToString());
  121. }
  122. }
  123. DataTable dt_mat = this.execute<DataTable>("com.hnshituo.pur.configure.service.MatService", "getMat", new object[] { mat });
  124. dataTable1.Rows.Clear();
  125. GridHelper.CopyDataToDatatable(ref dt_mat, ref dataTable2, true);//绑定物料分类表
  126. }
  127. /// <summary>
  128. /// 递归查询父节点下的所有子节点
  129. /// </summary>
  130. /// <param name="Tnode"></param>
  131. public void getChildNodes(UltraTreeNode Tnode)
  132. {
  133. DataTable dt_A = dt_Purmatclass.Clone();//物料分类
  134. DataRow[] rows = dt_Purmatclass.Select("PARENTCODE='" + Tnode.Key + "'");
  135. foreach (DataRow row in rows)
  136. {
  137. dt_A.ImportRow(row);//复制行数据
  138. }
  139. //添加物料分类
  140. for (int j = 0; j < dt_A.Rows.Count; j++)
  141. {
  142. UltraTreeNode Ultnode = Tnode.Nodes.Add(dt_A.Rows[j]["BASECODE"].ToString(), dt_A.Rows[j]["BASENAME"].ToString());
  143. getChildNodes(Ultnode);//利用递归将当前节点的子节点添加进去
  144. }
  145. }
  146. private void ulTreeMat_AfterActivate(object sender, NodeEventArgs e)
  147. {
  148. if (!QClickCellOrQuery)//如果不是点击查询按钮或单击grig行数据,刷新右侧数据
  149. {
  150. MatEntity eMat = new MatEntity();
  151. ulTreeMat.ActiveNode.Expanded = true;
  152. qUltraNode = ulTreeMat.ActiveNode;
  153. eMat.ArcCode = qUltraNode.Key;
  154. eMat.Validflag = "1";
  155. getMat(eMat);
  156. }
  157. txt_ARC_CODE.Text = ulTreeMat.ActiveNode.Key;
  158. txt_ARC_ITEM.Text = ulTreeMat.ActiveNode.Text;
  159. }
  160. private void barsManagerButon_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  161. {
  162. switch (e.Tool.Key.ToString())
  163. {
  164. case "Query":
  165. {
  166. QClickCellOrQuery = true;
  167. GetPUR_MAT_Class();
  168. if (ultraGrid1.Rows.Count > 0)
  169. {
  170. ulTreeMat.CollapseAll();
  171. UltraTreeNode uttNode = ulTreeMat.GetNodeByKey(ultraGrid1.Rows[0].Cells["ARCCODE"].Value.ToString());
  172. ulTreeMat.ActiveNode = uttNode;
  173. if (uttNode == null)
  174. {
  175. MessageUtil.ShowTips("物料名称:" + ultraGrid1.Rows[0].Cells["ITEMNAME"].Value.ToString() + " 未找到相应的分类:" + ultraGrid1.Rows[0].Cells["ARCCODE"].Value.ToString());
  176. }
  177. else
  178. {
  179. while (ulTreeMat.ActiveNode != uttNode)
  180. {
  181. ulTreeMat.ActiveNode = uttNode;
  182. }
  183. uttNode.Expanded = true;
  184. //展开分类
  185. while (uttNode.Parent != null)
  186. {
  187. uttNode = uttNode.Parent;
  188. uttNode.Expanded = true;
  189. }
  190. }
  191. QClickCellOrQuery = false;//设置未点击
  192. }
  193. }
  194. break;
  195. case "conFirmation":
  196. {
  197. if (selectType == "1")
  198. {
  199. selectedItemCode = ultraGrid1.ActiveRow.GetCellValue("itemCode").ToString().Trim();
  200. SelectedItemName = ultraGrid1.ActiveRow.GetCellValue("itemName").ToString().Trim();
  201. tips = "1";
  202. this.Close();
  203. return;
  204. }
  205. else
  206. {
  207. ultraGrid1.UpdateData();
  208. IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where("Check = 'True' ");
  209. if (checkRows.Count() <= 0)
  210. {
  211. MessageUtil.ShowTips("请选择物料!");
  212. return;
  213. }
  214. else
  215. {
  216. foreach (UltraGridRow row in checkRows)
  217. {
  218. MatEntity mat = new MatEntity();
  219. String itemCode = row.GetCellValue("itemCode").ToString().Trim();
  220. mat.ItemCode = itemCode;
  221. String itemName = row.GetCellValue("itemName").ToString().Trim();
  222. mat.ItemName = itemName;
  223. List_item.Add(mat);
  224. }
  225. }
  226. if (List_item.Count <= 0)
  227. {
  228. MessageUtil.ShowTips("请选择物料!");
  229. return;
  230. }
  231. tips = "1";
  232. this.Close();
  233. return;
  234. }
  235. }
  236. case "ESC":
  237. {
  238. this.Close();
  239. }
  240. break;
  241. }
  242. }
  243. /// <summary>
  244. /// 激活物料
  245. /// </summary>
  246. /// <param name="sender"></param>
  247. /// <param name="e"></param>
  248. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  249. {
  250. //激活之前选中项
  251. string[] strItemUniques = QstrItemUnique.Split('@');
  252. if (QstrItemUnique != "")
  253. {
  254. QClickCellOrQuery = true;//不刷新右侧物料数据
  255. if (strItemUniques.Length == 4)
  256. {
  257. //选中属性
  258. if (strItemUniques[1].Trim() != "")
  259. {
  260. //显示所选属性
  261. strItemUniques[1] += ";";
  262. strItemUniques[1] = ";" + strItemUniques[1];
  263. }
  264. }
  265. QstrItemUnique = "";
  266. QClickCellOrQuery = false;
  267. }
  268. }
  269. /// <summary>
  270. /// 单击物料单元格
  271. /// </summary>
  272. /// <param name="sender"></param>
  273. /// <param name="e"></param>
  274. private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
  275. {
  276. UltraTreeNode uttNode = ulTreeMat.GetNodeByKey(e.Cell.Row.Cells["ARCCODE"].Value.ToString());
  277. if (ulTreeMat.ActiveNode == uttNode)
  278. {
  279. return;
  280. }
  281. ulTreeMat.CollapseAll();
  282. QClickCellOrQuery = true;
  283. ulTreeMat.ActiveNode = uttNode;
  284. if (uttNode == null)
  285. {
  286. MessageUtil.ShowTips("物料名称:" + e.Cell.Row.Cells["ITEMNAME"].Value.ToString() + " 未找到相应的分类:" + e.Cell.Row.Cells["ARCCODE"].Value.ToString());
  287. }
  288. else
  289. {
  290. while (ulTreeMat.ActiveNode != uttNode)
  291. {
  292. ulTreeMat.ActiveNode = uttNode;
  293. }
  294. uttNode.Expanded = true;
  295. //展开分类
  296. while (uttNode.Parent != null)
  297. {
  298. uttNode = uttNode.Parent;
  299. uttNode.Expanded = true;
  300. }
  301. }
  302. QClickCellOrQuery = false;//设置未点击
  303. }
  304. }
  305. }