using System;
using System.Collections;
using System.Collections.Generic;
using System.Drawing;
using System.Linq;
using System.Management;
using System.Windows.Forms;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Mch.Entity;
using CoreFS.CA06;
namespace Core.StlMes.Client.Mcp.Mch.Report
{
public partial class FrmOffLineReport : FrmBase
{
private string plineCode = "";
private string[] plineCodes = {};
public FrmOffLineReport()
{
InitializeComponent();
IsLoadUserView = true;
}
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "DoQuery":
QuerySinglePlan();
break;
case "DoClose":
Close();
break;
case "Export":
GridHelper.ulGridToExcel(ultraGrid1, "热处理离线台账");
break;
}
}
///
/// 台账查询
///
private void QuerySinglePlan()
{
var startTime = "";
var endTime = "";
var judgeNo = "";
var batchNo = "";
var gx = "";
if (chkTim.Checked)
if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
{
MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
return;
}
else
{
startTime = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
endTime = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
}
else if (!chkJugeHeatNo.Checked)
if (MessageUtil.ShowYesNoAndQuestion("未加时间条件,查询时间可能比较长,请确定是否继续查询?") == DialogResult.No) return;
if (chkJugeHeatNo.Checked)
judgeNo = txtJugeNo.Text.Trim();
if (chkBatch.Checked)
batchNo = txtBatch.Text.Trim();
var list = new ArrayList();
list.Add(startTime);
list.Add(endTime);
list.Add(judgeNo);
list.Add(batchNo);
list.Add(gx);
list.Add(uceType.SelectedItem.DataValue.ToString());
List listSource = EntityHelper.GetData(
"com.steering.mes.mcp.Mch.FrmJgxReport.doQueryOffLine", new object[] { list, new string[]{ultraCheckEditor1.Checked?"1":"0", ultraCheckEditor2.Checked?"1":"0",ultraCheckEditor3.Checked?"1":"0",ultraCheckEditor4.Checked?"1":"0"}
,plineCode == "" ? plineCodes : new string[] { plineCode } }, ob);
List listGroup = EntityHelper.GetData(
"com.steering.mes.mcp.Mch.FrmMchDownLineManage.doQueryOffGroupDetail",
new object[] {listSource.Select(p => p.GroupId).Distinct().ToArray()}, ob);
listSource.ForEach(
p => p.MchGroupResultEntitys = listGroup.Where(q => q.GroupId == p.GroupId).OrderBy(q => q.GroupXh).ToList());
HttOfflineResultEntitybindingSource.DataSource = listSource;
comm.RefreshAndAutoSize(ultraGrid1,new string[]{"StdName"});
}
private void FrmWatergageReport_Load(object sender, EventArgs e)
{
plineCodes = comm.InitDropPlineCodePower("G", txt_PlinCode, ValidDataPurviewIds, ob);
if (plineCodes.Length > 1 && (plineCodes[1] == "C038" || plineCodes[1] == "C039" || plineCodes[1] == "C049" || plineCodes[1] == "C050" ||
plineCodes[1] == "C051" || plineCodes[1] == "C057"))
{
RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 20:00"));
RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 19:59"));
}
else
{
RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00"));
RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59"));
}
txt_PlinCode.SelectedIndex = 0;
EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]);
EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[1]);
uceType.SelectedIndex = 0;
QuerySinglePlan();
}
private void chkStarts_CheckedChanged(object sender, EventArgs e)
{
if (chkTim.Checked)
{
RegStartTime.Enabled = true;
RegEndTime.Enabled = true;
}
else
{
RegStartTime.Enabled = false;
RegEndTime.Enabled = false;
}
if (chkJugeHeatNo.Checked) txtJugeNo.Enabled = true;
else txtJugeNo.Enabled = false;
if (chkBatch.Checked) txtBatch.Enabled = true;
else txtBatch.Enabled = false;
}
private void txt_PlinCode_TextChanged(object sender, EventArgs e)
{
plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
}
private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
{
MchOfflineResultAndGroupEntity list = e.Row.ListObject as MchOfflineResultAndGroupEntity;
if(list==null) return;
if (list.GroupLog == "1")
{
e.Row.Cells["GroupLog"].Appearance.BackColor = Color.LightGreen;
}
if ((list.OfflineNum ?? 0) - (list.GroupNum ?? 0) - (list.ReNum ?? 0) - (list.SubcontractNum ?? 0) + (list.SubcontractcompleteNum ?? 0) <= 0)
{
if ((list.SubcontractNum ?? 0) > 0 && (list.SubcontractcompleteNum ?? 0) == 0 &&
(list.HbFpNum ?? 0) == 0)
{
e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.Khaki;
}
else if((list.GroupNum??0)>0)
{
e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.DarkGray;
}
else
{
e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.LightGray;
}
}
}
}
}