/// <summary>
/// 根据ID查询购物车信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public Shop_Table GetShopTableByConn(string attrName, string con)
{
string name = "@" + attrName;
Shop_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from Shop_Table where " + attrName + "=" + name,
CommandType.Text, new SqlParameter[] {
new SqlParameter(name, con)
});
if (dr.Read())
{
obj = new Shop_Table()
{
P_No = dr["P_No"].ToString(),
Shop_Date = dr["Shop_Date"].ToString(),
Shop_Id = Convert.ToInt32(dr["Shop_Id"]),
Shop_Number = dr["Shop_Number"].ToString(),
Shop_User = dr["Shop_User"].ToString()
};
}
dr.Close();
DBHerlper.CloseConn();
return(obj);
}
/// <summary>
/// 根据ID查询购物车信息
/// </summary>
/// <param name="con">带入参数(ID)</param>
/// <returns></returns>
public Shop_Table GetShopTableByConn(string attrName, string con)
{
Shop_Table obj = relevanceClass.GetShopTableByConn(attrName, con);
obj.GetProductByP_No = prodct.GetProductTableByConn("P_No", obj.P_No);
obj.GetUserByUserName = user.GetUserTableByConn(obj.Shop_User, "name");
return(obj);
}
/// <summary>
/// 添加购物车
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_ShopTableData(Shop_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@P_No", obj.P_No),
new SqlParameter("@Shop_Date", obj.Shop_Date),
new SqlParameter("@Shop_Number", obj.Shop_Number),
new SqlParameter("@Shop_User", obj.Shop_User)
}));
}
/// <summary>
/// 获取全部的购物车
/// </summary>
/// <returns></returns>
public List <Shop_Table> GetShopTableAll()
{
List <Shop_Table> list = new List <Shop_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
Shop_Table obj = new Shop_Table()
{
P_No = dr["P_No"].ToString(),
Shop_Date = dr["Shop_Date"].ToString(),
Shop_Id = Convert.ToInt32(dr["Shop_Id"]),
Shop_Number = dr["Shop_Number"].ToString(),
Shop_User = dr["Shop_User"].ToString()
};
list.Add(obj);
}
dr.Close();
DBHerlper.CloseConn();
return(list);
}
/// <summary>
/// 更改购物车
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_ShopTableData(Shop_Table obj)
{
return(relevanceClass.Update_ShopTableData(obj));
}
/// <summary>
/// 添加购物车
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_ShopTableData(Shop_Table obj)
{
return(relevanceClass.Insert_ShopTableData(obj));
}
