using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.PlnSaleOrd.BaseMethod; using Core.StlMes.Client.PlnSaleOrd.Entity; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace Core.StlMes.Client.PlnSaleOrd { public partial class FrmBaseMaterialHPl : FrmBase { public bool Flag = false; private string _inMaterialNo = ""; private string _outMaterialNo = ""; private string _inMaterialDesc = ""; private string _outMaterialDesc = ""; private string _plineCode = ""; private string _proPlanId = ""; public FrmBaseMaterialHPl() { InitializeComponent(); } public FrmBaseMaterialHPl(string inMaterialNo, string outMaterialNo, string plineCode, OpeBase ob, string proPlanId) { this._inMaterialNo = inMaterialNo; this._outMaterialNo = outMaterialNo; this._plineCode = plineCode; this.ob = ob; _proPlanId = proPlanId; InitializeComponent(); this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; } private void FrmBaseMaterialHPl_Load(object sender, EventArgs e) { BaseHelper.setColumnBackColor(ultraGridJg, new string[] { "HrCapcty", "PrdRate", "DisableFl", "WasteRate", "PlineCode", "PlineLevel" }); BaseHelper.InitCellPosition(ultraGridJg, new string[] { "HrCapcty", "PrdRate", "WasteRate", "PlineLevel"}); InitMaterial(); //如果在基础镦拔扩找不到,则不执行 if (_inMaterialDesc.Equals("")) { ultraGridJg.Enabled = false; return; } Query(); } private void InitMaterial() { DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.FrmBaseMaterialHPl.getBaseMaterialH", new object[] { _inMaterialNo, _outMaterialNo }, this.ob); if (dt != null && dt.Rows.Count > 0) { _inMaterialDesc = dt.Rows[0]["IN_MATERIAL_DESC"].ToString(); _outMaterialDesc = dt.Rows[0]["OUT_MATERIAL_DESC"].ToString(); } } public void Query() { List materialFPlEntityList = EntityHelper.GetData( "com.steering.pss.plnsaleord.processOrder.FrmBaseMaterialHPl.getBaseMaterialHPl", new object[] { _inMaterialNo, _outMaterialNo }, ob); slmBaseMaterialHPlEntityBindingSource.DataSource = materialFPlEntityList; if (!_plineCode.Equals("")) { IQueryable chcRows = ultraGridJg.Rows.AsQueryable().Where(a => a.GetValue("PlineCode") == _plineCode); if (chcRows != null && chcRows.Count() != 0) { chcRows.First().Activate(); chcRows.First().Cells["CHC"].Value = true; } } } private void update() { try { ultraGridJg.UpdateData(); IQueryable chcRows = ultraGridJg.Rows.AsQueryable().Where(a => a.GetValue("CHC") == "True"); if (chcRows == null || chcRows.Count() == 0) { MessageUtil.ShowTips("请选择记录!"); return; } ArrayList param = new ArrayList(); foreach (UltraGridRow ugr in chcRows) { SlmBaseMaterialHPlEntity entity = (SlmBaseMaterialHPlEntity)ugr.ListObject; entity.UpdateName = UserInfo.GetUserName(); string jsonStr = JSONFormat.Format(entity); param.Add(jsonStr); } if (MessageUtil.ShowYesNoAndQuestion("是否修改记录?") == DialogResult.No) { return; } ServerHelper.SetData("com.steering.pss.plnsaleord.processOrder.FrmBaseMaterialHPl.updateBaseMaterialHPl", new object[] { param }, this.ob); Query(); MessageUtil.ShowTips("修改成功!"); Flag = true; } catch (Exception e) { MessageUtil.ShowTips("数据异常,请重新操作!"); } } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Query": Query(); break; case "Update": update(); break; case "UpdatePline": UpdatePline(); break; case "Close": this.Close(); break; default: break; } } /// /// 修改产线 /// private void UpdatePline() { ultraGridJg.UpdateData(); IQueryable chcRows = ultraGridJg.Rows.AsQueryable().Where(a => a.GetValue("CHC") == "True"); if (chcRows == null || chcRows.Count() == 0) { MessageUtil.ShowTips("请选择记录!"); return; } ArrayList param = new ArrayList(); int count = 0; foreach (UltraGridRow ugr in chcRows) { count++; SlmBaseMaterialHPlEntity entity = (SlmBaseMaterialHPlEntity)ugr.ListObject; entity.UpdateName = UserInfo.GetUserName(); string jsonStr = JSONFormat.Format(entity); param.Add(jsonStr); } if (count != 1) { MessageUtil.ShowTips("请选择一条记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.FrmBaseMaterialHPl"; ccp.MethodName = "updateBasePlineJgM"; ccp.ServerParams = new object[] { param, _proPlanId, UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) return; MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { Query(); Flag = true; } } private void ultraGridJg_InitializeRow(object sender, InitializeRowEventArgs e) { BaseHelper.ControlCellEdit(e.Row); } } }