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.YdmBase; using Core.StlMes.Client.YdmPipeManage.Dialog; using Core.StlMes.Client.YdmPipeManage.Entity; using Core.StlMes.Client.YdmPipeManage.Tool; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using System; 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 FrmSemiFinish : FrmBase { private PlnOrderZgSEntity plnOrdZgStity; public FrmSemiFinish() { InitializeComponent(); } private string proPlanId = "";//轧管排产订单号 private string gxPlanNo = "";//工序生产序号 private void FrmSemiFinish_Load(object sender, EventArgs e) { this.RegStartTime.Value = DateTime.Parse(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString()); DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); this.RegEndTime.Value = DateTime.Parse(d1.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + " 23:59:59"); EntityHelper.ShowGridCaption(this.ultraGrid1.DisplayLayout.Bands[0]); InitBase(); InitCloum(); } /// /// 绑定列 /// private void InitCloum() { //材料状态 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("80150106", "材料为余材"); 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("80150205", "材料缴库余材(销售组织缴库)"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150301", "材料可编提单"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150302", "材料已编提单"); this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150303", "销售出厂"); } /// /// 加载基础信息 /// private void InitBase() { YdmBaseClass.InitComboEditor(TxtStorage, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false); //BaseMethod.InitPline(TxtPline, this.ob); BaseMethod.InitProcduce(TxtProduc, this.ob);//品名 BaseMethod.InitStdStyle(TxtStdStyle, this.ob);//标准类别 BaseMethod.InitMaterial(TxtMaterial, this.ob);//物料码 BaseMethod.InitStdName(TxtStdName, this.ob);//标准 //BaseMethod.InitProducFlagCom(TxtProductFlag, this.ob); BaseMethod.InitSourse(TxtSourse, this.ob, "2010"); BaseMethod.InitMapStatusCom(TxtMagstatus, this.ob); BaseMethod.InitGrade(TxtGrade, this.ob); BaseMethod.InitSpec(TxtSpcName, this.ob); BaseMethod.InitModel(TxtModel, this.ob); this.TxtProductFlag.SelectedIndex = 0; this.TxtMagstatus.SelectedIndex = 0; //this.TxtBelongCode.SelectedIndex = 0; //this.TxtSourse.SelectedIndex = 0; if (this.CustomInfo.ToString2().Contains("120504")) { this.TxtBelongCode.SelectedIndex = 1; this.TxtPline.SelectedIndex = 2; } else { this.TxtBelongCode.SelectedIndex = 0; this.TxtPline.SelectedIndex = 0; } } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": QueryInListData(); break; case "Add": addInListData(); break; case "canceAdd": canceAddData(); break; case "Export": exportData(); break; case "Close": this.Close(); break; } } /// /// 查询外购管手工入库信息 /// private void QueryInListData() { string jugeNo = ""; string regStartTim = ""; string regEndTim = ""; if(this.chkRegTime.Checked) { regStartTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); regEndTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (this.chkFurnace.Checked) { if (this.txtFurnace.Text.Trim() == "") { MessageUtil.ShowTips("炉号不能为空!"); return; } else { jugeNo = this.txtFurnace.Text.Trim(); } } List listSource = EntityHelper.GetData( "com.steering.pss.ydm.pipemanage.FrmSemiFinish.doQueryInListWg", new object[] { regStartTim, regEndTim, jugeNo }, ob); YdmZcInlistEntitybindingSource.DataSource = listSource; } /// /// 新增外购管入库信息 /// private void addInListData() { YdmZcInlistEntity ydmEntity = GetAddData(); string errMessage = CheckData(ydmEntity); if (errMessage.Length > 0) { MessageUtil.ShowWarning(errMessage); return; } string ydmTity = JSONFormat.Format(ydmEntity); string plnOrdZgEntity = JSONFormat.Format(plnOrdZgStity); if (MessageUtil.ShowYesNoAndQuestion("是否进行手工入库?") == DialogResult.No) { return; } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmSemiFinish"; ccp.MethodName = "doAddInListData"; ccp.ServerParams = new object[] { ydmTity, plnOrdZgEntity }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("入库成功!")) { QueryInListData(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 撤销手工入库 /// private void canceAddData() { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; YdmZcInlistEntity ydmZcinListTity = (YdmZcInlistEntity)uRow.ListObject; string ydmZcEntity = JSONFormat.Format(ydmZcinListTity); if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmSemiFinish"; ccp.MethodName = "doCancelInList"; ccp.ServerParams = new object[] { ydmZcEntity }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤销成功!")) { QueryInListData(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 导出 /// private void exportData() { GridHelper.ulGridToExcel(this.ultraGrid1, "外购管手工缴库实绩"); } private YdmZcInlistEntity GetAddData() { YdmZcInlistEntity entity = new YdmZcInlistEntity(); entity.InstockTypeCode = "800701"; entity.InstockTypeName = "产出入库"; entity.LotNo = txtLotNo.Text.Trim(); entity.JudgeStoveNo = txtJudgeStoveNo.Text.Trim(); entity.StoveNo = txtStoveNo.Text.Trim() == "" ? txtJudgeStoveNo.Text.Trim() : txtStoveNo.Text.Trim(); entity.FlagStoveNoZg = txtFlagStoveNoZg.Text.Trim() == "" ? txtJudgeStoveNo.Text.Trim() : txtFlagStoveNoZg.Text.Trim(); entity.BatchNo = TxtBathNo.Text.Trim(); //entity.BatchGroudNo = "1"; entity.MaterialNo = TxtMaterial.Value == null ? "" : TxtMaterial.Value.ToString(); entity.MaterialName = TxtMaterial.Text; entity.Produccode = TxtProduc.Value == null ? "" : TxtProduc.Value.ToString(); entity.Producname = TxtProduc.Text; entity.StdCode = TxtStdName.Value == null ? "" : TxtStdName.Value.ToString(); entity.StdName = TxtStdName.Text; entity.Steelcode = TxtSteelCode.Tag == null ? "" : TxtSteelCode.Tag.ToString(); entity.Steelname = TxtSteelCode.Text; entity.StdStyle = TxtStdStyle.Value == null ? "" : TxtStdStyle.Value.ToString(); entity.StdStyleDesc = TxtStdStyle.Text; entity.SpecCode = TxtSpcName.Value == null ? "" : TxtSpcName.Value.ToString(); entity.SpecName = TxtSpcName.Text; entity.ModelCode = TxtModel.Value == null ? "" : TxtModel.Value.ToString(); entity.ModelDesc = TxtModel.Text; entity.PlineCode = TxtPline.Value == null ? "" : TxtPline.Value.ToString(); entity.PlineName = TxtPline.Text; //if (decimal.Parse(TxtSpcName.Text.Trim().ToString3()) > 0) //{ entity.ActDimater = decimal.Parse(TxtSpcName.Value == null?"0":TxtSpcName.Text.Trim().ToString3().Substring(0, TxtSpcName.Text.IndexOf("x"))); entity.ActHeight = decimal.Parse(TxtSpcName.Value == null?"0":TxtSpcName.Text.Trim().Substring(TxtSpcName.Text.IndexOf("x") + 1)); //} entity.ActLenMax = decimal.Parse(TxtMax.Value == null ? "" : TxtMax.Value.ToString()); entity.ActLenMin = decimal.Parse(TxtMin.Value == null ? "" : TxtMin.Value.ToString()); entity.ActCount = decimal.Parse(TxtNum.Text.Trim()); entity.ActWeight = decimal.Parse(TxtActWgt.Value == null ? "" : TxtActWgt.Value.ToString()); entity.ActLen = decimal.Parse(TxtActLen.Value == null ? "" : TxtActLen.Value.ToString()); //entity.ActTheoryWeight = TxtWgt.Value == null ? "" : TxtWgt.Value.ToString(); entity.BelongCode = TxtBelongCode.Value == null ? "" : TxtBelongCode.Value.ToString(); entity.BelongName = TxtBelongCode.Text; entity.StorageNo = TxtStorage.Value == null ? "" : TxtStorage.Value.ToString(); entity.StorageName = TxtStorage.Text; entity.LocationNo = TxtLocation.Value == null ? "" : TxtLocation.Value.ToString(); entity.CreateName = UserInfo.GetUserName(); entity.Memo = ultraTextEditor1.Text.Trim(); entity.MatOriginCode = TxtSourse.Value == null ? "" : TxtSourse.Value.ToString(); entity.MatOriginName = TxtSourse.Text; entity.MatStatus = TxtMagstatus.Value == null ? "" : TxtMagstatus.Value.ToString(); entity.ProductFlag = TxtProductFlag.Value == null ? "" : TxtProductFlag.Value.ToString(); entity.Gradecode = TxtGrade.Value == null?"":TxtGrade.Value.ToString(); entity.Gradename = TxtGrade.Text; entity.BalYearMonth = DateTime.Now.ToString("yyyyMM"); entity.SoureCode = TxtPline.Value == null ? "" : TxtPline.Value.ToString(); entity.SoureName = TxtPline.Text; entity.Target = txtTarget.Text; return entity; } /// /// 验证数据 /// /// private string CheckData(YdmZcInlistEntity entity) { if (this.TxtProduc.Text == "") { return "品名不能为空!"; } if (this.TxtSteelCode.Text == "") { return "钢级不能为空!"; } if (this.TxtStdName.Text == "") { return "标准名称不能为空!"; } if (this.TxtSpcName.SelectedItem == null) { return "规格不能为空!"; } if (this.TxtGrade.SelectedItem == null) { return "钢种不能为空!"; } if (this.TxtModel.SelectedItem == null) { return "扣型不能为空!"; } if (this.TxtProductFlag.Text == "") { return "材料类别不能为空!"; } if (this.TxtMagstatus.Text == "") { return "材料状态不能为空!"; } if (this.TxtMax.Text == "") { return "长度上限不能为空!"; } if (this.TxtMin.Text == "") { return "长度下限不能为空!"; } if (this.TxtSourse.Text == "") { return "材料来源不能为空!"; } if (this.TxtNum.Text.Trim() == "0") { return "支数不能为0!"; } if (this.TxtActWgt.Text.Trim() == "0.000") { return "重量不能为0!"; } if (this.TxtBelongCode.Text == "") { return "产权单位不能为空!"; } if (this.txtJudgeStoveNo.Text == "") { return "炉号不能为空!"; } if (this.TxtBathNo.Text == "") { return "批号不能为空!"; } if (this.TxtStorage.Text == "") { return "仓库名称不能为空!"; } if (this.TxtPline.Text == "") { MessageUtil.ShowTips("产线不能为空!"); return "产线不能为空!"; } return ""; } private void chkRegTime_CheckedChanged(object sender, EventArgs e) { this.RegStartTime.Enabled = this.RegEndTime.Enabled = this.chkRegTime.Checked; } private void chkFurnace_CheckedChanged(object sender, EventArgs e) { this.txtFurnace.Enabled = this.chkFurnace.Checked; } private void TxtProductFlag_ValueChanged(object sender, EventArgs e) { string flag = ""; if (this.TxtProductFlag.Value.ToString() == "801401") { flag = "801501"; } else if (this.TxtProductFlag.Value.ToString() == "801402") { flag = "801502"; } else if (this.TxtProductFlag.Value.ToString() == "801403") { flag = "801503"; } BaseMethod.InitMapStatusCom(TxtMagstatus, ob, flag); } private void button1_Click(object sender, EventArgs e) { FrmPlnOrdZgS frmMaterialDialog = new FrmPlnOrdZgS(this.ob); frmMaterialDialog.ShowDialog(); PlnOrderZgSEntity pscEntity = frmMaterialDialog.PlnOrderZgTity; if (pscEntity == null) { return; } TxtMaterial.Tag = pscEntity.OutwlId.ToString(); TxtMaterial.Text = pscEntity.OutwlDesc.ToString(); TxtSteelCode.Tag = pscEntity.Steelcode.ToString(); TxtSteelCode.Text = pscEntity.Steelname.ToString(); this.TxtGrade.Tag = pscEntity.Gradecode.ToString(); TxtGrade.Text = pscEntity.Gradename.ToString(); TxtProduc.Tag = pscEntity.Produccode.ToString2(); TxtProduc.Text = pscEntity.Producname.ToString2(); TxtStdStyle.Tag = pscEntity.StdStyle.ToString(); TxtStdStyle.Text = pscEntity.StdStyleDesc.ToString(); TxtSpcName.Tag = pscEntity.SpecCode.ToString(); TxtSpcName.Text = pscEntity.SpecName.ToString(); TxtModel.Tag = pscEntity.ModelCode.ToString(); TxtModel.Text = pscEntity.ModelDesc.ToString(); TxtStdName.Tag = pscEntity.StdCode.ToString(); TxtStdName.Text = pscEntity.StdName.ToString(); TxtPline.Tag = pscEntity.PlineCode.ToString(); TxtPline.Text = pscEntity.PlineName.ToString(); txtTarget.Text = pscEntity.Decision.ToString(); //proPlanId = pscEntity.ProPlanId.ToString(); //gxPlanNo = pscEntity.GxPlanNo.ToString(); plnOrdZgStity = pscEntity; } private void TxtPline_ValueChanged(object sender, EventArgs e) { if (this.TxtPline.Value.ToString() == "C065") { this.txtTarget.Text = "B"; } else if (this.TxtPline.Value.ToString() == "C066") { this.txtTarget.Text = "C"; } else if (this.TxtPline.Value.ToString() == "C098") { this.TxtBelongCode.Value = "002023005"; this.txtTarget.Text = "B"; } else if (this.TxtPline.Value.ToString() == "C099") { this.TxtBelongCode.Value = "002023005"; this.txtTarget.Text = "C"; } } private void txtTarget_ValueChanged(object sender, EventArgs e) { if (this.txtTarget.Value.ToString2() == "B") { this.TxtPline.Value = "002001001".Equals(this.TxtBelongCode.Value.ToString2()) ? "C065" : "C098"; } else if (this.txtTarget.Value.ToString2() == "C") { this.TxtPline.Value = "002001001".Equals(this.TxtBelongCode.Value.ToString2()) ? "C066" : "C099"; } } private void TxtStorage_ValueChanged(object sender, EventArgs e) { DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.CoreLocationDefine.doQuery", new Object[] { false, TxtStorage.SelectedItem.DataValue }, this.ob); if (dt != null && dt.Rows.Count > 0) { if (false) { Object[] obj = new Object[] { "", "" }; DataRow dr = dt.NewRow(); dr.ItemArray = obj; dt.Rows.InsertAt(dr, 0); } TxtLocation.DataSource = dt; TxtLocation.ValueMember = "LOCATION_NO"; TxtLocation.DisplayMember = "LOCATION_NAME"; YdmBaseClass.SetComboItemHeight(TxtLocation); } } } }