private List <UNITCONVERT> MapUNITCONVERT(DataTable dt) { List <UNITCONVERT> rs = new List <UNITCONVERT>(); for (int i = 0; i < dt.Rows.Count; i++) { UNITCONVERT obj = new UNITCONVERT(); if (dt.Columns.Contains("Product_ID")) { obj.Product_ID = (dt.Rows[i]["Product_ID"].ToString()); } if (dt.Columns.Contains("Unit_ID")) { obj.Unit_ID = (dt.Rows[i]["Unit_ID"].ToString()); } if (dt.Columns.Contains("UnitConvert")) { obj.UnitConvert = double.Parse(dt.Rows[i]["UnitConvert"].ToString()); } if (dt.Columns.Contains("UnitChild_ID")) { obj.UnitChild_ID = (dt.Rows[i]["UnitChild_ID"].ToString()); } rs.Add(obj); } return(rs); }
public int UNITCONVERT_Insert(UNITCONVERT obj) { try { return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "UNITCONVERT_Insert", obj.Product_ID, obj.Unit_ID, obj.UnitConvert, obj.UnitChild_ID )); } catch { //throw ex; return(-1); } }