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;
}
