internal bool GetOrderDetails(Guid OrderID, out List <Model.ProductOrderDetailsModel> dDetails) { bool flag = false; dDetails = new List <Model.ProductOrderDetailsModel>(); string sql = " Select a.*,b.Number as ProductNumber,b.Name as ProductName" + " from T_Orders_ProductDetails a " + " Left join T_ProductInfo_Product b ON a.ProductID=b.Guid" + " where OrderID='" + OrderID + "'"; 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) { Model.ProductOrderDetailsModel d = new Model.ProductOrderDetailsModel(); d.Guid = (Guid)dr["Guid"]; d.Id = id; d.OrderID = OrderID; d.ProductID = (Guid)dr["ProductID"]; d.ProductNumber = dr["ProductNumber"].ToString(); d.ProductName = dr["ProductName"].ToString(); d.NumberOfItems = int.Parse(dr["NumberOfItems"].ToString()); d.Quantity = int.Parse(dr["Quantity"].ToString()); d.Unit = dr["Unit"].ToString(); d.Remark = dr["Remark"].ToString(); dDetails.Add(d); } } return(flag); }
private void Button_AddProductDetails_Click(object sender, RoutedEventArgs e) { if (this.ComboBox_Product.Text == "") { return; } Model.ProductOrderDetailsModel dd = new Model.ProductOrderDetailsModel(); dd.Guid = Guid.NewGuid(); dd.OrderID = Guid; dd.ProductID = (Guid)this.ComboBox_Product.SelectedValue; //dd.ProductNumber = this.ComboBox_Product.Text.Split('_')[0].Trim(); dd.ProductName = this.ComboBox_Product.Text.Trim(); dd.NumberOfItems = 0; dd.Quantity = 0; d.Details.Add(dd); this.DataGrid_ProductDetails.ItemsSource = null; this.DataGrid_ProductDetails.ItemsSource = d.Details; }