public List <Model.CommodityType> GetCommodityType()
{
List <Model.CommodityType> books = new List <Model.CommodityType>();
CommodityType book = null;
if (DBHerpel.OpenConnection())
{
SqlDataReader dr = DBHerpel.ExecReader("select * from CommodityType where State=0");
if (dr != null)
{
while (dr.Read())
{
book = new CommodityType();
book.CommodityTypeID = (int)dr["CommodityTypeID"];
book.CommodityTypeName = dr["CommodityTypeName"] as string;
book.State = (int)dr["State"];
books.Add(book);
}
}
DBHerpel.CloseConnection();
}
return(books);
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="cu"></param>
/// <returns></returns>
public int updatecustomer(customer cu)
{
string sql = "update customer set State=0";
if (!string.IsNullOrEmpty(cu.Pssword))
{
sql += ",[Password]='" + cu.Pssword + "'";
}
if (!string.IsNullOrEmpty(cu.Name))
{
sql += ",Name='" + cu.Name + "'";
}
if (!string.IsNullOrEmpty(cu.Phone))
{
sql += ",Phone='" + cu.Phone + "'";
}
if (!string.IsNullOrEmpty(cu.Email))
{
sql += ",Email='" + cu.Email + "'";
}
if (!string.IsNullOrEmpty(cu.Adress))
{
sql += ",Adress='" + cu.Adress + "'";
}
sql += " where ID=" + cu.ID;
return(DBHerpel.ExecQuery(sql));
}
/// <summary>
/// 查询学生信息
/// </summary>
/// <param name="cu">学生信息</param>
/// <returns></returns>
public List <customer> selcustomer(string where)
{
List <Model.customer> cus = new List <Model.customer>();
customer sut = null;
if (DBHerpel.OpenConnection())
{
SqlDataReader dr = DBHerpel.ExecReader("select * from customer where State=0 " + where);
if (dr != null)
{
while (dr.Read())
{
sut = new customer();
sut.ID = (int)dr["ID"];
sut.Name = dr["Name"] as string;
sut.Account = dr["Account"] as string;
sut.Pssword = dr["password"].ToString();
sut.Headportrait = dr["Headportrait"] as string;
sut.Phone = dr["Phone"] as string;
sut.Email = dr["Email"] as string;
sut.Adress = dr["Adress"] as string;
sut.State = (int)dr["State"];
cus.Add(sut);
}
}
if (cus.Count == 0)
{
sut = new customer();
sut.ID = -1;
cus.Add(sut);
}
DBHerpel.CloseConnection();
}
return(cus);
}
public List <Commodity> selCommodity(int id)
{
List <Model.Commodity> cus = new List <Model.Commodity>();
Commodity sut = null;
SqlParameter[] p = { new SqlParameter("@id", id) };
if (DBHerpel.OpenConnection())
{
SqlDataReader dr = DBHerpel.Commodity("proc_Commodity", p);
if (dr != null)
{
while (dr.Read())
{
sut = new Commodity();
sut.ID = (int)dr["ID"];
sut.Commodityname = dr["Commodityname"] as string;
sut.assignor = (int)dr["assignor"];
sut.CommodityTypeID = (int)dr["CommodityTypeID"];
sut.Imageurl = dr["Imageurl"].ToString();
sut.transferprice = Convert.ToDouble(dr["transferprice"]);
sut.originalprice = Convert.ToDouble(dr["originalprice"]);
sut.colour = dr["colour"] as string;
sut.Adress = dr["Adress"] as string;
sut.contact = dr["contact"] as string;
sut.commintroduce = dr["commintroduce"] as string;
sut.EditTime = dr["EditTime"].ToString();
sut.browsenum = (int)dr["browsenum"];
sut.State = (int)dr["State"];
sut.Name = dr["Name"] as string;
cus.Add(sut);
}
}
DBHerpel.CloseConnection();
}
return(cus);
}