using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.YdmPipeManage.Controls; using Core.StlMes.Client.YdmPipeManage.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.YdmPipeManage { public partial class FrmLoadMaterialOut : FrmBase { public FrmLoadMaterialOut() { InitializeComponent(); } private string strInbound = "800801"; private string departId = ""; private void FrmLoadMaterialOut_Load(object sender, EventArgs e) { departId = ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(ultraGrid2.DisplayLayout.Bands[0]); InitBindColumn(); } private void InitBindColumn() { //材料状态 this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150101", "材料产出等待"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150102", "材料产出(已判定)"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150103", "材料已编计划"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150104", "材料待处理"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150105", "材料加工"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150201", "材料产出等待(未综合判定)"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150202", "材料产出(已综合判定"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150203", "材料为余材(已综合判定)"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150204", "材料脱单余材(销售组织脱单)"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150301", "材料可编提单"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150302", "材料已编提单"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150303", "销售出厂"); //材料类别 this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("801401", "在制品"); this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("801402", "成品"); this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("801403", "商品"); //材料状态 this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150101", "材料产出等待"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150102", "材料产出(已判定)"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150103", "材料已编计划"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150104", "材料待处理"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150105", "材料加工"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150201", "材料产出等待(未综合判定)"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150202", "材料产出(已综合判定"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150203", "材料为余材(已综合判定)"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150204", "材料脱单余材(销售组织脱单)"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150301", "材料可编提单"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150302", "材料已编提单"); this.ultraGrid2.DisplayLayout.ValueLists[0].ValueListItems.Add("80150303", "销售出厂"); //材料类别 this.ultraGrid2.DisplayLayout.ValueLists[1].ValueListItems.Add("801401", "在制品"); this.ultraGrid2.DisplayLayout.ValueLists[1].ValueListItems.Add("801402", "成品"); this.ultraGrid2.DisplayLayout.ValueLists[1].ValueListItems.Add("801403", "商品"); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": QueryMatData(); break; case "Query1": QueryOutList(); break; case "LoadMaterial": loadMaterial(); break; case "CancleLoadMaterial": DoCancleLoadMaterial(); break; case "adjust": adjustYear(); break; case "Export": exportData(); break; case "Close": this.Close(); break; } } /// /// 查询库存实绩 /// private void QueryMatData() { string heatNo = ""; string orderNo = ""; string lotNo = ""; if(chkLotNo.Checked) { if (this.txtLotNo.Text.Trim() == "") { MessageUtil.ShowTips("请输入生产批号!"); return; } else { lotNo = this.txtLotNo.Text.Trim(); } } if (chkJudge.Checked) { if (this.cmbJudge.Text == "") { MessageUtil.ShowTips("请输入炉号!"); return; } else { heatNo = this.cmbJudge.Text.Trim(); } } if (chkOrder.Checked) { if (this.cmbOrder.Text == "") { MessageUtil.ShowTips("请输入合同号!"); return; } else { orderNo = this.cmbOrder.Text.Trim(); } } ArrayList list = new ArrayList(); list.Add(lotNo); list.Add(heatNo); list.Add(orderNo); List listSource = EntityHelper.GetData( "com.steering.pss.ydm.pipemanage.FrmLoadMaterialOut.doQueryMatData", new object[] { list, departId }, this.ob); MatZcMEntity1bindingSource.DataSource = listSource; } /// /// 查询上料出库实绩 /// private void QueryOutList() { string heatNo = ""; string orderNo = ""; string lotNo = ""; if (chkLotNo.Checked) { if (this.txtLotNo.Text.Trim() == "") { MessageUtil.ShowTips("请输入生产批号!"); return; } else { lotNo = this.txtLotNo.Text.Trim(); } } if (chkJudge.Checked) { if (this.cmbJudge.Text == "") { MessageUtil.ShowTips("请输入炉号!"); return; } else { heatNo = this.cmbJudge.Text.Trim(); } } if (chkOrder.Checked) { if (this.cmbOrder.Text == "") { MessageUtil.ShowTips("请输入合同号!"); return; } else { orderNo = this.cmbOrder.Text.Trim(); } } ArrayList list = new ArrayList(); list.Add(lotNo); list.Add(heatNo); list.Add(orderNo); List listSource = EntityHelper.GetData( "com.steering.pss.ydm.pipemanage.FrmLoadMaterialOut.doQueryOutList", new object[] { list, departId }, this.ob); YdmZcOutlistEntitybindingSource.DataSource = listSource; } /// /// 上料出库 /// private void loadMaterial() { this.ultraGrid1.UpdateData(); string strInMemo = ""; UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) { MessageUtil.ShowTips("未选中库存信息,不允许进行投料出库!"); return; } if (Math.Abs(int.Parse((uRow.Cells["ActCount"].Value.ToString2()))) == 0) { MessageUtil.ShowTips("出库支数不能为零或者空!"); return; } DataTable dtMemo = PipeManageClass.getComTypeInfo(strInbound, ob); if (dtMemo.Rows.Count >= 1) { strInMemo = dtMemo.Rows[0]["MEMO"].ToString(); } ArrayList matList = new ArrayList(); matList.Add(strInbound); matList.Add(strInMemo); matList.Add(this.UserInfo.GetUserName()); matList.Add(this.UserInfo.GetDeptid()); matList.Add(this.UserInfo.GetDepartment()); matList.Add(ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob)); matList.Add(ClsBaseInfo.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob)); MatZcMEntity1 matZcTity = (MatZcMEntity1)uRow.ListObject; string matZcEntity = JSONFormat.Format(matZcTity); if (MessageUtil.ShowYesNoAndQuestion("是否确认进行投料出库?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmLoadMaterialOut"; ccp.MethodName = "loadMaterial"; ccp.ServerParams = new object[] { matZcEntity, departId, matList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("投料出库成功!")) { QueryMatData(); QueryOutList(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 撤销上料 /// private void DoCancleLoadMaterial() { this.ultraGrid2.UpdateData(); UltraGridRow row = this.ultraGrid2.ActiveRow; if (row == null) { MessageUtil.ShowTips("未选中投料出库实绩信息,不允许进行撤销!"); return; } ArrayList list = new ArrayList(); string moth = DateTime.Parse(row.Cells["BalYearMonth"].Text).AddMonths(1).ToString("yyyyMM"); list.Add(moth); list.Add(this.UserInfo.GetUserName()); list.Add(this.UserInfo.GetDeptid()); list.Add(this.UserInfo.GetDepartment()); list.Add(ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob)); list.Add(ClsBaseInfo.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob)); YdmZcOutlistEntity ydmOutList = (YdmZcOutlistEntity)row.ListObject; string ydmOutListEntity = JSONFormat.Format(ydmOutList); if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmLoadMaterialOut"; ccp.MethodName = "cancelLoadMaterial"; ccp.ServerParams = new object[] { ydmOutListEntity, departId, list }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤消成功!")) { QueryMatData(); QueryOutList(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 调整结转年月 /// private void adjustYear() { } /// /// 导出 /// private void exportData() { GridHelper.ulGridToExcel(ultraGrid2, "上料出库实绩汇总"); } private void chkLotNo_CheckedChanged(object sender, EventArgs e) { this.txtLotNo.Enabled = this.chkLotNo.Checked; } private void chkJudge_CheckedChanged(object sender, EventArgs e) { this.cmbJudge.Enabled = this.chkJudge.Checked; } private void chkOrder_CheckedChanged(object sender, EventArgs e) { this.cmbOrder.Enabled = this.chkOrder.Checked; } } }