public List<SMZJ.Model.MYFILETEST> DataTableToList(DataTable dt) { List<SMZJ.Model.MYFILETEST> list = new List<SMZJ.Model.MYFILETEST>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { SMZJ.Model.MYFILETEST item = new SMZJ.Model.MYFILETEST(); if (dt.Rows[i]["商品编号"].ToString() != "") { item.商品编号 = new int?(int.Parse(dt.Rows[i]["商品编号"].ToString())); } item.商品名称 = dt.Rows[i]["商品名称"].ToString(); item.商品小图地址 = dt.Rows[i]["商品小图地址"].ToString(); list.Add(item); } } return list; }
public SMZJ.Model.MYFILETEST GetModel(int 商品编号) { StringBuilder builder = new StringBuilder(); builder.Append("select 商品编号,商品名称,商品小图地址 from MYFILETEST "); builder.Append(" where 商品编号=:商品编号 "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":商品编号", OracleType.Number, 4) }; cmdParms[0].Value = 商品编号; SMZJ.Model.MYFILETEST myfiletest = new SMZJ.Model.MYFILETEST(); DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if (set.Tables[0].Rows[0]["商品编号"].ToString() != "") { myfiletest.商品编号 = new int?(int.Parse(set.Tables[0].Rows[0]["商品编号"].ToString())); } myfiletest.商品名称 = set.Tables[0].Rows[0]["商品名称"].ToString(); myfiletest.商品小图地址 = set.Tables[0].Rows[0]["商品小图地址"].ToString(); return myfiletest; }