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; using Infragistics.Win.UltraWinEditors; 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 FrmFinishAfrim : FrmBase { public FrmFinishAfrim() { this.IsLoadUserView = true; InitializeComponent(); } UltraComboEditor uceFinished = new UltraComboEditor(); private void FrmFinishAfrim_Load(object sender, EventArgs e) { DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 this.cmbDate.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.cmbEndDate.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); this.dtSatrtTim.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.dtEndTim.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); this.changeStartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); this.changeEndTim.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); dtBathYear.Value = DateTime.Parse(DateTime.Today.ToString("yyyy-MM")); YdmBaseClass.InitComboEditor(cmbStorage, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false); YdmBaseClass.InitComboEditor(cmbStorageStr, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false); YdmBaseClass.BindColumn(cmbStorageStr, "STORAGE_NO", this.Controls, this.ultraGrid4, 0); YdmBaseClass.InitComboEditor(uceFinished, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getFinishedProduct", "BASECODE", this.ob, false); YdmBaseClass.BindColumn(uceFinished, "FINISHPRO_MOLD", this.Controls, this.ultraGrid4, 0); EntityHelper.ShowGridCaption(this.ultraGrid1.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(this.ultraGrid2.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(this.ultraGrid3.DisplayLayout.Bands[0]); EntityHelper.ShowGridCaption(this.ultraGrid5.DisplayLayout.Bands[0]); EntityHelper.setColumnShowOrHidden(this.ultraGrid3, new string[] { "OrderType", "ProcessDesc", "ProcessCdoe" }, false); InitBindColumn(); } private void InitBindColumn() { //材料状态 this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150101", "材料产出等待"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150102", "材料管理封锁"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150103", "材料质量封锁"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150104", "材料可编计划"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150105", "材料已编计划"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150106", "材料为余材"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150201", "材料产出等待(未综合判定)"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150202", "材料产出(已综合判定"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150203", "材料为余材(已综合判定)"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150204", "材料脱单余材(销售组织脱单)"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150205", "材料缴库余材(销售组织缴库)"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150301", "材料可编提单"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150302", "材料已编提单"); this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150303", "销售出厂"); //string[] arr = new string[3] { "801501", "801502", "801503" }; //DataTable dt = ClsLoad.GetValueListDataTable(arr, this.ob); //this.ultraGrid2.DisplayLayout.Bands[0].Columns["MAT_STATUS"].ValueList = ClsLoad.GeneralValuelist(ref dt, "BASECODE", "BASENAME"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801701", "非计划入"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801702", "无合同"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801703", "按计划入"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801704", "钢管退货"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801705", "压库"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801706", "合同长尺"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801707", "合同短尺"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802201", "超合同量"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802202", "合同长尺"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802203", "合同短尺"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802204", "生产压库"); this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802205", "合同正尺"); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQueryJudge(); break; case"QueryInList": doQueryInList(); break; case "Query2": QueryPipedData(); break; case"QueryChange": doQueryChangeData(); break; case "DoFrim": doFrim1(); break; case "updateCarryOverDate": updateCarryOverDate(); break; case "canceDoFrim": canceDoFrim(); break; case "updateMemo": updatePipMemo(); break; case "updateFinishedProduct": updateFinishedProduct(); break; case "updateStoreNo": updateStoreNo(); break; case "adjustStoreButress": adjustStoreButress(); break; case "getRealTimeStore": //getRealTimeStore(); break; case"updateBelong": updateBelong(); break; case"ChangePass": changePass(); break; case"changeNoPass": changeNoPass(); break; case "Export": Export(); break; case "QRJSH": doQRJSH(); break; case "QXJSH": doQXJSH(); break; case "Close": this.Close(); break; } } /// /// 确认接收 /// private void doQRJSH() { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; QcmZgJugdeApplyEntity entity = (QcmZgJugdeApplyEntity)uRow.ListObject; string qcmEntity = JSONFormat.Format(entity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "doQRJSH"; ccp.ServerParams = new object[] { qcmEntity, UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("确认接收成功!")) { doQueryJudge(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 取消接收 /// private void doQXJSH() { this.ultraGrid1.UpdateData(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; if (uRow == null) return; QcmZgJugdeApplyEntity entity = (QcmZgJugdeApplyEntity)uRow.ListObject; string qcmEntity = JSONFormat.Format(entity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "doQXJSH"; ccp.ServerParams = new object[] { qcmEntity, UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("取消接收成功!")) { doQueryJudge(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 审批通过 /// private void changePass() { this.ultraGrid5.UpdateData(); UltraGridRow uRow = this.ultraGrid5.ActiveRow; if (uRow == null) return; YdmZcChangebelongEntity ydmTity = (YdmZcChangebelongEntity)uRow.ListObject; string ydmEntity = JSONFormat.Format(ydmTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "changePass"; ccp.ServerParams = new object[] { ydmEntity, UserInfo.GetUserName(),this.CustomInfo }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("审批成功!")) { doQueryChangeData(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// ///审批不通过 /// private void changeNoPass() { this.ultraGrid5.UpdateData(); UltraGridRow uRow = this.ultraGrid5.ActiveRow; if (uRow == null) return; YdmZcChangebelongEntity ydmTity = (YdmZcChangebelongEntity)uRow.ListObject; string ydmEntity = JSONFormat.Format(ydmTity); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "changeNoPass"; ccp.ServerParams = new object[] { ydmEntity,UserInfo.GetUserName() }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("审批成功!")) { doQueryChangeData(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 转移所属权 /// private void updateBelong() { this.ultraGrid4.UpdateData(); int m = 0; foreach (UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { m++; } } if (m < 1) { MessageUtil.ShowTips("请选择需要操作的数据!"); return; } if (this.ultraBelong.Value.ToString2() == "") { MessageUtil.ShowTips("转移所属权时请指定所属权单位!"); return; } ArrayList parmList = new ArrayList(); foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { if (uRow.Cells["PRODUCT_FLAG"].Value.ToString() == "商品") { MessageUtil.ShowTips("商品不允许进行所属权转移!"); return; } ArrayList list = new ArrayList(); list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim()); list.Add(uRow.Cells["BATCH_NO"].Text.Trim()); list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim()); list.Add(uRow.Cells["UNIT"].Text.Trim()); list.Add(uRow.Cells["BELONG_CODE"].Text); list.Add(uRow.Cells["BELONG_NAME"].Text); list.Add(uRow.Cells["PRODUCT_FLAG"].Text); parmList.Add(list); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "updateBelong"; ccp.ServerParams = new object[] { parmList, UserInfo.GetUserName(), this.ultraBelong.Value.ToString2(), this.ultraBelong.Text.ToString2(),this.CustomInfo }; ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("转移成功!")) { QueryPipedData(); } } } /// /// 撇支调整位置 /// private void adjustStoreButress() { ultraGrid4.UpdateData(); int n = 0; int m = -1; ArrayList list = new ArrayList(); string heatNo = ""; foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { heatNo = uRow.Cells["JUDGE_STOVE_NO"].Value.ToString(); list.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString()); list.Add(uRow.Cells["BATCH_NO"].Value.ToString()); list.Add(uRow.Cells["BATCH_GROUD_NO"].Value.ToString()); if (uRow.Cells["PRODUCT_FLAG"].Value.ToString().Equals("商品")) { list.Add("801403"); } else { list.Add("801402"); } list.Add(uRow.Cells["ORDER_NO"].Value.ToString()); list.Add(uRow.Cells["ORDER_SEQ"].Value.ToString()); list.Add(uRow.Cells["ORDER_SEQ_NO"].Value.ToString()); list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString()); list.Add(uRow.Cells["MAT_STATUS"].Value.ToString()); n++; m = uRow.Index; } } if (n < 1) { MessageUtil.ShowTips("请选择主信息进行批量调整位置!"); return; } if (n > 1) { MessageUtil.ShowTips("批量调整位置不允许多条调整库存位置!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否批量修改选择数据的库存位置?") == DialogResult.No) { return; } DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipupdateStoreButress.selectMatStu", new object[] { list }, ob); if (int.Parse(dt.Rows[0]["ACOUNT"].ToString()) > 0) { MessageUtil.ShowTips("此炉【" + heatNo + "】物料状态有改变,不允许调整位置!"); return; } DataTable ds = new DataTable(); ds.Clear(); ds = dataTable2.Clone(); ds.ImportRow(dataTable2.Rows[m]); frmPipeMoveStoreButress moveButress = new frmPipeMoveStoreButress(this.ob); moveButress.Dt = ds; moveButress.ShowDialog(); if (moveButress.buttonValue == "1") { QueryPipedData(); MessageUtil.ShowTips("修改成功!"); } } /// /// 修改库存位置 /// private void updateStoreNo() { ultraGrid4.UpdateData(); ArrayList parmList = new ArrayList(); string userName = UserInfo.GetUserName(); int m = 0; int n = 0; foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { if (uRow.Cells["STORAGE_NO"].Text.Trim() == "") { n++; } m++; } } if (m < 1) { MessageUtil.ShowTips("请选择需要操作的数据!"); return; } if (n > 0) { MessageUtil.ShowTips("仓库名称不能为空!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的数据?") == DialogResult.No) { return; } foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { if (uRow.Cells["MAT_STATUS"].Value.ToString() != "80150301" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150202" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150203" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150204" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150205") { MessageUtil.ShowTips("材料状态已被改变,不允许修改库存地点!"); return; } ArrayList list = new ArrayList(); list.Add(uRow.Cells["STORAGE_NO"].Value.ToString()); //list.Add(uceReson.Value.ToString()); list.Add(uRow.Cells["ORDER_NO"].Text.Trim()); list.Add(uRow.Cells["ORDER_SEQ"].Text.Trim()); list.Add(uRow.Cells["ORDER_SEQ_NO"].Text.Trim()); list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim()); list.Add(uRow.Cells["BATCH_NO"].Text.Trim()); list.Add(uRow.Cells["PRODUCNAME"].Text.Trim()); //list.Add(uRow.Cells["STD_NAME"].Text.Trim()); list.Add(uRow.Cells["STEELNAME"].Text.Trim()); list.Add(uRow.Cells["SPEC_NAME"].Text.Trim()); list.Add(uRow.Cells["MODEL_DESC"].Text.Trim()); list.Add(userName); list.Add(uRow.Cells["ACT_LEN_MIN"].Text.Trim()); list.Add(uRow.Cells["ACT_LEN_MAX"].Text.Trim()); list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim()); if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品") { list.Add("801403"); } else if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "成品") { list.Add("801402"); } else { list.Add("801401"); } list.Add(uRow.Cells["IN_MOLD"].Value.ToString2()); list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString2()); list.Add(uRow.Cells["UNIT"].Value.ToString2()); parmList.Add(list); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "updateStoreNo"; ccp.ServerParams = new object[] { parmList }; ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { QueryPipedData(); } } } private void Export() { if (ultraTabControl1.SelectedTab.Key == "0") { GridHelper.ulGridToExcel(ultraGrid1, "判定数据"); } else if (ultraTabControl1.SelectedTab.Key == "2") { GridHelper.ulGridToExcel(ultraGrid4, "库存实绩明细"); } else if(ultraTabControl1.SelectedTab.Key == "1") { GridHelper.ulGridToExcel(ultraGrid3, "缴库实绩明细"); } else if (ultraTabControl1.SelectedTab.Key == "3") { GridHelper.ulGridToExcel(ultraGrid5, "转移所属权明细"); } } /// /// 修改产品区分 /// private void updateFinishedProduct() { ultraGrid4.UpdateData(); ArrayList parmList = new ArrayList(); string userName = UserInfo.GetUserName(); int m = 0; foreach (UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { m++; } } if (m < 1) { MessageUtil.ShowTips("请选择需要操作的数据!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的数据?") == DialogResult.No) { return; } foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品") { MessageUtil.ShowTips("材料类别为商品的,不允许修改成品区分!"); return; } ArrayList list = new ArrayList(); list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim()); list.Add(uRow.Cells["BATCH_NO"].Text.Trim()); list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim()); if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品") { list.Add("801403"); } else if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "成品") { list.Add("801402"); } else { list.Add("801401"); } list.Add(uRow.Cells["PIPMEMO"].Value.ToString()); list.Add(uRow.Cells["IN_MOLD"].Value.ToString()); list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString2()); parmList.Add(list); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "updateFinishedProduct"; ccp.ServerParams = new object[] { parmList }; ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { QueryPipedData(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 修改入库备注 /// private void updatePipMemo() { ultraGrid4.UpdateData(); ArrayList parmList = new ArrayList(); string userName = UserInfo.GetUserName(); int m = 0; foreach (UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { m++; } } if (m < 1) { MessageUtil.ShowTips("请选择需要操作的数据!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的数据?") == DialogResult.No) { return; } foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows) { if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true) { if (uRow.Cells["MAT_STATUS"].Value.ToString() != "80150301" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150202" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150203" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150204" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150205") { MessageUtil.ShowTips("材料状态已被改变,不允许修改入库备注!"); return; } ArrayList list = new ArrayList(); list.Add(uRow.Cells["PIPMEMO"].Value.ToString()); //list.Add(uceReson.Value.ToString()); list.Add(uRow.Cells["ORDER_NO"].Text.Trim()); list.Add(uRow.Cells["ORDER_SEQ"].Text.Trim()); list.Add(uRow.Cells["ORDER_SEQ_NO"].Text.Trim()); list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim()); list.Add(uRow.Cells["BATCH_NO"].Text.Trim()); list.Add(uRow.Cells["PRODUCNAME"].Text.Trim()); //list.Add(uRow.Cells["STD_NAME"].Text.Trim()); list.Add(uRow.Cells["STEELNAME"].Text.Trim()); list.Add(uRow.Cells["SPEC_NAME"].Text.Trim()); list.Add(uRow.Cells["MODEL_DESC"].Text.Trim()); list.Add(userName); list.Add(uRow.Cells["ACT_LEN_MIN"].Text.Trim()); list.Add(uRow.Cells["ACT_LEN_MAX"].Text.Trim()); list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim()); if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品") { list.Add("801403"); } else if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "成品") { list.Add("801402"); } else { list.Add("801401"); } list.Add(uRow.Cells["IN_MOLD"].Value.ToString2()); list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString2()); list.Add(uRow.Cells["UNIT"].Text.ToString2()); parmList.Add(list); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "updatePipMemo"; ccp.ServerParams = new object[] { parmList }; ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) { QueryPipedData(); } } } /// /// 查询库存信息 /// private void QueryPipedData() { ArrayList pram = new ArrayList(); string intimeStart = ""; //缴库起始时间 string intimeEnd = ""; //缴库结束时间 string stoveno = ""; //炉号 string order = ""; string supplyUnit = this.CustomInfo; if (ultraCheckEditor5.Checked) { intimeStart = StartTime.Value.ToString(); intimeEnd = EndTime.Value.ToString(); } if (chkJudge.Checked) { if (cmbJudge.Text.Trim() == "") { MessageUtil.ShowTips("炉号不能为空,请选择!"); return; } stoveno = cmbJudge.Text.Trim(); } if (chkOrder.Checked) { if (cmbOrder.Text.Trim() == "") { MessageUtil.ShowTips("合同号不能为空,请选择!"); return; } order = cmbOrder.Text.Trim(); } if (DateTime.Parse(StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString())) { MessageUtil.ShowTips("开始时间不能大于结束时间!"); return; } pram.Add(stoveno); pram.Add(order); string userName = UserInfo.GetUserName(); string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.queryMat", new object[] { pram, arr, intimeStart, intimeEnd, supplyUnit}, this.ob);//MatData GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true); if (toolMenu == null) { return; } if (toolMenu.Toolbars[0].Tools.Exists("updateMemo") && supplyUnit.Equals("120504")) { this.ultraGrid4.DisplayLayout.Bands[0].Columns["UNIT"].EditorComponent = this.chkMatNo; } } /// /// 获取实时库存 /// private void getRealTimeStore() { string time = DateTime.Now.ToString("dd"); string bathYear = DateTime.Now.AddMonths(1).ToString("yyyyMM"); string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob); //if (!time.Equals("26")) //{ // MessageUtil.ShowTips("此按钮只允许每月26号进行操作!"); // return; //} DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.selectNowInial", new object[] { arr, bathYear }, ob); if (int.Parse(ds.Rows[0][0].ToString()) > 0) { } else { MessageUtil.ShowTips("无本月期初数据,不允许获取期初库存!"); return; } int count = ServerHelper.SetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.getRealTimeStore", new object[] { arr, bathYear,this.CustomInfo }, ob); if (count > 0) { MessageUtil.ShowTips("获取实时期末库存成功!"); } } /// /// 查询未审批数据 /// private void doQueryChangeData() { string jugeNo = ""; string startTim = ""; string endTim = ""; string valueFlag = ""; if (this.changeJudgeChk.Checked && this.changeJudgeTxt.Text.Trim() != "") { jugeNo = this.changeJudgeTxt.Text.Trim(); } if (this.changeTimChk.Checked) { if (DateTime.Parse(this.changeStartTime.Value.ToString()) > DateTime.Parse(this.changeEndTim.Value.ToString())) { MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!"); return; } else { startTim = this.changeStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.changeEndTim.Value.ToString("yyyy-MM-dd HH:mm:ss"); } } valueFlag = this.ultraOptionSet2.CheckedItem.DataValue.ToString(); string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob); ArrayList list = new ArrayList(); list.Add(jugeNo); List listSource = EntityHelper.GetData( "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryChangeData", new object[] { list, startTim, endTim, valueFlag, arr }, this.ob); ydmZcChangebelongEntityBindingSource.DataSource = listSource; } /// /// 查询判定信息 /// private void doQueryJudge() { string jugeNo = ""; string startTim = ""; string endTim = ""; string valueFlag = ""; string orderNo = ""; string supplyUnit = this.CustomInfo; if (this.chkJudgeStoveNo.Checked && this.uteJudgeStoveNo.Text.Trim() != "") { jugeNo = this.uteJudgeStoveNo.Text.Trim(); } if (this.chkOrderNo1.Checked && this.chkOrderNo1.Text.Trim() != "") { orderNo = this.uteOrderNo.Text.Trim(); } if (this.chkDate.Checked) { if (DateTime.Parse(cmbDate.Value.ToString()) > DateTime.Parse(this.cmbEndDate.Value.ToString())) { MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!"); return; } else { startTim = this.cmbDate.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.cmbEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss"); } } valueFlag = this.ultraOptionSet1.CheckedItem.DataValue.ToString(); string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob); ArrayList list = new ArrayList(); list.Add(jugeNo); PlnSaleordEntitybindingSource.Clear(); List listSource = EntityHelper.GetData( "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryApplyJudge", new object[] { list, startTim, endTim, valueFlag, arr, supplyUnit, orderNo }, this.ob); QcmZgJugdeApplyEntitybindingSource.DataSource = listSource; } /// /// 查询缴库实绩 /// private void doQueryInList() { string heatNo = ""; string orderNo = ""; string startTim = ""; string endTim = ""; string bathYear = ""; string supplyUnit = this.CustomInfo; ArrayList list = new ArrayList(); if (this.chkTim.Checked) { startTim = this.dtSatrtTim.Value.ToString("yyyy-MM-dd"); endTim = this.dtEndTim.Value.ToString("yyyy-MM-dd"); } if (this.chkJudgeNo1.Checked) { if (this.txtJudgeNo1.Text == "") { MessageUtil.ShowTips("请输入判定炉号!"); return; } else { heatNo = this.txtJudgeNo1.Text.Trim(); } } if (chkOrderNo.Checked) { if (this.txtOrderNo.Text == "") { MessageUtil.ShowTips("请输入合同号!"); return; } else { orderNo = this.txtOrderNo.Text.Trim(); } } if (chkBathYear.Checked) { bathYear = this.dtBathYear.Value.ToString("yyyyMM"); } list.Add(heatNo); list.Add(orderNo); list.Add(bathYear); string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob); List listSource = EntityHelper.GetData( "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryInList", new object[] { list, startTim, endTim, arr, supplyUnit}, this.ob); ydmZcInlistEntityBindingSource.DataSource = listSource; } /// /// 确认 /// private void doFrim() { this.ultraGrid1.UpdateData(); this.ultraGrid2.UpdateData(); string orderUnit = "";//长度单位 double dbOrderMax = 0;//合同订货量上限 double reckonWgt = 0;//估算量上限 string gSwgt = "";//合同估算总量 string pipSwgt = "";//合同缴库总量 string dSwgt = "";//订货总量 double strWgt = 0;//炉重 double endWgt = 0;//已缴库量 double orderWgt = 0;//合同量 string buttonValue = "";//返回的按钮值 string frmcount = "";//返回的支数 string frmWgt = "";//返回的重量值 string[] wgtList = new string[3]; string frmFinishedCode = ""; string finishproMold = "";//成品区分 string orderType = ""; string storageNo = ""; //string storageNo = this.cmbStorage.Value.ToString2(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; UltraGridRow orderRow = this.ultraGrid2.ActiveRow; if (uRow == null) { return; } if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("B") && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" || uRow.Cells["InStorageFlag"].Text.ToString2() == "")) { if (MessageUtil.ShowYesNoAndQuestion("成品判定为合同超量,是否继续缴库?") == DialogResult.No) { return; } } if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("C") && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" || uRow.Cells["InStorageFlag"].Text.ToString2() == "")) { if (MessageUtil.ShowYesNoAndQuestion("成品判定为非正尺超量,是否继续缴库?") == DialogResult.No) { return; } } //if (storageNo == "") //{ // MessageUtil.ShowTips("请选择缴库仓库!"); // return; //} strWgt = double.Parse(uRow.Cells["ActWeight"].Text.ToString()); QcmZgJugdeApplyEntity qcmZgEntity = (QcmZgJugdeApplyEntity)uRow.ListObject; if (orderRow != null) { orderType = doQueryOrderType(orderRow.Cells["OrderNo"].Text.Trim()); //if (orderType.Equals("120103")) //{ // MessageUtil.ShowTips("该合同为研发合同,不允许缴库!"); // return; //} //else if (orderType.Equals("120104")) //{ // MessageUtil.ShowTips("该合同为预排合同,只允许缴库成成品!"); // return; //} orderUnit = orderRow.Cells["OrderUnit"].Text.Trim(); endWgt = double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3());// 已缴库量 orderWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()); string strRANGE_MIN = orderRow.Cells["DelvryRangeMin"].Text.Trim();//交货量差下限 string strRANGE_MAX = orderRow.Cells["DelvryRangeMax"].Text.Trim();//交货量差上限 double dbQtyMin = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) - double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MIN) / 100);//合同行下限值 double dbQtyMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//合同行上限值 double dbJhMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//交货量差上限值 if (orderUnit.Contains("支") || orderUnit.Equals("吨")) { dbOrderMax = double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100); } else if (orderUnit.Contains("磅")) { dbOrderMax = Math.Round(double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 * (double.Parse(strRANGE_MAX) / 100), 3); } wgtList = getOrderWgt(orderRow.Cells["OrderNo"].Text.ToString()); if (wgtList.Length > 0) { gSwgt = wgtList[0]; pipSwgt = wgtList[1]; dSwgt = wgtList[2]; } if (orderUnit.Equals("吨") || orderUnit.Equals("支") || orderUnit.Contains("磅")) { if (endWgt > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No) { return; } frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); if (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0) { frm.SxWgt = "0"; } else { frm.SxWgt = (dbQtyMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); } frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { if ((strWgt + endWgt) > dbOrderMax) { frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); frm.SxWgt = (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { frmcount = qcmZgEntity.ActCount.ToString2(); } } } else if (orderUnit.Equals("英尺") || orderUnit.Equals("米")) { if (orderRow.Cells["Orderweight"].Value.ToString() == "") { MessageUtil.ShowTips("此合同【" + uRow.Cells["ProOrderNo"].Text + "】是以英尺为交货单位!,估算量为空不能缴库!"); return; } reckonWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) * (double.Parse(strRANGE_MAX) / 100);//估算量上限 if (endWgt > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No) { return; } frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); if (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0) { frm.SxWgt = "0"; } else { frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); } frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { if ((strWgt + endWgt) > reckonWgt) { frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { frmcount = qcmZgEntity.ActCount.ToString2(); } } } if (buttonValue == "1") { finishproMold = "801703"; frmcount = qcmZgEntity.ActCount.ToString3(); } else if (buttonValue == "2") { finishproMold = "801701"; } } else { frmcount = "-1"; } string qcmEntity = JSONFormat.Format(qcmZgEntity); PlnSaleordEntity plnSaleEntity = new PlnSaleordEntity(); if (orderRow != null) { plnSaleEntity = (PlnSaleordEntity)orderRow.ListObject; } string plnOrderEntity = JSONFormat.Format(plnSaleEntity); if (this.CustomInfo.Equals("120501") && !qcmZgEntity.ProOrderNo.StartsWith(plnSaleEntity.OrderNo)) { MessageUtil.ShowTips("生产合同与缴库合同不一致,无法缴库!"); return; } ArrayList parmList = new ArrayList(); parmList.Add(storageNo);//仓库号 parmList.Add(finishproMold);//入库区分 parmList.Add(this.txt_Ks.Value.ToString2());//捆数 parmList.Add(this.txtMemo.Text);//入库备注 parmList.Add(this.UserInfo.GetUserName()); parmList.Add(this.UserInfo.GetDeptid()); parmList.Add(this.UserInfo.GetDepartment()); parmList.Add(ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob)); parmList.Add(ClsBaseInfo.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob)); parmList.Add(frmcount.ToString3()); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "doFrim"; ccp.ServerParams = new object[] { qcmEntity, plnOrderEntity, parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("缴库成功!")) { doQueryJudge(); this.txt_Ks.Value = "0"; MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } private void doFrim1() { this.ultraGrid1.UpdateData(); this.ultraGrid2.UpdateData(); string orderUnit = "";//长度单位 double dbOrderMax = 0;//合同订货量上限 double reckonWgt = 0;//估算量上限 string gSwgt = "";//合同估算总量 string pipSwgt = "";//合同缴库总量 string dSwgt = "";//订货总量 double strWgt = 0;//炉重 double endWgt = 0;//已缴库量 double orderWgt = 0;//合同量 string buttonValue = "";//返回的按钮值 string frmcount = "";//返回的支数 string frmWgt = "";//返回的重量值 string[] wgtList = new string[3]; string frmFinishedCode = ""; string finishproMold = "";//成品区分 string orderType = ""; string storageNo = ""; //string storageNo = this.cmbStorage.Value.ToString2(); UltraGridRow uRow = this.ultraGrid1.ActiveRow; UltraGridRow orderRow = this.ultraGrid2.ActiveRow; if (uRow == null) { return; } if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("B") && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" || uRow.Cells["InStorageFlag"].Text.ToString2() == "")) { if (MessageUtil.ShowYesNoAndQuestion("成品判定为合同超量,是否继续缴库?") == DialogResult.No) { return; } } if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("C") && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" || uRow.Cells["InStorageFlag"].Text.ToString2() == "")) { if (MessageUtil.ShowYesNoAndQuestion("成品判定为非正尺超量,是否继续缴库?") == DialogResult.No) { return; } } //if (storageNo == "") //{ // MessageUtil.ShowTips("请选择缴库仓库!"); // return; //} strWgt = double.Parse(uRow.Cells["ActWeight"].Text.ToString()); QcmZgJugdeApplyEntity qcmZgEntity = (QcmZgJugdeApplyEntity)uRow.ListObject; if (orderRow != null) { orderType = doQueryOrderType(orderRow.Cells["OrderNo"].Text.Trim()); //if (orderType.Equals("120103")) //{ // MessageUtil.ShowTips("该合同为研发合同,不允许缴库!"); // return; //} //else if (orderType.Equals("120104")) //{ // MessageUtil.ShowTips("该合同为预排合同,只允许缴库成成品!"); // return; //} orderUnit = orderRow.Cells["OrderUnit"].Text.Trim(); endWgt = double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3());// 已缴库量 orderWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3());// 估算量 string strRANGE_MIN = orderRow.Cells["DelvryRangeMin"].Text.Trim();//交货量差下限 string strRANGE_MAX = orderRow.Cells["DelvryRangeMax"].Text.Trim();//交货量差上限 double dbQtyMin = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) - double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MIN) / 100);//合同行下限值 double dbQtyMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//合同行上限值 double dbJhMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//交货量差上限值 string strSHRT_LEN_RATO = orderRow.Cells["ShrtLenRato"].Text.Trim().ToString3();//短尺率 string strLONG_LEN_RATO = orderRow.Cells["LongLenRato"].Text.Trim().ToString3();//长尺率 double dbShrtLenRato = orderWgt * (double.Parse(strSHRT_LEN_RATO) / 100);//短尺上限 double dbLongLenRato = orderWgt * (double.Parse(strLONG_LEN_RATO) / 100);//长尺上限 string shortest = orderRow.Cells["SHORTEST"].Text.Trim().ToString2();//短尺最短 string longest = orderRow.Cells["LONGEST"].Text.Trim().ToString2();//长尺最长 bool normalRuler = true; // 是否按正常尺缴库 if (double.Parse(orderRow.Cells["lengthmax"].Value.ToString3()) - double.Parse(uRow.Cells["ActLenMax"].Text.ToString3()) > 2 || double.Parse(uRow.Cells["ActLenMax"].Text.ToString3()) - double.Parse(orderRow.Cells["lengthmax"].Value.ToString3()) > 2 || double.Parse(orderRow.Cells["lengthmin"].Value.ToString3()) - double.Parse(uRow.Cells["ActLenMin"].Text.ToString3()) > 2 || double.Parse(uRow.Cells["ActLenMin"].Text.ToString3()) - double.Parse(orderRow.Cells["lengthmin"].Value.ToString3()) > 2) { if (MessageUtil.ShowYesNoAndQuestion("长度差值大于2,是否按正常尺继续缴库?") == DialogResult.No) { normalRuler = true; } else { txtMemo.Text = ""; normalRuler = false; } } if (uRow.Cells["InLengthType"].Text.ToString2().Equals("短尺") || uRow.Cells["InLengthType"].Text.ToString2().Equals("长尺") && normalRuler) { bool flag = false; if (!string.IsNullOrEmpty(shortest) && double.Parse(uRow.Cells["ActLenMax"].Text.ToString3()) <= double.Parse(shortest.ToString3())) { flag = true; if (MessageUtil.ShowYesNoAndQuestion("此合同行长度小于短尺最短,是否继续缴库?") == DialogResult.No) { return; } } if (!string.IsNullOrEmpty(longest) && double.Parse(uRow.Cells["ActLenMin"].Text.ToString3()) >= double.Parse(longest.ToString3())) { flag = true; if (MessageUtil.ShowYesNoAndQuestion("此合同行长度大于长尺最长,是否继续缴库?") == DialogResult.No) { return; } } if (orderUnit.Contains("支") || orderUnit.Equals("吨")) { dbOrderMax = double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100); } else if (orderUnit.Contains("磅")) { dbOrderMax = Math.Round(double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 * (double.Parse(strRANGE_MAX) / 100), 3); } if (endWgt > dbOrderMax) { frmcount = "-3"; if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No) { return; } frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); if (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0) { frm.SxWgt = "0"; } else { frm.SxWgt = (dbQtyMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); } frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } finishproMold = "801701"; if (buttonValue == "1") { if ((strWgt + endWgt) > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } frmcount = qcmZgEntity.ActCount.ToString3(); } } else if (double.Parse(strSHRT_LEN_RATO) <= 0 && double.Parse(strLONG_LEN_RATO) <= 0) { frmcount = "-2"; } else { frmcount = qcmZgEntity.ActCount.ToString3(); } if (double.Parse(strSHRT_LEN_RATO) <= 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("短尺")) { frmcount = "-2"; if (MessageUtil.ShowYesNoAndQuestion("此合同行短尺率为零,是否继续缴库?") == DialogResult.No) { return; } } if (double.Parse(strLONG_LEN_RATO) <= 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("长尺")) { frmcount = "-2"; if (MessageUtil.ShowYesNoAndQuestion("此合同行长尺率为零,是否继续缴库?") == DialogResult.No) { return; } } if (!flag && finishproMold != "801701" && double.Parse(strSHRT_LEN_RATO) > 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("短尺")) { endWgt = double.Parse(orderRow.Cells["Paydownweightshort"].Value.ToString()); dbOrderMax = dbShrtLenRato; if (strWgt + endWgt > dbShrtLenRato) { if (MessageUtil.ShowYesNoAndQuestion("此合同行短尺缴库量已超出短尺率上限,是否继续缴库?") == DialogResult.No) { return; } frmBatchesPip frm = new frmBatchesPip(ob,"2"); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); if (dbShrtLenRato - endWgt < 0) { frm.SxWgt = "0"; } else { frm.SxWgt = (dbShrtLenRato - endWgt).ToString(); } frm.PipWgt = orderRow.Cells["Paydownweightshort"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } } } else if (!flag && finishproMold != "801701" && double.Parse(strLONG_LEN_RATO) > 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("长尺")) { endWgt = double.Parse(orderRow.Cells["Paydownweightlong"].Value.ToString()); dbOrderMax = dbShrtLenRato; if (strWgt + endWgt > dbShrtLenRato) { if (MessageUtil.ShowYesNoAndQuestion("此合同行长尺缴库量已超出长尺率上限,是否继续缴库?") == DialogResult.No) { return; } frmBatchesPip frm = new frmBatchesPip(ob,"2"); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); if (dbShrtLenRato - endWgt < 0) { frm.SxWgt = "0"; } else { frm.SxWgt = (dbShrtLenRato - endWgt).ToString(); } frm.PipWgt = orderRow.Cells["Paydownweightlong"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } } } if (flag) { frmcount = "-1"; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行量差上线,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } frmcount = qcmZgEntity.ActCount.ToString3(); } } else { if (orderUnit.Contains("支") || orderUnit.Equals("吨")) { dbOrderMax = double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100); } else if (orderUnit.Contains("磅")) { dbOrderMax = Math.Round(double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 * (double.Parse(strRANGE_MAX) / 100), 3); } wgtList = getOrderWgt(orderRow.Cells["OrderNo"].Text.ToString()); if (wgtList.Length > 0) { gSwgt = wgtList[0]; pipSwgt = wgtList[1]; dSwgt = wgtList[2]; } if (orderUnit.Equals("吨") || orderUnit.Equals("支") || orderUnit.Contains("磅")) { if (endWgt > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No) { return; } frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); if (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0) { frm.SxWgt = "0"; } else { frm.SxWgt = (dbQtyMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); } frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { if ((strWgt + endWgt) > dbOrderMax) { frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); frm.SxWgt = (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > dbOrderMax) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { frmcount = qcmZgEntity.ActCount.ToString2(); } } } else if (orderUnit.Equals("英尺") || orderUnit.Equals("米")) { if (orderRow.Cells["Orderweight"].Value.ToString() == "") { MessageUtil.ShowTips("此合同【" + uRow.Cells["ProOrderNo"].Text + "】是以英尺为交货单位!,估算量为空不能缴库!"); return; } reckonWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) * (double.Parse(strRANGE_MAX) / 100);//估算量上限 if (endWgt > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No) { return; } frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); if (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0) { frm.SxWgt = "0"; } else { frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); } frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { if ((strWgt + endWgt) > reckonWgt) { frmBatchesPip frm = new frmBatchesPip(ob); frm.AllCount = uRow.Cells["ActCount"].Text.Trim(); frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim(); frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString(); frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3(); frm.ShowDialog(); buttonValue = frm.buttonValue; frmcount = frm.count; frmWgt = frm.outWgt; frmFinishedCode = frm.finishedProduct; if (!frm.flag) { return; } if (buttonValue == "0") { return; } if (buttonValue == "2") { if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim())) { MessageUtil.ShowTips("分批缴库支数不能大于现有支数!"); return; } if (double.Parse(frmWgt) + endWgt > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } if (buttonValue == "1") { if ((strWgt + endWgt) > reckonWgt) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No) { return; } } if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt)) { if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No) { return; } } } } else { frmcount = qcmZgEntity.ActCount.ToString2(); } } } if (buttonValue == "1") { finishproMold = "801703"; frmcount = qcmZgEntity.ActCount.ToString3(); } else if (buttonValue == "2") { finishproMold = "801701"; } } } else { frmcount = "-1"; } string qcmEntity = JSONFormat.Format(qcmZgEntity); PlnSaleordEntity plnSaleEntity = new PlnSaleordEntity(); if (orderRow != null) { plnSaleEntity = (PlnSaleordEntity)orderRow.ListObject; } string plnOrderEntity = JSONFormat.Format(plnSaleEntity); if (this.CustomInfo.Equals("120501") && !qcmZgEntity.ProOrderNo.StartsWith(plnSaleEntity.OrderNo)) { MessageUtil.ShowTips("生产合同与缴库合同不一致,无法缴库!"); return; } ArrayList parmList = new ArrayList(); parmList.Add(storageNo);//仓库号 parmList.Add(finishproMold);//入库区分 parmList.Add(this.txt_Ks.Value.ToString2());//捆数 parmList.Add(this.txtMemo.Text);//入库备注 parmList.Add(this.UserInfo.GetUserName()); parmList.Add(this.UserInfo.GetDeptid()); parmList.Add(this.UserInfo.GetDepartment()); parmList.Add(ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob)); parmList.Add(ClsBaseInfo.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob)); parmList.Add(frmcount.ToString3()); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "doFrim"; ccp.ServerParams = new object[] { qcmEntity, plnOrderEntity, parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("缴库成功!")) { doQueryJudge(); this.txt_Ks.Value = "0"; MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 查询合同类型 /// /// /// private string doQueryOrderType(string orderNo) { string orderType = ""; //判断合同类型 DataTable orderDs = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeInTemp.doQueryOrderType", new object[] { orderNo }, ob); if (orderDs.Rows.Count > 0) { orderType = orderDs.Rows[0]["ORDER_TYP"].ToString(); } return orderType; } /// /// 获取合同总量、已缴库总量、估算总量 /// /// /// private string[] getOrderWgt(string orderNo) { string[] str = new string[3]; DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.getOrderWgt", new object[] { orderNo }, this.ob); if (dt.Rows.Count > 0) { str[0] = dt.Rows[0]["ORDERWEIGHT"].ToString();//估算量 str[1] = dt.Rows[0]["PAYDOWNWEIGHT"].ToString();//已缴库量 str[2] = dt.Rows[0]["ORDER_QTY"].ToString();//订货量 } return str; } /// /// 调整结转年月 /// private void updateCarryOverDate() { this.ultraGrid3.UpdateData(); string moth = ""; string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob); IQueryable checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要调整结转年月的信息!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { YdmZcInlistEntity ydmEntity = (YdmZcInlistEntity)row.ListObject; moth = DateTime.Parse(row.Cells["BalYearMonth"].Text).AddMonths(1).ToString("yyyyMM"); ydmEntity.BalYearMonth = row.Cells["BalYearMonth"].Text.Substring(0, 4) + row.Cells["BalYearMonth"].Text.Substring(5, 2); ydmEntity.InstockTime = row.Cells["BalYearMonth"].Text.Substring(0, 4) +"-"+ row.Cells["BalYearMonth"].Text.Substring(4, 2) + "-02 12:00:00"; ArrayList _list = new ArrayList(); _list.Add(moth); DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeAdjust.selectYearMoth", new object[] { _list, arr,this.CustomInfo }, ob); if (int.Parse(ds.Rows[0]["ACOUNT"].ToString()) > 0) { MessageUtil.ShowTips("此炉" + ydmEntity.JudgeStoveNo + "已进行结转,不允许调整结转年月!"); return; } string ydmInListEntity = JSONFormat.Format(ydmEntity); parmList.Add(ydmInListEntity); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "updateCarryOverDate"; ccp.ServerParams = new object[] { parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("调整成功!")) { doQueryInList(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 取消确认 /// private void canceDoFrim() { this.ultraGrid3.UpdateData(); string moth = ""; string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds,ob); IQueryable checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要撤销缴库的信息!"); return; } ArrayList parmList = new ArrayList(); foreach (UltraGridRow row in checkMagRows) { YdmZcInlistEntity ydmEntity = (YdmZcInlistEntity)row.ListObject; //DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeInTemp.queryMatNoStatus", new object[] { ydmEntity.OrderNo, ydmEntity.OrderSeq, ydmEntity.DeliveryNo, ydmEntity.JudgeStoveNo, ydmEntity.BatchNo, ydmEntity.BatchGroudNo,ydmEntity.InstockDoc }, this.ob); //if (ds.Rows.Count == 0) //{ // MessageUtil.ShowTips("此炉批组已发运,不允许撤销!"); // return; //} //else if (ds.Rows.Count == 1) //{ // if (ds.Rows[0].ToString().Equals("80150302")) // { // MessageUtil.ShowWarning("该炉批组的数据不是可编提单状态,无法撤销!"); // return; // } //} //else if (ds.Rows.Count > 1) //{ // for (int i = 0; i < ds.Rows.Count;i++ ) // { // if (ds.Rows[i].ToString().Equals("80150302")) // { // MessageUtil.ShowWarning("该炉批组的数据不是可编提单状态,无法撤销!"); // return; // } // } //} DataTable dd = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeInTemp.getLockFlag", new object[] { ydmEntity.JudgeStoveNo, ydmEntity.BatchNo, ydmEntity.BatchGroudNo }, ob); if (int.Parse(dd.Rows[0]["ACOUNT"].ToString()) > 0) { MessageUtil.ShowTips("炉号:" + ydmEntity.JudgeStoveNo + "、批号:" + ydmEntity.BatchNo + "的数据有被封锁的,不能撤销!"); return; } ArrayList parm = new ArrayList(); moth = DateTime.Parse(ydmEntity.BalYearMonth).AddMonths(1).ToString("yyyyMM"); parm.Add(moth); DataTable dg = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeAdjust.selectYearMoth", new object[] { parm, arr,this.CustomInfo }, ob); if (int.Parse(dg.Rows[0]["ACOUNT"].ToString()) > 0) { MessageUtil.ShowTips("此炉【" + row.Cells["JudgeStoveNo"].Text + "】已进行结转,不允许撤销!"); return; } string ydmZcInList = JSONFormat.Format(ydmEntity); parmList.Add(ydmZcInList); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim"; ccp.MethodName = "canceDoFrim"; ccp.ServerParams = new object[] { parmList }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("撤销成功!")) { doQueryInList(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } private void chkDate_CheckedChanged(object sender, EventArgs e) { this.cmbDate.Enabled = this.cmbEndDate.Enabled = this.chkDate.Checked; } private void chkJudgeStoveNo_CheckedChanged(object sender, EventArgs e) { this.uteJudgeStoveNo.Enabled = this.chkJudgeStoveNo.Checked; } private void chkOrderNo1_CheckedChanged(object sender, EventArgs e) { this.uteOrderNo.Enabled = this.chkOrderNo1.Checked; } private void chkBathYear_CheckedChanged(object sender, EventArgs e) { this.dtBathYear.Enabled = this.chkBathYear.Checked; } private void chkJudgeNo1_CheckedChanged(object sender, EventArgs e) { this.txtJudgeNo1.Enabled = this.chkJudgeNo1.Checked; } private void chkOrderNo_CheckedChanged(object sender, EventArgs e) { this.txtOrderNo.Enabled = this.chkOrderNo.Checked; } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { UltraGridRow uRow = ultraGrid1.ActiveRow; if (uRow == null) return; if (uRow.Cells["InLengthType"].Value.ToString() == "长尺") { txtMemo.Text = "合同长尺"; }else if (uRow.Cells["InLengthType"].Value.ToString() == "短尺") { txtMemo.Text = "合同短尺"; } else { txtMemo.Text = ""; } getOrderNo(uRow); } private void getOrderNo(UltraGridRow ugr) { string orderSeq = ""; string orderNm = ugr.Cells["ProOrderNo"].Text.Trim(); string orderDivePk = ugr.Cells["OrdLnDlyPk"].Text.Trim(); string orderPk = ""; if (orderNm != "") { if (!orderNm.Contains("/")) { MessageUtil.ShowTips("此判定数据合同号异常,不允许缴库!"); return; } int i = orderNm.IndexOf("/"); if (i == -1) return; orderSeq = orderNm.Substring(i + 1, orderNm.Length - i - 1).PadLeft(3, '0'); orderNm = orderNm.Substring(0, i); if (!string.IsNullOrWhiteSpace(orderDivePk)) { orderPk = orderDivePk.Substring(0, orderDivePk.Length - 3); } } else { orderPk = ""; //MessageUtil.ShowTips("判定数据合同号为空!,数据异常!"); //return; } List listSource = EntityHelper.GetData( "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryOrderNo", new object[] { orderNm, orderSeq, orderPk }, this.ob); PlnSaleordEntitybindingSource.DataSource = listSource; } private void FrmFinishAfrim_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("QueryInList")) { toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim")) { toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate")) { toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Query2")) { toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateMemo")) { toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct")) { toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo")) { toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress")) { toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateBelong")) { toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryChange")) { toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ChangePass")) { toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass")) { toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False; } ultraLabel2.Visible = false; ultraBelong.Visible = false; } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (ultraTabControl1.SelectedTab.Key == "0") { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DoFrim")) { toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QRJSH")) { toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QXJSH")) { toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryInList")) { toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim")) { toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate")) { toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Query2")) { toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateMemo")) { toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct")) { toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore")) { toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo")) { toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress")) { toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateBelong")) { toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryChange")) { toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ChangePass")) { toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass")) { toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False; } ultraLabel2.Visible = false; ultraBelong.Visible = false; } else if (ultraTabControl1.SelectedTab.Key == "1") { if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoFrim")) { toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryInList")) { toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim")) { toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate")) { toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Query2")) { toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateMemo")) { toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct")) { toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore")) { toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo")) { toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress")) { toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateBelong")) { toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryChange")) { toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ChangePass")) { toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass")) { toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QRJSH")) { toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QXJSH")) { toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.False; } ultraLabel2.Visible = false; ultraBelong.Visible = false; } else if (ultraTabControl1.SelectedTab.Key == "2") { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoFrim")) { toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryInList")) { toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim")) { toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate")) { toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Query2")) { toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("updateMemo")) { toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct")) { toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore")) { toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo")) { toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress")) { toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("updateBelong")) { toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QueryChange")) { toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("ChangePass")) { toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass")) { toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QRJSH")) { toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QXJSH")) { toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.False; } ultraLabel2.Visible = true; ultraBelong.Visible = true; } else if (ultraTabControl1.SelectedTab.Key == "3") { if (toolMenu == null) return; if (toolMenu.Toolbars[0].Tools.Exists("Query")) { toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DoFrim")) { toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryInList")) { toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim")) { toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate")) { toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Query2")) { toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateMemo")) { toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct")) { toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore")) { toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo")) { toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress")) { toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("updateBelong")) { toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QueryChange")) { toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("ChangePass")) { toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass")) { toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("QRJSH")) { toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("QXJSH")) { toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.False; } ultraLabel2.Visible = false; ultraBelong.Visible = false; } } private void ultraGrid3_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid3.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHK"].Value = true; } } } private void uteJudgeStoveNo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 13) { doQueryJudge(); } } private void ultraCheckEditor5_CheckedChanged(object sender, EventArgs e) { this.StartTime.Enabled = this.EndTime.Enabled = this.ultraCheckEditor5.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; } private void txtJudgeNo1_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 13) { doQueryInList(); } } private void txtOrderNo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 13) { doQueryInList(); } } private void cmbJudge_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 13) { QueryPipedData(); } } private void cmbOrder_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 13) { QueryPipedData(); } } private void ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { foreach (UltraGridRow uRow in ultraGrid4.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHOOSE"].Value = true; } } } private void changeJudgeChk_CheckedChanged(object sender, EventArgs e) { this.changeJudgeTxt.Enabled = this.changeJudgeChk.Checked; } private void changeTimChk_CheckedChanged(object sender, EventArgs e) { this.changeStartTime.Enabled = this.changeEndTim.Enabled = this.changeTimChk.Checked; } private void chkMatNo_EditorButtonClick(object sender, EditorButtonEventArgs e) { UltraGridRow row = this.ultraGrid4.ActiveRow; if (row == null) { return; } if (row.Cells["MAT_STATUS"].Value.ToString() != "80150301" && row.Cells["MAT_STATUS"].Value.ToString() != "80150202" && row.Cells["MAT_STATUS"].Value.ToString() != "80150203" && row.Cells["MAT_STATUS"].Value.ToString() != "80150204" && row.Cells["MAT_STATUS"].Value.ToString() != "80150205") { MessageUtil.ShowTips("材料状态已被改变,不允许修改入库备注!"); return; } ArrayList list = new ArrayList(); list.Add(row.Cells["JUDGE_STOVE_NO"].Text.Trim()); list.Add(row.Cells["BATCH_NO"].Text.Trim()); list.Add(row.Cells["PRODUCNAME"].Text.Trim()); list.Add(row.Cells["STEELNAME"].Text.Trim()); list.Add(row.Cells["SPEC_NAME"].Text.Trim()); list.Add(row.Cells["MODEL_DESC"].Text.Trim()); list.Add(row.Cells["BATCH_GROUD_NO"].Text.Trim()); if (row.Cells["PRODUCT_FLAG"].Text.Trim() == "商品") { list.Add("801403"); } else if (row.Cells["PRODUCT_FLAG"].Text.Trim() == "成品") { list.Add("801402"); } else { list.Add("801401"); } list.Add(row.Cells["IN_MOLD"].Value.ToString2()); list.Add(row.Cells["FINISHPRO_MOLD"].Value.ToString2()); FrmMatNo frm = new FrmMatNo(list, ob); frm.ShowDialog(); QueryPipedData(); } } }