using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
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.Mcp.Treatment.HeatTreatment
{
public partial class FrmSizBaseConfigInfo : FrmBase
{
public FrmSizBaseConfigInfo()
{
InitializeComponent();
}
private void FrmSizBaseConfigInfo_Load(object sender, EventArgs e)
{
//获取工序
DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmMachine.getQueryGx", new object[] { "F" }, this.ob);
cmbGx.DataSource = dt;
cmbGx.DisplayMember = "STATION_DESC";
cmbGx.ValueMember = "STATION_CODE";
cmbGxEdi.DataSource = dt;
cmbGxEdi.DisplayMember = "STATION_DESC";
cmbGxEdi.ValueMember = "STATION_CODE";
//获取产线
DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmMachine.getQueryPline", new object[] { "F" }, this.ob);
cmbCx.DataSource = dt1;
cmbCx.DisplayMember = "PLINE_NAME";
cmbCx.ValueMember = "PLINE_CODE";
cmbCxEdi.DataSource = dt1;
cmbCxEdi.DisplayMember = "PLINE_NAME";
cmbCxEdi.ValueMember = "PLINE_CODE";
}
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "DoQuery":
DoQuery();
break;
case "DoSave":
DoSave();
break;
case "DoUpdate":
DoUpdate();
break;
case "DoDelete":
DoDelete();
break;
case "DoClose":
this.Close();
break;
}
}
///
/// 查询
///
private void DoQuery()
{
string plincode="";
string stationNo="";
if (chkCx.Checked) { if (cmbCx.Text != "") { plincode = cmbCx.Value.ToString(); } }
if (chkGx.Checked) { if (cmbGx.Text != "") { stationNo = cmbGx.Value.ToString(); } }
DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { plincode, stationNo }, this.ob);
GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
}
///
/// 新增
///
private void DoSave()
{
int count = 0;
if (cmbCxEdi.Text == "") { MessageUtil.ShowTips("请选择产线!"); return; }
if (cmbGxEdi.Text == "") { MessageUtil.ShowTips("请选择工序点!"); return; }
ArrayList pram = new ArrayList();
pram.Add(cmbCxEdi.Value.ToString());
pram.Add(cmbCxEdi.Text.ToString());
pram.Add(cmbGxEdi.Value.ToString());
pram.Add(cmbGxEdi.Text.ToString());
pram.Add(TxtGxSeq.Text.ToString());
pram.Add(this.UserInfo.GetUserName());
DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { cmbCxEdi.Value.ToString(), cmbGxEdi.Value.ToString() }, this.ob);
if (dt.Rows.Count > 0)
{
MessageUtil.ShowTips("有重复产线和工序点,请确认?");
return;
}
count = ServerHelper.SetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getAddBasic", new object[] { pram }, this.ob);
if (count >0)
{
MessageUtil.ShowTips("新增成功!");
DoQuery();
}
else
{
MessageUtil.ShowTips("新增失败!");
return;
}
}
///
/// 修改
///
private void DoUpdate()
{
UltraGridRow uRow = ultraGrid1.ActiveRow;
if (uRow == null) return;
int count = 0;
ArrayList pram = new ArrayList();
pram.Add(cmbCxEdi.Value.ToString());
pram.Add(cmbCxEdi.Text.ToString());
pram.Add(cmbGxEdi.Value.ToString());
pram.Add(cmbGxEdi.Text.ToString());
pram.Add(TxtGxSeq.Text.ToString());
pram.Add(this.UserInfo.GetUserName());
pram.Add(uRow.Cells["PLINE_CODE"].Value.ToString());
pram.Add(uRow.Cells["STATION_CODE"].Value.ToString());
if (cmbCxEdi.Value.ToString() != uRow.Cells["PLINE_CODE"].Value.ToString() || cmbGxEdi.Value.ToString() != uRow.Cells["STATION_CODE"].Value.ToString())
{
DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { cmbCxEdi.Value.ToString(), cmbGxEdi.Value.ToString() }, this.ob);
if (dt.Rows.Count > 0)
{
MessageUtil.ShowTips("有重复产线和工序点,请确认?");
return;
}
}
count = ServerHelper.SetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getUpdateBasic", new object[] { pram }, this.ob);
if (count > 0)
{
MessageUtil.ShowTips("修改成功!");
DoQuery();
}
else
{
MessageUtil.ShowTips("修改失败!");
return;
}
}
///
/// 删除
///
private void DoDelete()
{
UltraGridRow uRow = ultraGrid1.ActiveRow;
if (uRow == null) return;
int count = 0;
ArrayList pram = new ArrayList();
pram.Add(uRow.Cells["PLINE_CODE"].Value.ToString());
pram.Add(uRow.Cells["STATION_CODE"].Value.ToString());
DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getQueryBasic", new object[] { uRow.Cells["PLINE_CODE"].Value.ToString(), uRow.Cells["STATION_CODE"].Value.ToString() }, this.ob);
if (dt.Rows.Count == 0)
{
MessageUtil.ShowTips("已删除!");
return;
}
count = ServerHelper.SetData("com.steering.mes.mcp.heatTreatment.FrmSizBaseConfigInfo.getDeleteBasic", new object[] { pram }, this.ob);
if (count > 0)
{
MessageUtil.ShowTips("删除成功!");
DoQuery();
}
else
{
MessageUtil.ShowTips("删除失败!");
return;
}
}
private void chkCx_CheckedChanged(object sender, EventArgs e)
{
if (chkCx.Checked) { cmbCx.Enabled = true; } else { cmbCx.Enabled = false; }
if (chkGx.Checked) { cmbGx.Enabled = true; } else { cmbGx.Enabled = false; }
}
private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
{
UltraGridRow uRow = ultraGrid1.ActiveRow;
if (uRow == null) return;
TxtGxSeq.Text = uRow.Cells["STATION_NO"].Text.ToString();
cmbCxEdi.Value = uRow.Cells["PLINE_CODE"].Text.ToString();
cmbGxEdi.Value = uRow.Cells["STATION_CODE"].Text.ToString();
}
}
}