private void MenuItem_HalfProductIn_Click(object sender, RoutedEventArgs e) { Model_ProductionBookkeeping m = this.DataGrid_ProductionBookkeeping.SelectedCells[0].Item as Model_ProductionBookkeeping; if (m.IsTurn != 0) { MessageBox.Show("此行数据已经添加到半成品仓库中,请勿重复添加!"); return; } else { WarehouseHalpProductModel mm = new WarehouseHalpProductModel(); mm.ProductID = m.ProductGuid; mm.Quantity = m.P4Num; if (new WarehouseHalfProductConsole().Insert(mm) && new ProductionBookkeepingConsole().UpdateTurn(m)) { MessageBox.Show("成功添加" + m.ProductName + "到半成品仓库!"); InitializeData(); HalfProductEvent.OnUpdateDataGrid(); } else { MessageBox.Show("添加失败,请联系管理员!"); } } }
internal bool Insert(WarehouseHalpProductModel m) { string sql = "Insert into T_Warehouse_HalfProduct(Guid,ProductID,Date,Operator,Quantity,Remark) " + " values('" + Guid.NewGuid() + "','" + m.ProductID + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + CommonParameters.LoginUserName + "','" + m.Quantity + "','" + m.Remark + "')"; return(new Helper.SQLite.DBHelper().SingleExecution(sql)); }
internal bool ReadDetailsList(string Search, out List <WarehouseHalpProductModel> data) { string TableName = "T_Warehouse_HalfProduct"; data = new List <WarehouseHalpProductModel>(); string sql = "SELECT" + " a.ProductID,"+ " b.Number,"+ " b.Name,"+ " b.Material,"+ " b.Specification,"+ " b.Type,"+ " total(a.Quantity) as Quantity "+ "FROM " + TableName + " a LEFT JOIN T_ProductInfo_Product b ON a.ProductID = b.GUID where a.deleteMark is null and (b.Number like '%" + Search + "%' or b.Name like '%" + Search + "%')" + "GROUP BY" + " a.ProductID"; DataSet ds = new DataSet(); decimal dd = 0m; if (new Helper.SQLite.DBHelper().QueryData(sql, out ds)) { int id = 1; foreach (DataRow dr in ds.Tables[0].Rows) { WarehouseHalpProductModel d = new WarehouseHalpProductModel(); d.Id = id++; d.Number = dr["Number"].ToString(); d.ProductName = dr["Name"].ToString(); d.Specification = dr["Specification"].ToString(); d.Type = dr["Type"].ToString(); d.Material = dr["Material"].ToString(); decimal.TryParse(dr["Quantity"].ToString(), out dd); d.Quantity = dd; data.Add(d); } return(true); } return(false); }