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 Core.StlMes.Client.PlnSaleOrd.炉计划.Tool;
using CoreFS.CA06;
using Infragistics.Win;
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.PlnSaleOrd.炉计划
{
public partial class FrmPlanStoveE : FrmBase
{
private ArrayList _EntityList = null;
private string[] plineCode = null;//获取产线代码
///
/// 虚拟炉计划id
///
private string _heatPlanNo = "";
///
/// 行首背景色
///
private Color _backColor = new Color();
public FrmPlanStoveE()
{
this.IsLoadUserView = true;
InitializeComponent();
}
private void FrmPlanStoveE_Load(object sender, EventArgs e)
{
//订单排产
EntityHelper.ShowGridCaption(ultraGridZyE.DisplayLayout.Bands[0]);
EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]);
//BaseHelper.setOtherColumnReadOnly(ultraGridZyE, new string[] { "CHC" });
BaseHelper.setUltraGridColumnMaxInput(ultraGridZyE, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" });
BaseHelper.setUltraGridColumnBits(ultraGridZyE, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" });
BaseHelper.InitCellPosition(ultraGridZyE, new string[] { "GxProSeq", "GxPlanNo","OrderSeq", "DeliveryNo", "PlnInsingleNum", "PlnInsingleWt", "PlnIndoubleNum","PlnIndoubleWt","PlnOutsingleNum","PlnOutsingleW" ,"PlnOutdoubleNum","PlnOutdoubleW","OutdiameterIn","WallthickIn","LengthIn","LengthmaxIn",
"LengthminIn","OutnumCut", "Aimoutdiameter","Aimwallthick","AimlengthMax","Aimlength","AimlengthMin","LenCutend","LenCuthead","CraftSeq"});
BaseHelper.GridColumnSum(ultraGridZyE, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" });
BaseHelper.GridColumnCount(ultraGridZyE, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" });
//BaseHelper.InitCellPositionMiddle(ultraGridZyE, new string[] { "Isendgx", "IfWlMatched", "IfMonitorZg" });
plineCode = PlanHelper.InitDropPlinePower("E", txtLine, this.ValidDataPurviewIds, this.ob);
StoveHelper.ForbidSort(ultraGridZyE);
//BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC" });
BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt"});
BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum"});
BaseHelper.InitCellPosition(ultraGrid1, new string[] { "GxProSeq", "GxPlanNo","OrderSeq", "DeliveryNo", "PlnInsingleNum", "PlnInsingleWt", "PlnIndoubleNum","PlnIndoubleWt","PlnOutsingleNum","PlnOutsingleW" ,"PlnOutdoubleNum","PlnOutdoubleW","OutdiameterIn","WallthickIn","LengthIn","LengthmaxIn",
"LengthminIn","OutnumCut", "Aimoutdiameter","Aimwallthick","AimlengthMax","Aimlength","AimlengthMin","LenCutend","LenCuthead","CraftSeq","RealOutdoubleWt", "RealIndoubleWt", "RealOutdoubleNum", "RealIndoubleNum"});
BaseHelper.GridColumnSum(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt" });
BaseHelper.GridColumnCount(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum" });
StoveHelper.ForbidSort(ultraGrid1);
InitDate();
BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW", "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" }, "HeatPlanNo");
InitDate();
BaseHelper.InitComboEditor(ultraComboEditor1, "com.steering.pss.plnsaleord.planStove.FrmPlanStoveD.doQueryStorageNo", "STORAGE_NO", ob, true);
}
private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
{
StoveHelper.CustomMergedCellEvaluator merge = new StoveHelper.CustomMergedCellEvaluator("HeatPlanNo");
e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["StoveNo"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["StoveNo"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["PlnOutdoubleNum"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["PlnOutdoubleNum"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["GxProSeq"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["GxProSeq"].MergedCellEvaluator = merge;
e.Layout.Bands[0].Columns["Planstatus"].MergedCellStyle = MergedCellStyle.Always;
e.Layout.Bands[0].Columns["Planstatus"].MergedCellEvaluator = merge;
}
///
/// 初始时间
///
private void InitDate()
{
DateTime datetime = DateTime.Now;
dateBegin.Value = datetime.AddDays(1 - datetime.Day);
dateEnd.Value = datetime.AddDays(1 - datetime.Day).AddMonths(1).AddDays(-1);
}
private void chcLine_CheckedChanged(object sender, EventArgs e)
{
if (chcLine.Checked) { txtLine.Enabled = true; } else { txtLine.Enabled = false; }
if (chcProPlanId.Checked) { txtProPlanId.Enabled = true; } else { txtProPlanId.Enabled = false; }
if (chcOrderNo.Checked) { txtOrderNo.Enabled = true; } else { txtOrderNo.Enabled = false; }
if (chcId.Checked) { txtId.Enabled = true; } else { txtId.Enabled = false; }
if (chcTime.Checked) { dateBegin.Enabled = true; dateEnd.Enabled = true; } else { dateBegin.Enabled = false; dateEnd.Enabled = false; }
if (chcJudgeNo.Checked) { txtJudgeNo.Enabled = true; } else { txtJudgeNo.Enabled = false; }
if (txtFeedCheck.Checked) { txtFeedHeatNo.Enabled = true; } else { txtFeedHeatNo.Enabled = false; }
}
public override void ToolBar_Click(object sender, string ToolbarKey)
{
base.ToolBar_Click(sender, ToolbarKey);
switch (ToolbarKey)
{
case "Query"://查询
Query();
break;
case "UpdateGoWhere":
updateGoWhere();
break;
case "UpdateLoadFlag":
updateLoadFlag();
break;
case"UpdateIsWeight":
updateIsWeight();
break;
case "Export": //导出
Export();
break;
case "Close": //关闭
this.Close();
break;
default:
break;
}
}
///
/// 标记是否过磅
///
private void updateIsWeight()
{
this.ultraGridZyE.UpdateData();
UltraGridRow row = this.ultraGridZyE.ActiveRow;
if (row == null)
{
return;
}
ArrayList parmList = new ArrayList();
PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject;
string plnZgEntity = JSONFormat.Format(plnDbkTity);
parmList.Add(plnZgEntity);
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE";
ccp.MethodName = "updateIsWeight";
ccp.ServerParams = new object[] { parmList };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("修改成功!"))
{
QueryM();
MessageUtil.ShowTips(ccp.ReturnInfo);
}
else
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
///
/// 标识库位不变
///
private void updateLoadFlag()
{
this.ultraGridZyE.UpdateData();
UltraGridRow row = this.ultraGridZyE.ActiveRow;
if (row == null)
{
return;
}
ArrayList parmList = new ArrayList();
PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject;
string plnZgEntity = JSONFormat.Format(plnDbkTity);
parmList.Add(plnZgEntity);
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE";
ccp.MethodName = "updateLoadFlag";
ccp.ServerParams = new object[] { parmList };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("修改成功!"))
{
QueryM();
MessageUtil.ShowTips(ccp.ReturnInfo);
}
else
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
///
/// 修改去向
///
private void updateGoWhere()
{
this.ultraGridZyE.UpdateData();
UltraGridRow row = this.ultraGridZyE.ActiveRow;
if (row == null)
{
return;
}
ArrayList parmList = new ArrayList();
PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject;
plnDbkTity.GowhereCode = row.Cells["GowhereCode"].Value.ToString();
plnDbkTity.GowhereName = row.Cells["GowhereCode"].Text.ToString();
string plnZgEntity = JSONFormat.Format(plnDbkTity);
parmList.Add(plnZgEntity);
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE";
ccp.MethodName = "updateGoWhere";
ccp.ServerParams = new object[] { parmList };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("修改成功!"))
{
QueryM();
MessageUtil.ShowTips(ccp.ReturnInfo);
}
else
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
private void Query()
{
if (ultraExpandableGroupBox1.Expanded == false)
{
QueryC();
}
else
{
QueryM();
}
}
private int activation = 0;
///
/// 导出
///
private void Export()
{
if (activation < 2)
{
GridHelper.ulGridToExcel(ultraGridZyE, "镦拔扩炉计划主信息");
}
else
{
GridHelper.ulGridToExcel(ultraGrid1, "镦拔扩炉计划详情");
}
}
///
/// 查询镦拔虚拟炉计划
///
private void QueryM()
{ //产线
string plineCode = "";
if (chcLine.Checked)
{
plineCode = txtLine.Value == null ? "" : txtLine.Value.ToString();
}
//if (txtLine.Text.Equals(""))
//{
// MessageUtil.ShowTips("请选择产线!");
// return;
//}
string timeBegin = "";
string timeEnd = "";
if (chcTime.Checked && dateBegin.Value != null && dateEnd.Value != null)
{
timeBegin = DateTime.Parse(dateBegin.Value.ToString()).ToString("yyyy-MM-dd");
timeEnd = DateTime.Parse(dateEnd.Value.ToString()).ToString("yyyy-MM-dd");
}
string orderNo = "";
if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
string proPlanId = "";
if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
string heatId = "";
if (chcId.Checked) { heatId = txtId.Text.Trim(); }
string judgeNo = "";
if (chcJudgeNo.Checked) { judgeNo = txtJudgeNo.Text.Trim(); }
string feedNo = "";
if (txtFeedCheck.Checked) { feedNo = txtFeedHeatNo.Text.Trim(); }
//执行状态
string[] statusArr = contorlPlanStatusZy1.statusArr;
List listSource = EntityHelper.GetData
("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlanStoveYzE", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, feedNo }, this.ob);
plnZyDbkMEntityBindingSource.DataSource = listSource;
foreach (UltraGridRow ugr in ultraGridZyE.Rows)
{
int countMess = 0;
if (!_heatPlanNo.Equals(""))
{
if (ugr.Cells["HeatPlanNo"].Text.Trim().Equals(_heatPlanNo))
{
ugr.Activate();
break;
}
}
if (_EntityList != null)
{
for (int i = 0; i < _EntityList.Count; i++)
{
PlnZyDbkMEntity entity = (PlnZyDbkMEntity)_EntityList[i];
if (ugr.Cells["HeatPlanNo"].Text.Trim().Equals(entity.HeatPlanNo))
{
ugr.Appearance.BackColor = Color.Wheat;
ugr.Activate();
}
}
}
}
_EntityList = null;
_heatPlanNo = "";
}
///
/// 查询镦拔扩实际炉计划
///
private void QueryC()
{
//产线
string plineCode = "";
if (chcLine.Checked)
{
plineCode = txtLine.Value == null ? "" : txtLine.Value.ToString();
}
//if (txtLine.Text.Equals(""))
//{
// MessageUtil.ShowTips("请选择产线!");
// return;
//}
string timeBegin = "";
string timeEnd = "";
if (chcTime.Checked && dateBegin.Value != null && dateEnd.Value != null)
{
timeBegin = DateTime.Parse(dateBegin.Value.ToString()).ToString("yyyy-MM-dd");
timeEnd = DateTime.Parse(dateEnd.Value.ToString()).ToString("yyyy-MM-dd");
}
string orderNo = "";
if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
string proPlanId = "";
if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
string heatId = "";
if (chcId.Checked) { heatId = txtId.Text.Trim(); }
string judgeNo = "";
if (chcJudgeNo.Checked) { judgeNo = txtJudgeNo.Text.Trim(); }
string feedNo = "";
if (txtFeedCheck.Checked) { feedNo = txtFeedHeatNo.Text.Trim(); }
//执行状态
string[] statusArr = contorlPlanStatusZy1.statusArr;
List listSource = EntityHelper.GetData
("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlnZyDbkReadyById", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, feedNo }, this.ob);
plnZyDbkReadyEntityBindingSource.DataSource = listSource;
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
//没有实际炉计划,主炉计划变颜色
if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals(""))
{
//ugr.RowSelectorAppearance.BackColor = Color.GreenYellow;
ugr.Appearance.BackColor = Color.Orange;
}
}
}
private void ultraGridZyE_AfterRowActivate(object sender, EventArgs e)
{
UltraGridRow row = ultraGridZyE.ActiveRow;
if (row == null) return;
QueryMRow(row.Cells["HeatPlanNo"].Text.ToString().Trim());
}
private void QueryMRow(string heatPlanNo)
{
List listSourceM = EntityHelper.GetData
("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlanStoveRow", new object[] { heatPlanNo }, ob);
plnZyDbkReadyEntityBindingSource.DataSource = listSourceM;
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
//没有实际炉计划,主炉计划变颜色
if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals(""))
{
//ugr.RowSelectorAppearance.BackColor = Color.GreenYellow;
ugr.Appearance.BackColor = Color.Orange;
}
}
}
private int splitterDistance = 0;
int count1 = 0;
int count2 = 0;
private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e)
{
if (ultraExpandableGroupBox1.Expanded == false)
{
this.splitContainer1.SplitterDistance = 26;
count1 = 26;
}
else
{
if (ultraExpandableGroupBox2.Expanded == false)
{
this.splitContainer1.SplitterDistance = splitContainer1.Size.Height - 26;
}
else
{
this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance;
}
count1 = splitContainer1.Size.Height - 26;
}
}
private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e)
{
if (ultraExpandableGroupBox2.Expanded == false)
{
if (count1 == 0) { count1 = splitContainer1.Size.Height - 26; }
this.splitContainer1.SplitterDistance = count1;
}
else
{
if (ultraExpandableGroupBox1.Expanded == false)
{
this.splitContainer1.SplitterDistance = 26;
}
else
{
//this.splitContainer1.SplitterDistance = count1;
this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance;
}
}
}
private void ultraGridZyE_Click(object sender, EventArgs e)
{
activation = 1;
}
private void ultraGridZyE_ClickCell(object sender, ClickCellEventArgs e)
{
activation = 1;
}
private void ultraGrid1_Click(object sender, EventArgs e)
{
activation = 2;
}
private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
{
activation = 2;
}
}
}