using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.LZMes.Client.UIE;
using System.Collections;
namespace Core.LZMes.Client.UIM
{
public partial class UIM010290 : FrmBase
{
public UIM010290()
{
InitializeComponent();
}
private void init()
{
string commCodeCd = "M01001";
DataTable dt = new DataTable();
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "UIB.COM.ComDBQuery";
ccp.MethodName = "doSimpleQuery";
System.Collections.ArrayList paramArray = new System.Collections.ArrayList();
paramArray.Add("UIECOMM00_SELECT.COMM_CODE");
paramArray.Add(commCodeCd);
ccp.ServerParams = new object[] { paramArray };
ccp.SourceDataTable = dt;
this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOrdProc, ref dt, "M01001");
}
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "Query":
this.DoQuery();
break;
case "Save":
this.DoSave();
break;
case "setDefectiveCoil":
this.setDefectiveCoil();
break;
case "unsetDefectiveCoil":
this.unsetDefectiveCoil();
break;
}
}
///
/// 查询待入库钢卷
///
private void DoQuery()
{
try
{
this.dataSet1.Tables[0].Clear();
string procuctedTime = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";
string procuctedTime2 = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") : "";
string coilNo = textBox9.Text.Trim();
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "UIB.COM.ComDBQuery";
ccp.MethodName = "doSimpleQuery";
System.Collections.ArrayList paramArray = new System.Collections.ArrayList();
if (this.CustomInfo=="2")
paramArray.Add("UIM010290_04.SELECT");
else
paramArray.Add("UIM010290_03.SELECT");
paramArray.Add(coilNo);
paramArray.Add(procuctedTime);
paramArray.Add(procuctedTime2);
paramArray.Add(coilNo);
ccp.ServerParams = new object[] { paramArray };
ccp.SourceDataTable = this.dataSet1.Tables[0];
this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
textBox1.Text = "";
}
catch (Exception EX)
{
MessageBox.Show(EX.ToString());
}
}
///
/// 待处理钢卷保存
///
private void DoSave()
{
string entryShift = UserInfo.GetUserOrder();//入库班次
string entryGroup = UserInfo.GetUserGroup();//入库班组
string reg_id = UserInfo.GetUserID();//操作人
string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型
string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型
string fbreason = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox2.Text));//封闭原因
string msg = "";
string line = "";
if (this.CustomInfo == "2") line = "S";
else line = "L";
this.ultraGrid1.UpdateData();
StringBuilder strBf = new StringBuilder();
DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'");
for (int i = 0; i < selectedRows.Length; i++)
{
strBf.Append(selectedRows[i]["COIL_NO"]).Append("|");
}
Hashtable paramHsmp = new Hashtable();
paramHsmp.Add("i1", reg_id);
paramHsmp.Add("i2", entryShift);
paramHsmp.Add("i3", entryGroup);
paramHsmp.Add("i4", mdType);
paramHsmp.Add("i5", strBf.ToString());
paramHsmp.Add("i6", line);
paramHsmp.Add("i7", fbreason);
paramHsmp.Add("o8", msg);
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "UIB.COM.ComDBProcedure";
ccp.MethodName = "doXmlProcedure";
ccp.ServerParams = new object[] { "UIM010290_03.CALL", paramHsmp };
ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (0 == ccp.ReturnCode)
{
MessageBox.Show("操作成功!");
}
DoQuery();
}
///
/// 次品卷指定
///
private void setDefectiveCoil()
{
/*
for (int i = 0; i < this.ultraGrid1.Rows.Count; i++)
{
if(this.ultraGrid1.Rows[i].Cells["CHK"].Value.Equals("Y"))
{
str.Append(this.ultraGrid1.Rows[i].Cells["COIL_NO"].Value).Append(",");
}
}*/
this.ultraGrid1.UpdateData();
StringBuilder strBf = new StringBuilder();
DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'");
for (int i = 0; i < selectedRows.Length; i++)
{
strBf.Append(selectedRows[i]["COIL_NO"]).Append("|");
}
string entryShift = UserInfo.GetUserOrder();//入库班次
string entryGroup = UserInfo.GetUserGroup();//入库班组
string reg_id = UserInfo.GetUserID();//操作人
string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型
//string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型
string msg = "";
string line = "";
if (this.CustomInfo == "2") line = "S";
else line = "L";
Hashtable paramHsmp = new Hashtable();
paramHsmp.Add("i1", reg_id);
paramHsmp.Add("i2", entryShift);
paramHsmp.Add("i3", entryGroup);
paramHsmp.Add("i4", "02"); // M01002 01:取消 02:指定
paramHsmp.Add("i5", strBf.ToString());
paramHsmp.Add("i6", line);
paramHsmp.Add("o7", msg);
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "UIB.COM.ComDBProcedure";
ccp.MethodName = "doXmlProcedure";
ccp.ServerParams = new object[] { "UIM010290_04.CALL", paramHsmp };
ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (0 == ccp.ReturnCode)
{
MessageBox.Show("操作成功!");
}
DoQuery();
}
///
/// 次品卷指定
///
private void unsetDefectiveCoil()
{
/*
String str = "";
for (int i = 0; i < this.ultraGrid1.Rows.Count; i++)
{
if (this.ultraGrid1.Rows[i].Cells["CHK"].Value.Equals("Y"))
{
str = str + this.ultraGrid1.Rows[i].Cells[""].Value + ",";
}
}*/
this.ultraGrid1.UpdateData();
StringBuilder strBf = new StringBuilder();
DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'");
for (int i = 0; i < selectedRows.Length; i++)
{
strBf.Append(selectedRows[i]["COIL_NO"]).Append("|");
}
string entryShift = UserInfo.GetUserOrder();//入库班次
string entryGroup = UserInfo.GetUserGroup();//入库班组
string reg_id = UserInfo.GetUserID();//操作人
string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型
//string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型
string msg = "";
string line = "";
if (this.CustomInfo == "2") line = "S";
else line = "L";
Hashtable paramHsmp = new Hashtable();
paramHsmp.Add("i1", reg_id);
paramHsmp.Add("i2", entryShift);
paramHsmp.Add("i3", entryGroup);
paramHsmp.Add("i4", "01"); // M01002 01:取消 02:指定
paramHsmp.Add("i5", strBf.ToString());
paramHsmp.Add("i6", line);
paramHsmp.Add("o7", msg);
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "UIB.COM.ComDBProcedure";
ccp.MethodName = "doXmlProcedure";
ccp.ServerParams = new object[] { "UIM010290_04.CALL", paramHsmp };
ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (0 == ccp.ReturnCode)
{
MessageBox.Show("操作成功!");
}
DoQuery();
}
private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
{
}
private void UIM010290_Load(object sender, EventArgs e)
{
init();
}
private void ultraGrid1_MouseDoubleClick(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
{
textBox1.Text = e.Row.Cells["COIL_NO"].Value.ToString();
}
private void button1_Click(object sender, EventArgs e)
{
int jx = 1;
string mod_name = this.UserInfo.GetUserName();
DataRow[] selectedRows = dataSet1.Tables[0].Select("CHK ='True'");
for (int i = 0; i < selectedRows.Length; i++)
{
string coilno = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["COIL_NO"]));
string ycscczyj = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["YCSCCZYJ"]));
string ycjsczyj = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["YCJSCZYJ"]));
Hashtable ht = new Hashtable();
ht.Add("i" + jx, coilno); jx++;//卷号
ht.Add("i" + jx, ycscczyj); jx++;//生产意见
ht.Add("i" + jx, ycjsczyj); jx++;//技术意见
ht.Add("i" + jx, mod_name); jx++;//变更人
ht.Add("o" + jx, ""); jx = 1;
CoreClientParam ccp1 = new CoreClientParam();
ccp1.ServerName = "UIB.COM.ComDBProcedure";
ccp1.MethodName = "doXmlProcedure";
ccp1.ServerParams = new object[] { "UIM010290_06.CALL", ht };
this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal);
ArrayList all = ccp1.ReturnObject as ArrayList;
if (all[0].ToString() != "YY")//确认是否存在问题
{
MessageBox.Show(all[0].ToString(), "提示");
return;
}
}
MessageBox.Show("录入成功", "提示");
DoQuery();
}
}
}