private void Button_删除_Click(object sender, System.Windows.RoutedEventArgs e) { if (this.DataGrid_List.SelectedCells.Count > 0) { if (MessageBox.Show("确认删除订单?", "警告", MessageBoxButton.YesNo) == MessageBoxResult.No) { return; } Model_圆片订单 m = this.DataGrid_List.SelectedCells[0].Item as Model_圆片订单; if (new ViewModel.Orders.Vm_Order_圆片().Delete(m.Guid)) { MessageBox.Show("删除成功"); InitDataGrid(); Helper.Events.MeansOfProduction.Event_圆片.OnUpdate圆片库存(); } } }
public bool Add(Model_圆片订单 data) { List <string> sqls = new List <string>(); sqls.Add("Insert into T_Order_Wafer values('" + data.Guid + "'," + data.OrderType + ",'" + data.单号 + "','" + data.单日期 + "','" + data.备注 + "')"); foreach (Model_圆片仓库 m in data.明细) { if (m.Guid != new Guid() && m.数量 != 0) { if (data.OrderType == 0) { m.数量 = -m.数量; sqls.Add("Insert into T_Warehouse_HalfProduct(Guid,ProductID,Date,Operator,Quantity,OrderGuid) values('" + Guid.NewGuid() + "','" + m.半成品Guid + "','" + data.单日期 + "',''," + m.半成品数量 + ",'" + data.Guid + "')"); } sqls.Add("Insert into T_Warehouse_Wafer values('" + Guid.NewGuid() + "','" + data.Guid + "','" + m.Guid + "'," + m.数量 + "," + m.损耗数量 + ",'" + m.半成品Guid + "'," + m.半成品数量 + ")"); } } if (sqls.Count == 1)//无明细记录返回false { return(false); } return(new Helper.SQLite.DBHelper().Transaction(sqls)); }
public List <Model_圆片订单> ReadList(int inOut, DateTime start, DateTime end) { List <Model_圆片订单> data = new List <Model_圆片订单>(); string sql = "SELECT " + " a.*," + " b.Quantity,b.LossQuantity,b.HalfProductGuid,b.HalfProductQuantity," + " c.Number,c.Diameter,c.Thickness, " + " d.Number as PNumber,d.Name as PName " + "FROM " + " T_Order_Wafer a " + "Left join T_Warehouse_Wafer b on a.Guid=b.OrderGuid " + "Left join T_ProductInfo_Wafer c on b.WaferGuid=c.Guid " + "Left Join T_ProductInfo_Product d ON d.Guid=b.HalfProductGuid " + "where a.OrderType=" + inOut + " " + " AND a.Date Between '" + start.ToString("yyyy-MM-dd 00:00:00") + "' And '" + end.ToString("yyyy-MM-dd 23:59:59") + "' " + "Order By a.Date,c.Number " ; DataSet ds = new DataSet(); if (new Helper.SQLite.DBHelper().QueryData(sql, out ds)) { int rowid = 1; Guid lastOrderGuid = new Guid(); Model_圆片订单 m = new Model_圆片订单 { 序号 = 0 }; foreach (DataRow dr in ds.Tables[0].Rows) { if (lastOrderGuid != dr.Field <Guid>("Guid")) { if (lastOrderGuid != new Guid()) { data.Add(m); } m = new Model_圆片订单 { 序号 = rowid++ }; lastOrderGuid = dr.Field <Guid>("Guid"); m.Guid = lastOrderGuid; m.OrderType = inOut; m.单号 = dr.Field <string>("OrderNo"); m.单日期 = dr.Field <DateTime>("Date").ToString("yyyy-MM-dd"); m.备注 = dr.Field <string>("Remark"); m.编号s += dr.Field <string>("Number"); m.直径s += dr.Field <string>("Diameter"); m.厚度s += dr.Field <string>("Thickness"); m.数量s += inOut == 1 ? dr.Field <Int64?>("Quantity") : -dr.Field <Int64?>("Quantity"); m.损耗数量s += dr.Field <Int64?>("LossQuantity"); m.半成品数量s += dr.Field <Int64?>("HalfProductQuantity"); m.入库半成品编号s += dr.Field <string>("PNumber"); m.半成品品名s += dr.Field <string>("PName"); } else { m.编号s += "\n" + dr.Field <string>("Number"); m.直径s += "\n" + dr.Field <string>("Diameter"); m.厚度s += "\n" + dr.Field <string>("Thickness"); m.数量s += "\n" + (inOut == 1 ? dr.Field <Int64?>("Quantity") : -dr.Field <Int64?>("Quantity")); m.损耗数量s += "\n" + dr.Field <Int64?>("LossQuantity"); m.半成品数量s += "\n" + dr.Field <Int64?>("HalfProductQuantity"); m.入库半成品编号s += "\n" + dr.Field <string>("PNumber"); m.半成品品名s += "\n" + dr.Field <string>("PName"); } } if (m.序号 != 0) { data.Add(m); } } return(data); }