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.Data;
using System.Drawing;
using System.Windows.Forms;
namespace Core.StlMes.Client.Qcm
{
public partial class FrmProcessParameters : FrmBase
{
public FrmProcessParameters()
{
InitializeComponent();
}
private void FrmProcessParameters_Load(object sender, EventArgs e)
{
BindCmbParamType();
cmbParamType.SelectedIndex = 0;
cmbStyleName.SelectedIndex = 0;
//doQuery();
}
///
/// 获取工艺参数最大值
///
///
private string GetMaxCode()
{
DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessParameters.GetMaxCode", null, this.ob);
string maxCode = "";
if (dt.Rows.Count > 0)
{
if (!"".Equals(dt.Rows[0][0].ToString()))
{
maxCode = dt.Rows[0][0].ToString();
}
else
{
maxCode = "C000";
}
}
return maxCode;
}
///
/// 绑定工艺参数类别数据源
///
private void BindCmbParamType()
{
DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessParameters.GetType", null, this.ob); ;
cmbParamType.DataSource = dt;
cmbParamType.DisplayMember = "BASENAME";
cmbParamType.ValueMember = "BASECODE";
DataTable dtProcess = ServerHelper.GetData("com.steering.pss.qcm.CoreControlPointBasics.GetProcess", null, this.ob);
ultraComboEditor1.DataSource = dtProcess;
ultraComboEditor1.DisplayMember = "PROCESS_DESC";
ultraComboEditor1.ValueMember = "PROCESS_CODE";
}
///
/// 重写基类方法
///
///
///
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "doQuery":
doQuery();
break;
case "doAdd":
doAdd();
break;
case "doModify":
doModify();
break;
case "doDelete":
this.doDeleteOrResume(true);
break;
case "doResume":
this.doDeleteOrResume(false);
break;
case "Refresh":
{
BindCmbParamType();
cmbParamType.SelectedIndex = 0;
cmbStyleName.SelectedIndex = 0;
break;
}
case "Close":
this.Close();
break;
}
}
///
/// 用于验证修改时,描述是否已存在
///
private static string VName = "";
///
/// 验证非空项
///
///
private bool ValidInput()
{
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
MessageBox.Show("请输入工艺参数描述!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
return true;
}
///
/// 验证描述是否重复。
///
///
///
private bool isRepeatName(string name)
{
DataTable dt = new DataTable();
dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessParameters.GetName", new Object[] { name }, this.ob);
if (dt.Rows.Count > 0)
{
return true;
}
else
{
return false;
}
}
///
/// 新增
///
private void doAdd()
{
if (ValidInput())
{
//验证描述不允许重复。
string name = txtName.Text.Trim();
if (isRepeatName(name))
{
MessageBox.Show("工艺参数描述\"" + name + "\"已存在,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("是否确认新增!", "提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
try
{
ArrayList parm = new ArrayList();
//自动生成编号信息。
//string chenCode = GridHelper.AutoCode(this.dataTable1);
//获取数据库中CRAFT_CODE的最大值。
//GetMaxCode();
//string chenCode = StringUtil.SequenceIncrease(dataTable1.Compute("max(CRAFT_CODE)", "").ToString());
string chenCode = StringUtil.SequenceIncrease(GetMaxCode());
parm.Add(chenCode);
parm.Add(name);
parm.Add(cmbParamType.Text);
parm.Add(cmbStyleName.Value);
parm.Add(this.UserInfo.GetUserName());
parm.Add(txtMemo.Text);
parm.Add(ultraComboEditor1.Value.ToString2());
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.pss.qcm.CoreProcessParameters";
ccp.MethodName = "doAdd";
ccp.ServerParams = new object[] { parm };
ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode == -1) return;
doQuery();
//高亮显示新增的数据
Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
for (int i = 0; i < ultraGrid1.Rows.Count; i++)
{
row = ultraGrid1.Rows[i];
if (row.Cells["CRAFT_CODE"].Value.ToString().Equals(chenCode))
{
row.Activate();
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
///
/// 修改
///
private void doModify()
{
if (ultraGrid1.ActiveRow == null)
{
MessageBox.Show("请选择需要修改的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string validflagStr = ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString();
//无效数据不允许修改
if ("0".Equals(validflagStr))
{
MessageBox.Show("无效数据不支持修改操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (ValidInput())
{
//验证描述不允许重复。
string name = txtName.Text.Trim();
if (!VName.Equals(name))
{
if (isRepeatName(name))
{
MessageBox.Show("工艺参数描述\"" + name + "\"已存在,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//确认修改吗?
if (MessageBox.Show("是否确认修改选中的数据!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
ArrayList parm = new ArrayList();
string chenCode = ultraGrid1.ActiveRow.Cells["CRAFT_CODE"].Value.ToString();
parm.Add(txtName.Text);
parm.Add(cmbParamType.Text);
parm.Add(cmbStyleName.Value);
parm.Add(this.UserInfo.GetUserName());
parm.Add(txtMemo.Text);
parm.Add(ultraComboEditor1.Value.ToString2());
parm.Add(chenCode);
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.pss.qcm.CoreProcessParameters";
ccp.MethodName = "doModify";
ccp.ServerParams = new object[] { parm };
ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode == -1) return;
doQuery();
//高亮显示新增的数据
Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
for (int i = 0; i < ultraGrid1.Rows.Count; i++)
{
row = ultraGrid1.Rows[i];
if (row.Cells["CRAFT_CODE"].Value.ToString().Equals(chenCode))
{
row.Activate();
break;
}
}
}
}
///
/// 查询
///
private void doQuery()
{
bool validFlag = chkValid.Checked;
string titleName = "";
if (ultraCheckEditor1.Checked)
{
titleName = txtTitleName.Text.Trim();
}
DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessParameters.getLineList", new Object[] { validFlag, titleName }, this.ob);
GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable1, true);
//不同颜色区分是否有效数据
Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
for (int i = 0; i < ultraGrid1.Rows.Count; i++)
{
row = ultraGrid1.Rows[i];
if (!row.Cells["VALIDFLAG"].Value.ToString().Equals("1"))
{
row.Appearance.ForeColor = Color.Red;
}
else
{
row.Appearance.ForeColor = Color.Black;
}
}
GridHelper.RefreshAndAutoSizeExceptRows(ultraGrid1, new UltraGridColumn[] {
ultraGrid1.DisplayLayout.Bands[0].Columns["MEMO"]
});
}
///
/// GRID ROW激活时信息带至编辑区
///
///
///
private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
{
Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGrid1.ActiveRow;
if (row != null)
{
//CRAFT_CODE,CRAFTITEM_DESC,CRAFTITEM_TYPE,CRAFTITEM_LV
txtName.Text = row.Cells["CRAFTITEM_DESC"].Value.ToString();
VName = txtName.Text.Trim();
cmbParamType.Text = row.Cells["CRAFTITEM_TYPE"].Value.ToString();
cmbStyleName.Value = row.Cells["CRAFTITEM_LV"].Value.ToString();
txtMemo.Text = row.Cells["MEMO"].Value.ToString();
ultraComboEditor1.Value = row.Cells["PROCESS_CODE"].Value.ToString();
}
}
///
/// 作废或恢复
///
/// true作废 false恢复
private void doDeleteOrResume(bool isDelete)
{
ultraGrid1.UpdateData();
if (ultraGrid1.ActiveRow == null)
{
MessageBox.Show("请选择需要" + (isDelete ? "作废" : "恢复") + "的数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string validflagStr = ultraGrid1.ActiveRow.Cells["VALIDFLAG"].Value.ToString();
//无效数据不允许作废
if ("0".Equals(validflagStr))
{
if (isDelete)
{
MessageBox.Show("无效数据不支持作废操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
else
{
//有效数据不允许恢复
if (!isDelete)
{
MessageBox.Show("有效数据不支持恢复操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (MessageBox.Show("是否确认" + (isDelete ? "作废" : "恢复") + "选中的数据!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
ArrayList param = new ArrayList();
string craftCode = ultraGrid1.ActiveRow.Cells["CRAFT_CODE"].Value.ToString();
param.Add(craftCode);
int count = ServerHelper.SetData("com.steering.pss.qcm.CoreProcessParameters.deleteLineInfo", new Object[] { param, UserInfo.GetUserName(), isDelete }, this.ob);
if (count > 0)
{
doQuery();
Infragistics.Win.UltraWinGrid.UltraGridRow rowD = null;
for (int i = 0; i < ultraGrid1.Rows.Count; i++)
{
rowD = ultraGrid1.Rows[i];
if (rowD.Cells["CRAFT_CODE"].Value.ToString().Equals(craftCode))
{
rowD.Activate();
break;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
{
if (ultraCheckEditor1.Checked)
{
txtTitleName.ReadOnly = false;
}
else
{
txtTitleName.ReadOnly = true;
}
}
}
}