private List <PRODUCT_BUILD> MapPRODUCT_BUILD(DataTable dt) { List <PRODUCT_BUILD> rs = new List <PRODUCT_BUILD>(); for (int i = 0; i < dt.Rows.Count; i++) { PRODUCT_BUILD obj = new PRODUCT_BUILD(); if (dt.Columns.Contains("ProductID")) { obj.ProductID = dt.Rows[i]["ProductID"].ToString(); } if (dt.Columns.Contains("BuildID")) { obj.BuildID = dt.Rows[i]["BuildID"].ToString(); } if (dt.Columns.Contains("Quantity")) { obj.Quantity = double.Parse(dt.Rows[i]["Quantity"].ToString()); } if (dt.Columns.Contains("Price")) { obj.Price = double.Parse(dt.Rows[i]["Price"].ToString()); } if (dt.Columns.Contains("Amount")) { obj.Amount = double.Parse(dt.Rows[i]["Amount"].ToString()); } rs.Add(obj); } return(rs); }
public int PRODUCT_BUILD_Insert(PRODUCT_BUILD obj) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "PRODUCT_BUILD_Insert", obj.ProductID, obj.BuildID, obj.Quantity, obj.Price, obj.Amount )); } catch { //throw ex; return(-1); } }
public int PRODUCT_BUILD_Update(PRODUCT_BUILD obj, string ProductID, string BuildID) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "PRODUCT_BUILD_Update", ProductID, BuildID, obj.Quantity, obj.Price, obj.Amount )); } catch { //throw ex; return(-1); } }