internal bool ReadList(out List <RawMaterialsDetailModel> data) { bool flag = true; data = new List <RawMaterialsDetailModel>(); string sql = "select b.Number as Code,b.Name as Name,total(a.Number) as Amount from T_Warehouse_RawMaterials a left join T_ProductInfo_RawMaterials b on a.RawMaterialsID = b.GUID group by a.RawMaterialsID"; DataSet ds = new DataSet(); flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds); if (flag) { int id = 1; foreach (DataRow dr in ds.Tables[0].Rows) { RawMaterialsDetailModel d = new RawMaterialsDetailModel(); d.Id = id; id++; d.Code = dr["Code"].ToString(); d.Name = dr["Name"].ToString(); d.Amount = dr["Amount"].ToString(); data.Add(d); } } return(flag); }
/// <summary> /// Lugia /// 获取原料信息 /// </summary> /// <param name="Number"></param> /// <returns></returns> internal RawMaterialsDetailModel GetRawMaterialsInfo(string Number) { RawMaterialsDetailModel m = new RawMaterialsDetailModel(); string sql = "Select Guid,Name From T_ProductInfo_RawMaterials Where Number='" + Number + "' AND DeleteMark ISNULL"; DataSet ds = new DataSet(); if (new Helper.SQLite.DBHelper().QueryData(sql, out ds)) { foreach (DataRow dr in ds.Tables[0].Rows) { m.RawMaterialsID = (Guid)dr["Guid"]; m.Name = dr["Name"].ToString(); } } return(m); }
public Page_Warehouse_RawMaterials() { InitializeComponent(); data = new List <RawMaterialsDetailModel>(); for (int i = 0; i < 18; i++) { RawMaterialsDetailModel m = new RawMaterialsDetailModel(); m.Id = i + 1; m.Date = DateTime.Now.ToString("yyyy.MM.dd"); m.Operator = Helper.DataDefinition.CommonParameters.RealName; m.RawMaterialsID = new Guid(); m.Type = "入库"; data.Add(m); } DataGrid_RawMaterials.ItemsSource = data; }
private void DataGrid_RawMaterialsQuantity_LoadingRow(object sender, DataGridRowEventArgs e) { e.Row.MouseRightButtonDown += (s, a) => { a.Handled = true; (sender as DataGrid).SelectedIndex = (s as DataGridRow).GetIndex(); (s as DataGridRow).Focus(); RawMaterialsDetailModel d = this.DataGrid_RawMaterialsQuantity.SelectedCells[0].Item as RawMaterialsDetailModel; //show Packing Grid this.Label_ShowWarnMessage.Content = ""; this.Grid_OutGrid.Visibility = System.Windows.Visibility.Visible; int count = 0; int.TryParse(d.Amount, out count); PackStock = count; PCode = d.Code; this.TextBox_Quantity_OutGrid.Focus(); this.Label_RawMaterialsName.Content = d.Name; }; }
internal bool ReadRecordList(string Type, out List <RawMaterialsDetailModel> data) { string sql_Where = ""; if (!Type.StartsWith("全部")) { sql_Where += " Where a.Type='" + Type + "' "; } bool flag = true; data = new List <RawMaterialsDetailModel>(); string sql = " select a.Guid as Guid,a.RawMaterialsID as RawMaterialsID,b.Name as Name,strftime(a.Date) as Date,a.Operator as Operator,a.Number as Number,a.Remark as Remark,a.Type as Type " + " from T_Warehouse_RawMaterials a " + " left join T_ProductInfo_RawMaterials b on a.RawMaterialsID = b.Guid " + sql_Where + " order by a.Date desc "; DataSet ds = new DataSet(); flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds); if (flag) { int id = 1; foreach (DataRow dr in ds.Tables[0].Rows) { RawMaterialsDetailModel d = new RawMaterialsDetailModel(); d.Id = id; id++; d.Guid = Guid.Parse(dr["Guid"].ToString()); d.RawMaterialsID = Guid.Parse(dr["RawMaterialsID"].ToString()); d.Date = dr["Date"].ToString(); decimal dd = 0; decimal.TryParse(dr["Number"].ToString(), out dd); d.Number = dd; d.Name = dr["Name"].ToString(); d.Remark = dr["Remark"].ToString(); d.Operator = dr["Operator"].ToString(); d.Type = dr["Type"].ToString(); data.Add(d); } } return(flag); }
private void Button_OutGrid_Click(object sender, RoutedEventArgs e) { List <RawMaterialsDetailModel> list = new List <RawMaterialsDetailModel>(); RawMaterialsDetailModel m = new RawMaterialsDetailModel(); m.RawMaterialsID = rmc.GetGuid(PCode); m.Type = RadioButton_生产.IsChecked == true ? "生产" : "出库"; m.Date = DateTime.Now.ToString(); int Number = 0; int.TryParse(this.TextBox_Quantity_OutGrid.Text, out Number); m.Number = Number; m.Operator = Helper.DataDefinition.CommonParameters.RealName; list.Add(m); if (rmc.AddByBatch(list, false)) { InitializeRawMaterialsDataGrid(); this.Grid_OutGrid.Visibility = System.Windows.Visibility.Collapsed; } }
private void DataGrid_RawMaterials_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e) { RawMaterialsDetailModel model = this.DataGrid_RawMaterials.SelectedCells[0].Item as RawMaterialsDetailModel; string newValue = (e.EditingElement as TextBox).Text; string HeaderStr = e.Column.Header.ToString(); if (HeaderStr.Equals("原材料编号")) { RawMaterialsDetailModel m = vmc.GetRawMaterialsInfo(newValue); if (m.RawMaterialsID != new Guid()) { data[data.IndexOf(model)].RawMaterialsID = m.RawMaterialsID; data[data.IndexOf(model)].Code = newValue; data[data.IndexOf(model)].Name = m.Name; } else { data[data.IndexOf(model)].RawMaterialsID = new Guid(); data[data.IndexOf(model)].Code = newValue; data[data.IndexOf(model)].Name = ""; DataGrid_RawMaterials.CurrentCell = new DataGridCellInfo(DataGrid_RawMaterials.SelectedCells[0].Item, DataGrid_RawMaterials.Columns[1]); } } }