internal Model_AssemblyLineModuleBatchInput ReadProductInfo(string Number) { Model_AssemblyLineModuleBatchInput m = new Model_AssemblyLineModuleBatchInput(); string sql = "SELECT GUID,Name,P1,P2,P3,P4,P5,P6 FROM T_ProductInfo_Product WHERE NUMBER='" + Number + "' AND DELETEMARK ISNULL"; DataSet ds = new DataSet(); bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds); if (flag) { foreach (DataRow dr in ds.Tables[0].Rows) { m.ProductGuid = (Guid)dr["GUID"]; m.ProductNumber = Number; m.ProductName = dr["Name"].ToString(); for (int i = 0; i < 6; i++) { if (dr["P" + (i + 1)].ToString() != "无") { m.ProcessList[i] = dr["P" + (i + 1)].ToString(); m.ProcessListStr += dr["P" + (i + 1)].ToString() + ","; } } m.ProcessListStr = m.ProcessListStr.Substring(0, m.ProcessListStr.Length - 1); } } return(m); }
private void DataGrid_BatchInput_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e) { Model_AssemblyLineModuleBatchInput model = this.DataGrid_BatchInput.SelectedCells[0].Item as Model_AssemblyLineModuleBatchInput; string newValue = (e.EditingElement as TextBox).Text.Trim(); string Header = e.Column.Header.ToString(); if (Header == "产品编号") { Model_AssemblyLineModuleBatchInput m = new AssemblyLineModuleBatchInputConsole().ReadProductInfo(newValue); if (m.ProductGuid == new Guid()) { DataGrid_BatchInput.CurrentCell = new DataGridCellInfo(DataGrid_BatchInput.SelectedCells[0].Item, DataGrid_BatchInput.Columns[0]); data[data.IndexOf(model)].ProductGuid = new Guid(); data[data.IndexOf(model)].ProductName = ""; data[data.IndexOf(model)].ProcessList = new string[6]; data[data.IndexOf(model)].ProcessListStr = ""; } else { data[data.IndexOf(model)].ProductGuid = m.ProductGuid; data[data.IndexOf(model)].ProductName = m.ProductName; data[data.IndexOf(model)].ProcessList = m.ProcessList; data[data.IndexOf(model)].ProcessListStr = m.ProcessListStr; } } else if (Header == "工序") { int ProcessNum = 0; int.TryParse(newValue, out ProcessNum); if (ProcessNum <= 6 && ProcessNum > 0 && data[data.IndexOf(model)].ProcessList[ProcessNum - 1] != null) { data[data.IndexOf(model)].Process = data[data.IndexOf(model)].ProcessList[ProcessNum - 1]; } else { DataGrid_BatchInput.CurrentCell = new DataGridCellInfo(DataGrid_BatchInput.SelectedCells[0].Item, DataGrid_BatchInput.Columns[2]); } } else if (Header == "员工编号") { Model_AssemblyLineModuleBatchInput m = new AssemblyLineModuleBatchInputConsole().ReadStaffInfo(newValue); if (m.StaffGuid == new Guid()) { DataGrid_BatchInput.CurrentCell = new DataGridCellInfo(DataGrid_BatchInput.SelectedCells[0].Item, DataGrid_BatchInput.Columns[3]); data[data.IndexOf(model)].StaffGuid = new Guid(); data[data.IndexOf(model)].StaffName = ""; return; } data[data.IndexOf(model)].StaffGuid = m.StaffGuid; data[data.IndexOf(model)].StaffName = m.StaffName; } }
internal Model_AssemblyLineModuleBatchInput ReadStaffInfo(string Number) { Model_AssemblyLineModuleBatchInput m = new Model_AssemblyLineModuleBatchInput(); string sql = "SELECT GUID,Name FROM T_UserInfo_Staff WHERE NUMBER='" + Number + "' AND DELETEMARK ISNULL"; DataSet ds = new DataSet(); bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds); if (flag) { foreach (DataRow dr in ds.Tables[0].Rows) { m.StaffGuid = (Guid)dr["GUID"]; m.StaffNumber = Number; m.StaffName = dr["Name"].ToString(); } } return(m); }
/// <summary> /// 编辑时读取记录明细 /// </summary> /// <returns></returns> internal ObservableCollection <Model_AssemblyLineModuleBatchInput> ReadDatas(Model_BatchInputOrder OrderData) { ObservableCollection <Model_AssemblyLineModuleBatchInput> data = new ObservableCollection <Model_AssemblyLineModuleBatchInput>(); Model_AssemblyLineModuleBatchInput m; DataSet ds = new DataSet(); string sql = "Select a.*," + " p.Guid as PGuid,p.Number as PNumber,p.Name as PName,p.P1,p.P2,p.P3,p.P4,p.P5,p.P6, " + " s.Guid as SGuid,s.Number as SNumber,s.Name as SName " + " from T_PM_ProductionSchedule a " + " left join T_ProductInfo_Product p ON a.ProductID=p.Guid " + " left join T_UserInfo_Staff s ON a.StaffID=s.Guid " + " WHERE a.Obligate1='" + OrderData.Guid + "' " + " AND a.DeleteMark ISNULL " + " AND a.Remark<>'自动扣半成品原料' " ; if (new Helper.SQLite.DBHelper().QueryData(sql, out ds)) { foreach (DataRow dr in ds.Tables[0].Rows) { m = new Model_AssemblyLineModuleBatchInput(); //Product Info m.ProductGuid = (Guid)dr["PGuid"]; m.ProductNumber = dr["PNumber"].ToString(); m.ProductName = dr["PName"].ToString(); for (int i = 0; i < 6; i++) { if (dr["P" + (i + 1)].ToString() != "无") { m.ProcessList[i] = dr["P" + (i + 1)].ToString(); m.ProcessListStr += dr["P" + (i + 1)].ToString() + ","; } } m.ProcessListStr = m.ProcessListStr.Substring(0, m.ProcessListStr.Length - 1); //Staff Info m.StaffGuid = (Guid)dr["SGuid"]; m.StaffNumber = dr["SNumber"].ToString(); m.StaffName = dr["SName"].ToString(); //Input Info m.Process = dr["Process"].ToString(); m.Quantity = int.Parse(dr["Number"].ToString()); m.Injure = int.Parse(dr["Break"].ToString()); data.Add(m); } } if (data.Count < 20) { int COUNT = data.Count; for (int i = 0; i < 20 - COUNT; i++) { data.Add(new Model_AssemblyLineModuleBatchInput { Id = i + 1 }); } } return(data); }