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