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(); } } }