| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977 |
- 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.YdmBcPipeManage.Entity;
- 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.YdmBcPipeManage
- {
- public partial class FrmDeleteMatBcM : FrmBase
- {
- public FrmDeleteMatBcM()
- {
-
- InitializeComponent();
- this.IsLoadUserView = true;
- }
- private void FrmDeleteMatBcM_Load(object sender, EventArgs e)
- {
- DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
- this.StartTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM"));
- EntityHelper.ShowGridCaption<MatBcMEntity1>(ultraGrid1.DisplayLayout.Bands[0]);
- EntityHelper.ShowGridCaption<YdmBcScrapoutlistEntity>(ultraGrid2.DisplayLayout.Bands[0]);
- EntityHelper.ShowGridCaption<YdmBcOutlistEntity>(ultraGrid3.DisplayLayout.Bands[0]);
- initStorageNo();
- initReasonInfo();
- initPline();
- initBelong();
- EntityHelper.setColumnShowOrHidden(ultraGrid1, new string[] { "Reason", "DelvryEdate" }, false);//显示列
- }
- DataTable reasonDT = null;
- /// <summary>
- /// 加载所属权
- /// </summary>
- private void initBelong()
- {
- DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryBelong", new object[] { }, ob);
- if (ds.Rows.Count > 0)
- {
- this.cmbBelong.DataSource = ds;
- cmbBelong.DisplayMember = "BELONG_NAME";
- cmbBelong.ValueMember = "BELONG_CODE";
- }
- }
- /// <summary>
- /// 加载产线
- /// </summary>
- private void initPline()
- {
- DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doPline", new object[] { }, ob);
- if (ds.Rows.Count > 0)
- {
- this.cheBelongCode.DataSource = ds;
- cheBelongCode.DisplayMember = "PLINE_NAME";
- cheBelongCode.ValueMember = "PLINE_CODE";
- }
- }
- /// <summary>
- /// 加载仓库
- /// </summary>
- private void initStorageNo()
- {
- BaseMethod.InitStorageNo(cmbStorageNo, ob);
- BaseMethod.InitStorageNo(cmbLoadStorage, ob);
- DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryDepartM", new object[] { }, ob);
- if (ds.Rows.Count > 0)
- {
- this.cmbDepartMent.DataSource = ds;
- cmbDepartMent.DisplayMember = "DEPARTMENT_NAME_P";
- cmbDepartMent.ValueMember = "DEPARTMENT_CODE_P";
- }
- }
- /// <summary>
- /// 离线原因
- /// </summary>
- private void initReasonInfo()
- {
- reasonDT = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryReason", new object[] { }, ob);
- if (reasonDT.Rows.Count > 0)
- {
- this.cheReason.DataSource = reasonDT;
- cheReason.DisplayMember = "REASON_NAME3";
- cheReason.ValueMember = "REASON_CODE3";
- }
- }
- /// <summary>
- /// 重写基类方法
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="ToolbarKey"></param>
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- switch (ToolbarKey)
- {
- case "DoQuery":
- doQuery();
- break;
- case "Delete":
- deleteMatBcMData();
- break;
- case"TakeBill":
- takeBill();
- break;
- case"LoadMat":
- loadMatData();
- break;
- case"AdjustStorage":
- adjustStorageNo();
- break;
- case"SetUpIntial":
- setUpIntial();
- break;
- case"UpdateMaterial":
- updateMaterial();
- break;
- case"UpdateMemo":
- updateMemo();
- break;
- case "UpdateReason":
- updateReason();
- break;
- case"ScrapOut":
- scrapOut();
- break;
- case"CancelScrapOut":
- cancelScrapOut();
- break;
- case"CancelScrapJudgeNo":
- cancelScrapJudgeNo();
- break;
- case"UpdatePorssWgt":
- updatePorssWgt();;
- break;
- case"BelongResponse":
- belongResponse();
- break;
- case "UpdateBelongResponse":
- UpdateBelongResponse();
- break;
- case"UpdateFlagStoveNo":
- updateFlagStoveNo();
- break;
- case "Export":
- exportData();
- break;
- case "Close":
- this.Close();
- break;
- }
- }
-
- /// <summary>
- /// 脱单成余材
- /// </summary>
- private void takeBill()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要置余材的库存信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcTity = (MatBcMEntity1)row.ListObject;
- if (matBcTity.QcmStaus.Equals("判废") || matBcTity.QcmStaus.Equals("待处理"))
- {
- MessageUtil.ShowTips("只有合格品才能置余材!");
- return;
- }
- string matBcEntity = JSONFormat.Format(matBcTity);
- parmList.Add(matBcEntity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "takeBill";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("置余材成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 撤销废品出库(逐炉)
- /// </summary>
- private void cancelScrapJudgeNo()
- {
- this.ultraGrid3.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要撤销的出库信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- YdmBcOutlistEntity ydmTity = (YdmBcOutlistEntity)row.ListObject;
- string ydmEntity = JSONFormat.Format(ydmTity);
- parmList.Add(ydmEntity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "cancelScrapJudgeNo";
- ccp.ServerParams = new object[] { parmList, UserInfo.GetUserName() };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("撤销成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 撤销废品出库(整单)
- /// </summary>
- private void cancelScrapOut()
- {
- this.ultraGrid2.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
- if(checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要撤销的出库单!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach(UltraGridRow row in checkMagRows)
- {
- YdmBcScrapoutlistEntity ydmTity = (YdmBcScrapoutlistEntity)row.ListObject;
- string ydmEntity = JSONFormat.Format(ydmTity);
- parmList.Add(ydmEntity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "cancelScrapOut";
- ccp.ServerParams = new object[] { parmList,UserInfo.GetUserName() };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("撤销成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 责任单位划分
- /// </summary>
- private void belongResponse()
- {
- this.ultraGrid3.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要修改责任单位的废品信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- YdmBcOutlistEntity ydmTity = (YdmBcOutlistEntity)row.ListObject;
- ydmTity.BelongCodeResponse = row.Cells["BelongCodeResponse"].Value.ToString();
- ydmTity.BelongNameResponse = row.Cells["BelongCodeResponse"].Text;
- string ydmEntity = JSONFormat.Format(ydmTity);
- parmList.Add(ydmEntity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "belongResponse";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("修改成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 回报过磅重量
- /// </summary>
- private void updatePorssWgt()
- {
- this.ultraGrid2.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要回报过磅量的废品信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach(UltraGridRow row in checkMagRows)
- {
- YdmBcScrapoutlistEntity ydmScrapTity = (YdmBcScrapoutlistEntity)row.ListObject;
- if(ydmScrapTity.PonderGrossWt.ToString3() == "")
- {
- MessageUtil.ShowTips("过磅量不能为空!");
- return;
- }
- string ydmScrapEntity = JSONFormat.Format(ydmScrapTity);
- parmList.Add(ydmScrapEntity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "updatePorssWgt";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("回报成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 废品出库
- /// </summary>
- private void scrapOut()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要出库的废品信息!");
- return;
- }
- int belongNum = checkMagRows.GroupBy(p => p.GetValue("BelongCode")).Count();
- if (belongNum > 1)
- {
- MessageUtil.ShowTips("废品出库时只能同所属权单位才能成一单!");
- return;
- }
- int flagStoveNoCount = checkMagRows.GroupBy(p => p.GetValue("FlagStoveNoZg")).Count();
- if (flagStoveNoCount > 1)
- {
- MessageUtil.ShowTips("不同标识炉号的信息,不允许出库成一单!");
- return;
- }
- if (this.cmbLoadStorage.Text == "")
- {
- MessageUtil.ShowTips("废品出库请选择去向!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcTity = (MatBcMEntity1)row.ListObject;
- if (!matBcTity.QcmStaus.Equals("判废") || !matBcTity.ScrapFrimFlag.Equals("已审核"))
- {
- MessageUtil.ShowTips("只有废品已审核判定后才允许出库,请刷新页面!");
- return;
- }
- string matBcEntity = JSONFormat.Format(matBcTity);
- parmList.Add(matBcEntity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "scrapOut";
- ccp.ServerParams = new object[] { parmList,cmbLoadStorage.Value.ToString(),cmbLoadStorage.Text,UserInfo.GetUserName() };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("出库成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 修改备注
- /// </summary>
- private void updateMemo()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要修改的库存信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- string matBcTity = JSONFormat.Format(matBcEntity);
- parmList.Add(matBcTity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "updateMemo";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("修改成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 修改离线原因
- /// </summary>
- private void updateReason()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要修改的库存信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- if (matBcEntity.QcmStaus != "待处理")
- {
- MessageUtil.ShowTips("请选择缴库状态为待处理的库存信息!");
- return;
- }
- MatBcMEntity4 matBcMEntity4 = new MatBcMEntity4();
- ClsLoad.CopyModel(matBcEntity, matBcMEntity4);
- DataRow[] reasons = reasonDT.Select("REASON_CODE3 = " + row.Cells["reason"].Value.ToString3());
- matBcMEntity4.Reason1 = reasons[0]["REASON_CODE1"].ToString3();
- matBcMEntity4.Reason2 = reasons[0]["REASON_CODE2"].ToString3();
- matBcMEntity4.Reason3 = reasons[0]["REASON_CODE3"].ToString3();
- string matBcTity = JSONFormat.Format(matBcMEntity4);
- parmList.Add(matBcTity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "updateReason";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("修改成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 保存责任单位
- /// </summary>
- private void UpdateBelongResponse()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要修改的库存信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- if (matBcEntity.QcmStaus != "待处理")
- {
- MessageUtil.ShowTips("请选择缴库状态为待处理的库存信息!");
- return;
- }
- matBcEntity.BelongNameResponse = row.Cells["BelongCodeResponse"].Text.ToString3();
- matBcEntity.BelongCodeResponse = row.Cells["BelongCodeResponse"].Value.ToString3();
- string matBcTity = JSONFormat.Format(matBcEntity);
- parmList.Add(matBcTity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "updateBelongCodeResponse";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("修改成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
-
- /// <summary>
- /// 修改物料
- /// </summary>
- private void updateMaterial()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要修改的库存信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach(UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- string matBcTity = JSONFormat.Format(matBcEntity);
- parmList.Add(matBcTity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "updateMaterial";
- ccp.ServerParams = new object[] { parmList,UserInfo.GetUserName() };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("修改成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 建立期初
- /// </summary>
- private void setUpIntial()
- {
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "setUpIntial";
- ccp.ServerParams = new object[] { };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("期初建立成功!"))
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
-
-
- /// <summary>
- /// 导出
- /// </summary>
- private void exportData()
- {
- GridHelper.ulGridToExcel(ultraGrid1, "半成品库存数据汇总");
- }
- /// <summary>
- /// 查询
- /// </summary>
- private void doQuery()
- {
- string bathYear = "";
- string judgeNo = "";
- string belongCode = "";
- string[] belongCodes = new string[0];
- if(this.chkTim.Checked)
- {
- bathYear = this.StartTime.Value.ToString("yyyyMM");
- }
- if (this.chkJugeHeatNo.Checked && this.txtJugeNo.Text.Trim() != "")
- {
- judgeNo = this.txtJugeNo.Text.Trim();
- }
- if(this.chkBelong.Checked && this.cmbBelong.Text !="")
- {
- belongCode = this.cmbBelong.Value.ToString3();
- belongCodes = this.cmbBelong.CheckedItems.Select(p => p.DataValue.ToString()).ToArray();
- }
- ArrayList parmList = new ArrayList();
- parmList.Add(bathYear);
- parmList.Add(judgeNo);
- parmList.Add(belongCode);
- ArrayList scrapList = new ArrayList();
- scrapList.Add(bathYear);
- if(ultraTabControl1.SelectedTab.Key == "0")
- {
- List<MatBcMEntity1> listSource = EntityHelper.GetData<MatBcMEntity1>(
- "com.steering.ydm.bc.FrmDeleteMatBcM.doQuery", new object[] { parmList, BaseMethod.getPCodePline(this.ValidDataPurviewIds, ob), belongCodes }, this.ob);
- MatBcMEntity1bindingSource.DataSource = listSource;
- }
- else if (ultraTabControl1.SelectedTab.Key == "1")
- {
- List<YdmBcScrapoutlistEntity> listSource = EntityHelper.GetData<YdmBcScrapoutlistEntity>(
- "com.steering.ydm.bc.FrmDeleteMatBcM.doQueryScrapList", new object[] { scrapList }, this.ob);
- ydmBcScrapoutlistEntityBindingSource.DataSource = listSource;
- }
-
- }
- /// <summary>
- /// 消亡数据
- /// </summary>
- private void deleteMatBcMData()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要消亡的库存信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- string matBcTity = JSONFormat.Format(matBcEntity);
- parmList.Add(matBcTity);
- }
- if (MessageUtil.ShowYesNoAndQuestion("消亡库存数据不可逆,是否继续消亡?") == DialogResult.No)
- {
- return;
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "deleteMatBcMData";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("删除成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 修改标识炉号
- /// </summary>
- private void updateFlagStoveNo()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要修改标识炉号的库存信息!");
- return;
- }
-
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- string matBcTity = JSONFormat.Format(matBcEntity);
- parmList.Add(matBcTity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "updateFlagStoveNo";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("修改成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 调整仓库位置
- /// </summary>
- private void adjustStorageNo()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要调整位置的库存信息!");
- return;
- }
- if(this.cmbStorageNo.Value.ToString2() == "")
- {
- MessageUtil.ShowTips("请选择需要调整库存位置的仓库!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- string matBcTity = JSONFormat.Format(matBcEntity);
- parmList.Add(matBcTity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "adjustStorageNo";
- ccp.ServerParams = new object[] { parmList,this.cmbStorageNo.Value.ToString2() };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("调整成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- /// <summary>
- /// 上料
- /// </summary>
- private void loadMatData()
- {
- this.ultraGrid1.UpdateData();
- IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
- if (checkMagRows.Count() == 0)
- {
- MessageUtil.ShowTips("请选择需要上料的库存信息!");
- return;
- }
- ArrayList parmList = new ArrayList();
- foreach (UltraGridRow row in checkMagRows)
- {
- MatBcMEntity1 matBcEntity = (MatBcMEntity1)row.ListObject;
- string matBcTity = JSONFormat.Format(matBcEntity);
- parmList.Add(matBcTity);
- }
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "com.steering.ydm.bc.FrmDeleteMatBcM";
- ccp.MethodName = "loadMatData";
- ccp.ServerParams = new object[] { parmList };
- ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
- if (ccp.ReturnCode != -1)
- {
- if (ccp.ReturnInfo.Equals("上料成功!"))
- {
- doQuery();
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- else
- {
- MessageUtil.ShowTips(ccp.ReturnInfo);
- }
- }
- }
- private void chkTim_CheckedChanged(object sender, EventArgs e)
- {
- this.StartTime.Enabled = this.chkTim.Checked;
- }
- private void chkJugeHeatNo_CheckedChanged(object sender, EventArgs e)
- {
- this.txtJugeNo.Enabled = this.chkJugeHeatNo.Checked;
- }
- private void chkBelong_CheckedChanged(object sender, EventArgs e)
- {
- this.cmbBelong.Enabled = this.chkBelong.Checked;
- }
- private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
- {
- foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
- {
- if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
- {
- uRow.Cells["CHK"].Value = true;
- }
- }
- }
- private void ultraGrid1_CellChange(object sender, CellEventArgs e)
- {
- this.ultraGrid1.UpdateData();
- UltraGridRow row = this.ultraGrid1.ActiveRow;
- MatBcMEntity1 matGp = (MatBcMEntity1)row.ListObject;
- if (matGp.ActCount.Equals("") || matGp.ActCount == null)
- {
- matGp.ActCount = 0;
- }
- string matGpEntity = JSONFormat.Format(matGp);
- if (e.Cell.Column.Key == "ActCount")
- {
- DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.doQueryWeight", new object[] { matGpEntity }, ob);
- if (ds.Rows.Count > 0)
- {
- ultraGrid1.ActiveRow.Cells["ActWeight"].Value = ds.Rows[0][0].ToString();
- }
- }
- }
- private void cmbMaterial_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
- {
- this.ultraGrid1.UpdateData();
- DataTable dt = ServerHelper.GetData("com.steering.ydm.bc.FrmDeleteMatBcM.getProcessMaterial",
- new object[] { }, ob);
- dt.Columns["BASENAME"].Caption = "物料名称";
- BaseInfoPopup baseInfo = new BaseInfoPopup(dt, "BASENAME", "BASECODE");
- baseInfo.Shown += new EventHandler((a, b) =>
- {
- var actRow = baseInfo.UltraGrid1.Rows.AsQueryable().Where(
- c => c.GetValue("BASECODE") == this.cmbMaterial.Tag.ToString2()).FirstOrDefault();
- if (actRow != null) actRow.Activate();
- });
- if (baseInfo.ShowDialog() == System.Windows.Forms.DialogResult.OK)
- {
- //cmbLocationNo.Tag = baseInfo.ChoicedRow.GetValue("LOCATION_NO");
- //cmbLocationNo.Text = baseInfo.ChoicedRow.GetValue("LOCATION_NAME");
- this.ultraGrid1.ActiveCell.Value = baseInfo.ChoicedRow.GetValue("BASENAME");
- this.ultraGrid1.ActiveCell.Row.Cells["MaterialNo"].Value = baseInfo.ChoicedRow.GetValue("BASECODE");
- }
- }
- private void txtMemo_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
- {
- UltraTextEditor textEditor = (UltraTextEditor)sender;
- PopupTextBox popupText = new PopupTextBox(textEditor.Text, 500);
- if (popupText.ShowDialog() == System.Windows.Forms.DialogResult.OK)
- {
- textEditor.Text = popupText.TextInfo.Trim();
- }
- this.ultraGrid1.ActiveCell.Value = textEditor.Text;
- this.ultraGrid1.ActiveRow.Update();
- }
- private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
- {
- this.ultraGrid2.UpdateData();
- UltraGridRow row = this.ultraGrid2.ActiveRow;
- if (row == null) return;
- doQueryScrapOutList(row);
- }
- /// <summary>
- /// 查询废品出库记录
- /// </summary>
- /// <param name="row"></param>
- private void doQueryScrapOutList(UltraGridRow row)
- {
- List<YdmBcOutlistEntity> listSource = EntityHelper.GetData<YdmBcOutlistEntity>(
- "com.steering.ydm.bc.FrmDeleteMatBcM.doQueryScrapOutList", new object[] { row.Cells["OutstockDoc"].Text }, this.ob);
- ydmBcOutlistEntityBindingSource.DataSource = listSource;
- }
- private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- if (toolMenu == null) return;
- if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("LoadMat")) { toolMenu.Toolbars[0].Tools["LoadMat"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("TakeBill")) { toolMenu.Toolbars[0].Tools["TakeBill"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("AdjustStorage")) { toolMenu.Toolbars[0].Tools["AdjustStorage"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("SetUpIntial")) { toolMenu.Toolbars[0].Tools["SetUpIntial"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("UpdateMaterial")) { toolMenu.Toolbars[0].Tools["UpdateMaterial"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("UpdateMemo")) { toolMenu.Toolbars[0].Tools["UpdateMemo"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("ScrapOut")) { toolMenu.Toolbars[0].Tools["ScrapOut"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("UpdateReason")) { toolMenu.Toolbars[0].Tools["UpdateReason"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("UpdateBelongResponse")) { toolMenu.Toolbars[0].Tools["UpdateBelongResponse"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("UpdatePorssWgt")) { toolMenu.Toolbars[0].Tools["UpdatePorssWgt"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("BelongResponse")) { toolMenu.Toolbars[0].Tools["BelongResponse"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapOut")) { toolMenu.Toolbars[0].Tools["CancelScrapOut"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapJudgeNo")) { toolMenu.Toolbars[0].Tools["CancelScrapJudgeNo"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 1 ? DefaultableBoolean.True : DefaultableBoolean.False; }
- if (toolMenu.Toolbars[0].Tools.Exists("UpdateFlagStoveNo")) { toolMenu.Toolbars[0].Tools["UpdateFlagStoveNo"].InstanceProps.Visible = this.ultraTabControl1.SelectedTab.Index == 0 ? DefaultableBoolean.True : DefaultableBoolean.False; }
-
- }
- private void FrmDeleteMatBcM_Shown(object sender, EventArgs e)
- {
- if (toolMenu == null) return;
- if (toolMenu.Toolbars[0].Tools.Exists("UpdatePorssWgt"))
- {
- toolMenu.Toolbars[0].Tools["UpdatePorssWgt"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("BelongResponse"))
- {
- toolMenu.Toolbars[0].Tools["BelongResponse"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapOut"))
- {
- toolMenu.Toolbars[0].Tools["CancelScrapOut"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelScrapJudgeNo"))
- {
- toolMenu.Toolbars[0].Tools["CancelScrapJudgeNo"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- }
- }
- }
|