/// <summary>
/// 查询所有商品
/// </summary>
/// <param name="PTID"></param>
/// <param name="JP"></param>
/// <returns></returns>
public static List <ProductsMDL> selectProduct(string ProductJP)
{
string sql = "select * from dbo.Products where 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (ProductJP != "")
{
sql += " and ProductJP like @ProductJP";
sp.Add(new SqlParameter("@ProductJP", "%" + ProductJP + "%"));
}
SqlDataReader dr = DBhelper.MySqlDataReader(sql, sp.ToArray());
List <ProductsMDL> list = new List <ProductsMDL>();
while (dr.Read())
{
ProductsMDL pd = new ProductsMDL();
pd.ProductID = Convert.ToInt32(dr[0]);
pd.ProductName = dr[1].ToString();
pd.PTID = Convert.ToInt32(dr[2]);
pd.ProductJP = dr[3].ToString();
pd.ProductPrice = Convert.ToDouble(dr[4]);
pd.ProductPic = dr[6].ToString();
pd.ProductIntroduction = dr[5].ToString();
list.Add(pd);
}
dr.Close();
return(list);
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
{
new Warning("信息填写不完整", 图标.Erro).Show();
return;
}
if (OpenType == 1)
{
//增加
ProductsMDL pr = new ProductsMDL();
pr.ProductName = textBox1.Text;
pr.ProductPrice = Convert.ToInt32(textBox3.Text);
pr.ProductJP = textBox2.Text;
pr.PTID = Convert.ToInt32(comboBox1.SelectedValue);
pr.ProductPic = path;
pr.ProductIntroduction = textBox4.Text;
int count = ProductsBLL.AddProducts(pr);
if (count > 0)
{
new Warning("添加成功", 图标.Yes).Show();
this.Close();
}
else
{
new Warning("添加失败", 图标.Erro).Show();
}
}
else
{
//修改
this.Text = "修改商品信息";
ProductsMDL p = new ProductsMDL();
p.ProductName = textBox1.Text;
p.ProductJP = textBox2.Text;
p.PTID = Convert.ToInt32(comboBox1.SelectedValue);
p.ProductPrice = Convert.ToDouble(textBox3.Text);
p.ProductID = EditProduct.ShopID;
p.ProductIntroduction = textBox4.Text;
p.ProductPic = path;
int count = ProductsBLL.UpdateProducts(p);
if (count > 0)
{
new Warning("修改成功", 图标.Yes).Show();
this.Close();
}
else
{
new Warning("修改成功", 图标.Erro).Show();
}
}
}
/// <summary>
/// 添加商品
/// </summary>
/// <param name="p"></param>
/// <returns>几行受影响</returns>
public static int AddProducts(ProductsMDL p)
{
string sql = "insert into Products values(@ProductName,@PTID,@ProductJP,@ProductPrice,@ProductIntroduction,@ProductPic)";
SqlParameter[] sp =
{
new SqlParameter("@ProductName", p.ProductName),
new SqlParameter("@PTID", p.PTID),
new SqlParameter("@ProductJP", p.ProductJP),
new SqlParameter("@ProductPrice", p.ProductPrice),
new SqlParameter("@ProductIntroduction", p.ProductIntroduction),
new SqlParameter("@ProductPic", p.ProductPic)
};
return(DBhelper.MyExecuteNonQuery(sql, sp));
}
/// <summary>
/// 修改商品
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static int UpdateProducts(ProductsMDL p)
{
string sql = @" update Products
set ProductName=@ProductName,PTID=@PTID,ProductPrice=@ProductPrice,ProductIntroduction=@ProductIntroduction,ProductPic=@ProductPic
where ProductID=@ProductID";
SqlParameter[] sp =
{
new SqlParameter("@ProductName", p.ProductName),
new SqlParameter("@PTID", p.PTID),
new SqlParameter("@ProductPrice", p.ProductPrice),
new SqlParameter("@ProductID", p.ProductID),
new SqlParameter("@ProductIntroduction", p.ProductIntroduction),
new SqlParameter("@ProductPic", p.ProductPic)
};
return(DBhelper.MyExecuteNonQuery(sql, sp));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static int UpdateProducts(ProductsMDL p)
{
return(ProductsDAL.UpdateProducts(p));
}
/// <summary>
/// 添加商品
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static int AddProducts(ProductsMDL p)
{
return(ProductsDAL.AddProducts(p));
}
