| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474 |
- 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;
- using Core.Mes.Client.Comm.Control;
- using Core.Mes.Client.Comm.Format;
- using Core.Mes.Client.Comm.Tool;
- using Core.StlMes.Client.PlnSaleOrd.BaseMethod;
- using Core.StlMes.Client.PlnSaleOrd.工序排产;
- using Core.StlMes.Client.PlnSaleOrd.工序排产.entity;
- using CoreFS.CA06;
- using Infragistics.Win;
- using Infragistics.Win.UltraWinGrid;
- namespace Core.StlMes.Client.PlnSaleOrd
- {
- public partial class FrmPlnOrderZzS : FrmBase
- {
- /// <summary>
- /// 订单编号
- /// </summary>
- private string _ProPlanId = "";
- /// <summary>
- /// 排产序号
- /// </summary>
- private string _GxPlanNo = "";
- /// <summary>
- /// 行首背景色
- /// </summary>
- private Color _BackColor = new Color();
- /// <summary>
- /// 调整行集合
- /// </summary>
- private ArrayList _EntityList = null;
- public FrmPlnOrderZzS()
- {
- this.IsLoadUserView = true;
- InitializeComponent();
- }
- private void FrmPlnOrderZzS_Load(object sender, EventArgs e)
- {
- if (CustomInfo == null) { CustomInfo = ""; }
- //设置列头名称
- EntityHelper.ShowGridCaption<PlnOrderCastOSEntity>(ultraGridZz.DisplayLayout.Bands[0]);
- BaseHelper.setOtherColumnReadOnly(ultraGridZz, new string[] { "CHC", "PlineCode", "PlanTimeB", "RepairType", "PlanUsetime" });
- BaseHelper.setColumnBackColor(ultraGridZz, new string[] { "PlineCode" });
- BaseHelper.InitCellPosition(ultraGridZz, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "PlanWtS", "PlanNumS", "PlanUsetime", "GxProSeq",
- "PlnDivideId", "DiameterLz","LenGpSingle","CutNumGp","CutLoseLen","LengthLz","WtCastOne","CastNumCalc","FurnaceNumCalc","FurnaceWt","PlanedWt","PlanedNum",
- "Finishweight","FinishNum","CastNum","FurnaceNum","AddWtBegin","AddWtEnd","AddWtAhead","ProcessingCostA","TotalCostA","ProcessingCostB","TotalCostB"});
- BaseHelper.setUltraGridColumnMaxInput(ultraGridZz, new string[] { "PlanWtS" });
- PlanHelper.InitDropPline("B", "", comPline, this.ob);
- PlanHelper.InitRepairType(ultraGridZz, this);
- PlanHelper.InitEditPline("B", "", ultraGridZz, this);
- if (CustomInfo != "0") { BaseHelper.ForbidSort(ultraGridZz); }
- BaseHelper.GridColumnSum(ultraGridZz, new string[] { "PlanWtS" });
- BaseHelper.GridColumnCount(ultraGridZz, new string[] { "PlanNumS" });
- BaseHelper.InitCellPositionMiddle(ultraGridZz, new string[] { "IsRepairPln", "IsPlanOk", "IfConnectAhead", "IfConnectNext", "IfMonitorLg" });
- _BackColor = ultraGridZz.DisplayLayout.Override.RowSelectorAppearance.BackColor;
- }
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- base.ToolBar_Click(sender, ToolbarKey);
- switch (ToolbarKey)
- {
- case "Query"://查询
- Query();
- break;
- case "Capacity"://产线能力维护
- Capacity();
- break;
- case "AddRepairPlan"://检修计划
- AddRepairPlan();
- break;
- case "DeleteRepairPlan"://删除检修计划
- DeleteRepairPlan();
- break;
- case "PlineChange"://产线调整
- PlineChange();
- break;
- case "TimeChange"://时间调整
- TimeChange();
- break;
- case "StatusChange"://状态调整
- StatusChange();
- break;
- case "InitData"://耗时初始化
- Init();
- break;
- case "Spit"://拆分订单
- Spit();
- break;
- case "Merge"://合并订单
- Merge();
- break;
- case "Issued"://下发
- Issued("0");
- break;
- case "CancelIssued"://取消下发
- Issued("1");
- break;
- case "Export": //导出
- GridHelper.ulGridToExcel(ultraGridZz, "铸造排产信息");
- break;
- default:
- break;
- }
- }
- private void chcPline_CheckedChanged(object sender, EventArgs e)
- {
- if (chcPline.Checked) { comPline.ReadOnly = false; } else { comPline.ReadOnly = true; }
- if (chcProPlanId.Checked) { txtProPlanId.ReadOnly = false; } else { txtProPlanId.ReadOnly = true; }
- }
- private void ultraGridZz_InitializeRow(object sender, InitializeRowEventArgs e)
- {
- PlanHelper.ControlCellEdit(e.Row);
- }
- /// <summary>
- /// 查询
- /// </summary>
- private void Query()
- {
- //产线
- string plineCode = "";
- if (chcPline.Checked) { plineCode = comPline.Value == null ? "" : comPline.Value.ToString(); }
- //如果是排产界面,则下拉框的产线不能为空,需要排序
- if (!CustomInfo.Equals("0") && plineCode.Equals("")) { MessageUtil.ShowTips("请选择产线!"); return; }
- //执行状态
- string[] statusArr = new string[4] { "", "", "", "" };
- if (ultraCheckEditor1.Checked) { statusArr[0] = "0"; }
- if (ultraCheckEditor2.Checked) { statusArr[1] = "1"; }
- if (ultraCheckEditor3.Checked) { statusArr[2] = "2"; }
- if (ultraCheckEditor3.Checked) { statusArr[3] = "3"; }
- //订单编号
- string proPlanId = "";
- if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
- List<PlnOrderCastOSEntity> listSource = EntityHelper.GetData<PlnOrderCastOSEntity>
- ("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlanOrderB", new object[] { plineCode, proPlanId, statusArr }, this.ob);
- plnOrderCastOSEntityBindingSource.DataSource = listSource;
- //激活操作行代码
- if ((!_ProPlanId.Equals("") && !_GxPlanNo.Equals("")) || _EntityList != null)
- foreach (UltraGridRow ugr in ultraGridZz.Rows)
- {
- if (!_ProPlanId.Equals("") && !_GxPlanNo.Equals(""))
- {
- if (ugr.Cells["ProPlanId"].Text.Trim().Equals(_ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(_GxPlanNo))
- {
- ugr.Activate();
- break;
- }
- }
- if (_EntityList != null)
- {
- for (int i = 0; i < _EntityList.Count; i++)
- {
- PlnOrderCastSEntity jgxsEntity = (PlnOrderCastSEntity)_EntityList[i];
- if (ugr.Cells["ProPlanId"].Text.Trim().Equals(jgxsEntity.ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(jgxsEntity.GxPlanNo))
- {
- ugr.Appearance.BackColor = Color.Wheat;
- ugr.Activate();
- }
- }
- }
- }
- _EntityList = null;
- _ProPlanId = "";
- _ProPlanId = "";
- }
-
- /// <summary>
- /// 产线能力维护
- /// </summary>
- private void Capacity()
- {
- UltraGridRow ugr = ultraGridZz.ActiveRow;
- if (ugr == null)
- {
- return;
- }
- string inMaterialNo = ugr.Cells["WlidIn"].Text;
- string outMaterialNo = ugr.Cells["MaterialNo"].Text;
- string plineCode = ugr.Cells["PlineCode"].Value.ToString();
- FrmBaseMaterialBPl frmBaseMaterialBPl = new FrmBaseMaterialBPl(inMaterialNo, outMaterialNo, plineCode, this.ob);
- frmBaseMaterialBPl.ShowDialog();
- }
- /// <summary>
- /// 新增检修计划
- /// </summary>
- private void AddRepairPlan()
- {
- if (comPline.Value == null || comPline.Value.ToString().Equals(""))
- {
- MessageUtil.ShowTips("请选择产线!");
- return;
- }
- FrmJxjh frmJxjh = new FrmJxjh(this.ob, comPline.Value.ToString(), "B");
- frmJxjh.ShowDialog();
- Query();
- }
- /// <summary>
- /// 折分订单
- /// </summary>
- private void Spit()
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.SpitPlanOrder(list,"B",this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
-
- }
- /// <summary>
- /// 合并订单
- /// </summary>
- private void Merge()
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.MergePlanOrder(list,"B",this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
- }
- /// <summary>
- /// 产线调整
- /// </summary>
- private void PlineChange()
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.PlineChange(list,"B",this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
- }
- /// <summary>
- /// 初始化
- /// </summary>
- private void Init()
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.InitData(list, "B", this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
- }
- /// <summary>
- /// 状态调整
- /// </summary>
- private void StatusChange()
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.StatusChange(list,"B",this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
-
- }
- /// <summary>
- /// 时间调整
- /// </summary>
- private void TimeChange()
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.TimeChange(list, "B", this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
- }
- /// <summary>
- /// 排序
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void ultraGridZzS_MouseDown(object sender, MouseEventArgs e)
- {
- //排产查询界面,不能排序
- if (CustomInfo.Equals("0"))
- { return;}
- try
- { ultraGridZz.UpdateData();}
- catch (Exception)
- { MessageUtil.ShowWarning("数据异常,请刷新数据!");return;
- }
- if (e.Button == MouseButtons.Right)
- {
- //移动行
- ArrayList entityList = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- if (entityList == null || entityList.Count == 0)
- { return;
- }
- //定位行
- UIElement myUIElement = ultraGridZz.DisplayLayout.UIElement.ElementFromPoint(new Point(e.X, e.Y));
- UltraGridCell myCell = (UltraGridCell)myUIElement.GetContext(typeof(UltraGridCell));
- if (myCell == null){ return ; }
- UltraGridRow ugr = myCell.Row;
- if (ugr == null){ return ; }
- PlnOrderCastSEntity entityD = (PlnOrderCastSEntity)ugr.ListObject;
- bool flag = ProducHelper.SortPlanOrder(entityList, entityD, "B", "",this.ob);
- if (flag) {
- _EntityList = entityList;
- Query();
- }
- }
- }
- private void ultraGridZzS_AfterRowActivate(object sender, EventArgs e)
- {
- UltraGridRow ugrAc = ultraGridZz.ActiveRow;
- if (ugrAc == null)
- {
- return;
- }
- foreach (UltraGridRow ugr in ultraGridZz.Rows)
- {
- if (ugr.Cells["ProPlanId"].Text.Equals(ugrAc.Cells["ProPlanId"].Text))
- {
- ugr.RowSelectorAppearance.BackColor = Color.LightGreen;
- }
- else
- {
- ugr.RowSelectorAppearance.BackColor = _BackColor;
- }
- if (ugr.Cells["PlanUsetime"].Value == null || ugr.Cells["PlanUsetime"].Value.ToString().Equals("") || Convert.ToDouble(ugr.Cells["PlanUsetime"].Value.ToString()) <= 0)
- {
- ugr.Cells["PlanUsetime"].Appearance.BackColor = Color.MistyRose;
- }
- if (ugr.Cells["ExeStatus"].Value.ToString().Equals("生产中"))
- {
- ugr.Cells["PlanTimeB"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
- }
- if (ugr.Cells["IsRepairPln"].Text.Equals("Y"))
- {
- ugr.Cells["PlanUsetime"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
- ugr.Cells["RepairType"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
- }
- }
- }
- private void ultraGridZzS_CellChange(object sender, CellEventArgs e)
- {
- try
- {
- ultraGridZz.UpdateData();
- if (e.Cell.Column.Key.Equals("PlineCode"))
- {
- IQueryable<UltraGridRow> chcRows = ultraGridZz.Rows.AsQueryable().Where(a => a.GetValue("CHC") == "True");
- if (CustomInfo.Equals("0"))
- {
- e.Cell.Row.Cells["PlineName"].Value = e.Cell.Text;
- }
- else
- {
- if (chcRows != null && chcRows.Count() > 0)
- {
- foreach (UltraGridRow ugr in chcRows)
- {
- ugr.Cells["PlineCode"].Value = e.Cell.Value.ToString();
- ugr.Cells["PlineName"].Value = e.Cell.Text;
- }
- }
- }
- }
- }
- catch (Exception)
- {
- }
- }
- /// <summary>
- /// 删除检修计划
- /// </summary>
- public void DeleteRepairPlan()
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.DeleteRepairPlan(list, "B", this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
- }
- private void comPline_ValueChanged(object sender, EventArgs e)
- {
- if (comPline == null)
- {
- return;
- }
- else
- {
- if (!CustomInfo.Equals("0"))
- {
- Query();
- }
- }
- }
- /// <summary>
- /// 下发(取消)
- /// </summary>
- private void Issued(string isFlag)
- {
- ArrayList list = ProducHelper.GetChcRows<PlnOrderCastSEntity>(ultraGridZz);
- bool flag = ProducHelper.issuedPlanOrder(list, UserInfo.GetUserName(), isFlag, "B", this.ob);
- if (flag)
- {
- _ProPlanId = ((PlnOrderCastSEntity)list[0]).ProPlanId;
- _GxPlanNo = ((PlnOrderCastSEntity)list[0]).GxPlanNo;
- Query();
- }
- }
- private void ultraGridZz_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
- {
- foreach (UltraGridRow uRow in ultraGridZz.Selected.Rows)
- {
- if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
- {
- uRow.Cells["CHC"].Value = true;
- }
- }
- }
- }
- }
|