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