public void test1(string Barcode)
{
if (ComboBox1.SelectedItem.Value == "待定" || ComboBox2.SelectedItem.Value == "待定")
{
Ext.Msg.Alert("提示", "您必须选择工序和流向信息！").Show();
return;
}
//用户登陆名
string Id = SessionUser.ID;//"00002";//
//获取工序
//string[] process_probable = Hidden3.Text.Split('或');
string msg;
WSProcedureCtrl.ProcedureCtrl c = new MCSApp.WSProcedureCtrl.ProcedureCtrl();
WSProductTrace.ProductTrace P = new MCSApp.WSProductTrace.ProductTrace();
//如果品号未通过
if (!c.CheckModel(Barcode.Substring(0, 9), Id))
{
Ext.Msg.Alert("错误", "当前产品不是正在生产的产品。").Show();
return;
}
////这时还需要收集工艺信息
//if (Hidden4.Text == "待定")
//{
// //第一步：判断是否为新入工序的产品
// if (!c.CheckProcedure(Barcode, string.Empty, 0, out msg) && msg == "根据输入的条形码未查询到对应的产品")
// {
// P.SaveProduct(Id, Barcode, Barcode.Substring(0, 9), "", out msg);
// }
// //确定可能正确的工序
// for (int i = 0; i < process_probable.Length; i++)
// {
// if (c.CheckProcedure(Barcode, process_probable[i], 0, out msg))
// {
// Label3.Text = process_probable[i];
// Hidden3.Text = process_probable[i];
// Label4.Text = "入";
// Hidden4.Text = "入";
// break;
// }
// if (c.CheckProcedure(Barcode, process_probable[i], 1, out msg))
// {
// Label3.Text = process_probable[i];
// Hidden3.Text = process_probable[i];
// Label4.Text = "出";
// Hidden4.Text = "出";
// break;
// }
// }
// if (Hidden4.Text == "待定")
// {
// Ext.Msg.Alert("错误", msg).Show();
// return;
// }
if (Hidden_s.Value.ToString() != "")
{
Hidden_s.Value = string.Empty;
//自动提取已完工的数据清单
{
List<object[]> data = (List<object[]>)Cache["data"];
if (data == null) data = new List<object[]>();
string sql1 = "select ProductID, Name from dbo.TB_ProcedureHistory,dbo.TA_Employee where ProductID like '" + Barcode.Substring(0, 9) + "A%' and Process ='" + ComboBox1.SelectedItem.Value + "'";
if (ComboBox2.SelectedItem.Value == "出") sql1 += " and Result=0";
sql1 += " and TA_Employee.ID=EmployeeID";
SqlAccess sqlAccess = new SqlAccess();
DataTable mytab = sqlAccess.OpenQuerry(sql1).Tables[0];
foreach (DataRow row in mytab.Rows)
{
int id = (data.Count + 1);
string Barcode1 = row["ProductID"].ToString();
string ModelId = row["ProductID"].ToString().Substring(0, 9);
string PlanId = string.Empty;
string Process = ComboBox1.SelectedItem.Value;
string User = row["Name"].ToString();
{
SqlAccess sqlAccess1 = new SqlAccess();
DataRow myrow;
try
{
myrow = sqlAccess.OpenQuerry("select * from TC_PlanProcedure where ModelId= '" + ModelId + "'").Tables[0].Rows[0];
PlanId = myrow["PlanId"].ToString();
}
catch { }
}
data.Add(new object[] { id, Barcode1, PlanId, ModelId, Process, User });
}
Cache["data"] = data;
}
}
//}
//如果是新产品
if (!c.CheckProcedure(Barcode, string.Empty, 0, out msg) && msg == "根据输入的条形码未查询到对应的产品")
{
P.SaveProduct(Id, Barcode, Barcode.Substring(0, 9), "", out msg);
}
if (!c.CheckProcedure(Barcode, ComboBox1.SelectedItem.Value, ComboBox2.SelectedItem.Value == "入" ? 0 : 1, out msg))
{
Ext.Msg.Alert("错误", msg).Show();
return;
}
if (ComboBox2.SelectedItem.Value == "入")
{
if (!c.SaveProcessBegin(Barcode, ComboBox1.SelectedItem.Value, Id, DateTime.Now, out msg)) Ext.Msg.Alert("工序保存错误", msg);
}
if (ComboBox2.SelectedItem.Value == "出")
{
if (!c.SaveProcessEnd(Barcode, ComboBox1.SelectedItem.Value, 0, string.Empty, string.Empty, DateTime.Now, out msg)) Ext.Msg.Alert("工序保存错误", msg);
}
//下面是填充已扫描的列表数据--------------------------------------------------------------------------------------------------------------
{
List<object[]> data = (List<object[]>)Cache["data"];
if (data == null) data = new List<object[]>();
int id = (data.Count + 1);
string ModelId = Barcode.Substring(0, 9);
string PlanId = string.Empty;
string Process = ComboBox1.SelectedItem.Value;
string User = SessionUser.Name;
SqlAccess sqlAccess = new SqlAccess();
DataRow myrow;
try
{
myrow = sqlAccess.OpenQuerry("select * from TC_PlanProcedure where ModelId= '" + ModelId + "'").Tables[0].Rows[0];
}
catch { myrow = null; }
if (myrow != null)
{
PlanId = myrow["PlanId"].ToString();
data.Add(new object[] { id, Barcode, PlanId, ModelId, Process, User });
Cache["data"] = data;
}
else
{
Ext.Msg.Alert("警告", Barcode + "并不是正在生产的产品。").Show();
}
Cache["data"] = data;
this.Store2.DataSource = data;
this.Store2.DataBind();
}
}
public void test1(string Barcode)
{
if (ComboBox1.SelectedItem.Value == "待定" || ComboBox2.SelectedItem.Value == "待定")
{
Ext.Msg.Alert("提示", "您必须选择工序和流向信息！").Show();
return;
}
//用户登陆名
string Id = SessionUser.ID;//"00002";//
//获取工序
//string[] process_probable = Hidden3.Text.Split('或');
string msg;
WSProcedureCtrl.ProcedureCtrl c = new MCSApp.WSProcedureCtrl.ProcedureCtrl();
WSProductTrace.ProductTrace P = new MCSApp.WSProductTrace.ProductTrace();
//如果品号未通过
if (!c.CheckModel(Barcode.Substring(0, 9), Id))
{
Ext.Msg.Alert("错误", "当前产品不是正在生产的产品。").Show();
return;
}
////这时还需要收集工艺信息
//if (Hidden4.Text == "待定")
//{
// //第一步：判断是否为新入工序的产品
// if (!c.CheckProcedure(Barcode, string.Empty, 0, out msg) && msg == "根据输入的条形码未查询到对应的产品")
// {
// P.SaveProduct(Id, Barcode, Barcode.Substring(0, 9), "", out msg);
// }
// //确定可能正确的工序
// for (int i = 0; i < process_probable.Length; i++)
// {
// if (c.CheckProcedure(Barcode, process_probable[i], 0, out msg))
// {
// Label3.Text = process_probable[i];
// Hidden3.Text = process_probable[i];
// Label4.Text = "入";
// Hidden4.Text = "入";
// break;
// }
// if (c.CheckProcedure(Barcode, process_probable[i], 1, out msg))
// {
// Label3.Text = process_probable[i];
// Hidden3.Text = process_probable[i];
// Label4.Text = "出";
// Hidden4.Text = "出";
// break;
// }
// }
// if (Hidden4.Text == "待定")
// {
// Ext.Msg.Alert("错误", msg).Show();
// return;
// }
if (Hidden_s.Value.ToString() != "")
{
Hidden_s.Value = string.Empty;
//自动提取已完工的数据清单
{
List <object[]> data = (List <object[]>)Cache["data"];
if (data == null)
{
data = new List <object[]>();
}
string sql1 = "select ProductID, Name from dbo.TB_ProcedureHistory,dbo.TA_Employee where ProductID like '" + Barcode.Substring(0, 9) + "A%' and Process ='" + ComboBox1.SelectedItem.Value + "'";
if (ComboBox2.SelectedItem.Value == "出")
{
sql1 += " and Result=0";
}
sql1 += " and TA_Employee.ID=EmployeeID";
SqlAccess sqlAccess = new SqlAccess();
DataTable mytab = sqlAccess.OpenQuerry(sql1).Tables[0];
foreach (DataRow row in mytab.Rows)
{
int id = (data.Count + 1);
string Barcode1 = row["ProductID"].ToString();
string ModelId = row["ProductID"].ToString().Substring(0, 9);
string PlanId = string.Empty;
string Process = ComboBox1.SelectedItem.Value;
string User = row["Name"].ToString();
{
SqlAccess sqlAccess1 = new SqlAccess();
DataRow myrow;
try
{
myrow = sqlAccess.OpenQuerry("select * from TC_PlanProcedure where ModelId= '" + ModelId + "'").Tables[0].Rows[0];
PlanId = myrow["PlanId"].ToString();
}
catch { }
}
data.Add(new object[] { id, Barcode1, PlanId, ModelId, Process, User });
}
Cache["data"] = data;
}
}
//}
//如果是新产品
if (!c.CheckProcedure(Barcode, string.Empty, 0, out msg) && msg == "根据输入的条形码未查询到对应的产品")
{
P.SaveProduct(Id, Barcode, Barcode.Substring(0, 9), "", out msg);
}
if (!c.CheckProcedure(Barcode, ComboBox1.SelectedItem.Value, ComboBox2.SelectedItem.Value == "入" ? 0 : 1, out msg))
{
Ext.Msg.Alert("错误", msg).Show();
return;
}
if (ComboBox2.SelectedItem.Value == "入")
{
if (!c.SaveProcessBegin(Barcode, ComboBox1.SelectedItem.Value, Id, DateTime.Now, out msg))
{
Ext.Msg.Alert("工序保存错误", msg);
}
}
if (ComboBox2.SelectedItem.Value == "出")
{
if (!c.SaveProcessEnd(Barcode, ComboBox1.SelectedItem.Value, 0, string.Empty, string.Empty, DateTime.Now, out msg))
{
Ext.Msg.Alert("工序保存错误", msg);
}
}
//下面是填充已扫描的列表数据--------------------------------------------------------------------------------------------------------------
{
List <object[]> data = (List <object[]>)Cache["data"];
if (data == null)
{
data = new List <object[]>();
}
int id = (data.Count + 1);
string ModelId = Barcode.Substring(0, 9);
string PlanId = string.Empty;
string Process = ComboBox1.SelectedItem.Value;
string User = SessionUser.Name;
SqlAccess sqlAccess = new SqlAccess();
DataRow myrow;
try
{
myrow = sqlAccess.OpenQuerry("select * from TC_PlanProcedure where ModelId= '" + ModelId + "'").Tables[0].Rows[0];
}
catch { myrow = null; }
if (myrow != null)
{
PlanId = myrow["PlanId"].ToString();
data.Add(new object[] { id, Barcode, PlanId, ModelId, Process, User });
Cache["data"] = data;
}
else
{
Ext.Msg.Alert("警告", Barcode + "并不是正在生产的产品。").Show();
}
Cache["data"] = data;
this.Store2.DataSource = data;
this.Store2.DataBind();
}
}
