private List <Result> SearchResults(string op, string name, DateTime sdate, DateTime edate) { try { using (WareHouseEntities en = new WareHouseEntities()) { var lstInOut = en.InOuts.Include(p => p.Material) .Where(x => x.Material.Name.Contains(name)) .Where(x => x.Date >= sdate && x.Date <= edate); if (op == "入库") { lstInOut = lstInOut.Where(x => x.IsIn); } else { lstInOut = lstInOut.Where(x => !x.IsIn); } return(lstInOut.Select(x => new Result() { Type = op, Name = x.Material.Name, Price = x.Material.Price, Quantity = x.Quantity, Date = x.Date }).ToList()); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(new List <Result>()); } }
private void btnDelete_Click(object sender, EventArgs e) { string name = this.listBox1.SelectedItem.ToString(); try { this.btnDelete.Enabled = false; using (WareHouseEntities en = new WareHouseEntities()) { Material m = en.Materials.First(x => x.Name == name); int id = m.ID; foreach (InOut io in en.InOuts .Where(x => x.MID == id)) { en.InOuts.Remove(io); } en.SaveChanges(); en.Materials.Remove(m); en.SaveChanges(); } this.DisplayAllMaterials(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DisplayAllMaterials() { using (WareHouseEntities en = new WareHouseEntities()) { this.listBox1.Items.Clear(); foreach (Material m in en.Materials) { this.listBox1.Items.Add(m.Name); } } }
public static List <Material> GetAllMaterials() { try { using (WareHouseEntities en = new WareHouseEntities()) { return(en.Materials.ToList()); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(new List <Material>()); } }
public static bool AddInOut(InOut inOut) { try { using (WareHouseEntities en = new WareHouseEntities()) { en.InOuts.Add(inOut); en.SaveChanges(); } return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public static bool DeleteInOut(InOut InOut) { try { using (WareHouseEntities en = new WareHouseEntities()) { InOut inOut = en.InOuts.First(x => x.ID == InOut.ID); en.InOuts.Remove(inOut); en.SaveChanges(); } return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public static InOut GetInOutByVOut(VOut vOut) { try { using (WareHouseEntities en = new WareHouseEntities()) { return(en.InOuts.Include(p => p.Material).First(x => !x.IsIn && x.Material.Name == vOut.Name && x.Quantity == vOut.Quantity && x.Date == vOut.Date)); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
private void ViewAll() { using (WareHouseEntities en = new WareHouseEntities()) { this.lstVIns = new BindingList <VIn>(en.VIns.ToList()); this.dgvIn.DataSource = this.lstVIns; this.lstVOuts = new BindingList <VOut>(en.VOuts.ToList()); this.dgvOut.DataSource = this.lstVOuts; } this.dgvIn.Columns[0].HeaderText = "配件名称"; this.dgvIn.Columns[1].HeaderText = "价格"; this.dgvIn.Columns[2].HeaderText = "数量"; this.dgvIn.Columns[3].HeaderText = "时间"; this.dgvOut.Columns[0].HeaderText = "配件名称"; this.dgvOut.Columns[1].HeaderText = "价格"; this.dgvOut.Columns[2].HeaderText = "数量"; this.dgvOut.Columns[3].HeaderText = "时间"; }
private void btnAdd_Click(object sender, EventArgs e) { try { this.btnAdd.Enabled = false; using (WareHouseEntities en = new WareHouseEntities()) { Material m = new Material(); m.Name = this.txtName.Text.Trim(); m.Price = this.numPrice.Value; en.Materials.Add(m); en.SaveChanges(); } this.DisplayAllMaterials(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static bool EditInOut(int oldInOutID, InOut newInOut) { try { using (WareHouseEntities en = new WareHouseEntities()) { InOut inOut = en.InOuts.First(x => x.ID == oldInOutID); inOut.MID = newInOut.MID; inOut.Quantity = newInOut.Quantity; inOut.Date = newInOut.Date; en.SaveChanges(); } return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }