//获取商品
public List <Model.PropInfo> getProps(int pageSize, int pageIndex, out int RecordCount)
{
List <Model.PropInfo> list = new List <Model.PropInfo>();
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@RecordCount", SqlDbType.Int, 4)
};
parm[2].Direction = ParameterDirection.Output;
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, PROC_GETPROPS, parm))
{
while (dr.Read())
{
Model.PropInfo item = new Model.PropInfo();
item.createDate = dr["createDate"].ToString();
item.outNumber = Convert.ToInt32(dr["outNumber"]);
item.PropId = Convert.ToInt32(dr["PropId"]);
item.PropImage = dr["PropImage"].ToString();
item.PropIntroduction = dr["PropIntroduction"].ToString();
item.PropName = dr["PropName"].ToString();
item.PropPrice = Convert.ToDecimal(dr["PropPrice"]);
list.Add(item);
}
}
RecordCount = Convert.ToInt32(parm[2].Value);
return(list);
}
//后台商品管理
public int updatePropInfo(Model.PropInfo prop)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@PropId ", prop.PropId),
new SqlParameter("@PropName ", prop.PropName),
new SqlParameter("@PropPrice ", prop.PropPrice),
new SqlParameter("@PropIntroduction ", prop.PropIntroduction),
new SqlParameter("@CreateDate ", prop.createDate),
new SqlParameter("@OutNumber ", prop.outNumber),
new SqlParameter("@PropImage ", prop.PropImage),
};
int i = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, PROC_MODIFYPROP, parms);
return(i);
}
//获取一个商品信息
public List <Model.PropInfo> getOnePropInfo(int propId)
{
SqlParameter parm = new SqlParameter("@prioID", propId);
List <Model.PropInfo> list = new List <Model.PropInfo>();
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "getOnePropInfo", parm))
{
if (dr.Read())
{
Model.PropInfo item = new Model.PropInfo();
item.createDate = dr["createDate"].ToString();
item.outNumber = Convert.ToInt32(dr["outNumber"]);
item.PropId = Convert.ToInt32(dr["PropId"]);
item.PropImage = dr["PropImage"].ToString();
item.PropIntroduction = dr["PropIntroduction"].ToString();
item.PropName = dr["PropName"].ToString();
item.PropPrice = Convert.ToDecimal(dr["PropPrice"]);
list.Add(item);
}
}
return(list);
}
//获取热卖商品
public List <Model.PropInfo> getHotProps()
{
List <Model.PropInfo> list = new List <Model.PropInfo>();
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, RPOC_GETHOTPROPS, null))
{
while (dr.Read())
{
Model.PropInfo item = new Model.PropInfo();
item.createDate = dr["createDate"].ToString();
item.outNumber = Convert.ToInt32(dr["outNumber"]);
item.PropId = Convert.ToInt32(dr["PropId"]);
item.PropImage = dr["PropImage"].ToString();
item.PropIntroduction = dr["PropIntroduction"].ToString();
item.PropName = dr["PropName"].ToString();
item.PropPrice = Convert.ToDecimal(dr["PropPrice"]);
list.Add(item);
}
}
return(list);
}
//后台商品管理
public int updatePropInfo(Model.PropInfo prop)
{
return(IP.updatePropInfo(prop));
}
