protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox2.Text == "")
{
Response.Write("<script>alert('请输入商品名')</script>");
}
if (TextBox1.Text == "")
{
Response.Write("<script>alert('请输入商品简介')</script>");
}
if (TextBox3.Text == "")
{
Response.Write("<script>alert('请输入商品价格')</script>");
}
//if (TextBox4.Text=="")
//{
// Response.Write("<script>alert('请输入用户id')</script>");
//}
//var qq = Session["User"] as ModelUsers;
ModelProviderProduct ins = new ModelProviderProduct()
{
Productname = TextBox2.Text,
Productcontent = TextBox1.Text,
Productprice = Convert.ToDouble(TextBox3.Text),
//Userid = qq.Userid
};
if (BllProviderProduct.insert(ins) > 0)
{
Response.Write("<script>alert('添加成功');location.href='ProviderProduct.aspx'</script>");
}
}
/// <summary>
/// To the model.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns></returns>
internal static ModelProviderProduct ToModel(this EntityProviderProduct entity)
{
var model = new ModelProviderProduct();
model.Id = entity.Id;
return(model);
}
/// <summary>
/// To the entity.
/// </summary>
/// <param name="model">The model.</param>
/// <returns></returns>
internal static EntityProviderProduct ToEntity(this ModelProviderProduct model)
{
var entity = new EntityProviderProduct();
entity.Id = model.Id;
return(entity);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int delete(ModelProviderProduct model)
{
string sql = "delete from ProviderProduct where Productid=@Productid";
SqlParameter[] sqlpar = new SqlParameter[]
{
new SqlParameter("@Productid", model.Productid)
};
return(DBhelp.Notquery(sql, sqlpar));
}
/// <summary>
/// 添加
/// </summary>
/// <returns></returns>
public static int insert(ModelProviderProduct model)
{
string sql = "insert into ProviderProduct values(@Productname ,@Productcontent ,@Productprice ,@Productimg ,@Userid)";
SqlParameter[] sqlpar = new SqlParameter[]
{
new SqlParameter("@Productname", model.Productname),
new SqlParameter("@Productcontent", model.Productcontent),
new SqlParameter("@Productprice", model.Productprice),
new SqlParameter("@Productimg", model.Productimg),
new SqlParameter("@Userid", model.Userid)
};
return(DBhelp.Notquery(sql, sqlpar));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int update(ModelProviderProduct model)
{
string sql = "update ProviderProduct set Productname=@Productname,Productcontent=@Productcontent,Productprice=@Productprice,Productimg=@Productimg,Userid=@Userid where Productid=@Productid";
SqlParameter[] sqlpar = new SqlParameter[]
{
new SqlParameter("@Productname", model.Productname),
new SqlParameter("@Productcontent", model.Productcontent),
new SqlParameter("@Productprice", model.Productprice),
new SqlParameter("@Productimg", model.Productimg),
new SqlParameter("@Userid", model.Userid),
new SqlParameter("@Productid", model.Productid)
};
return(DBhelp.Notquery(sql, sqlpar));
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//获取前台comm的方法名
string name = e.CommandName;
//存储model值
ModelProviderProduct model = new ModelProviderProduct()
{
Productid = Convert.ToInt32(e.CommandArgument)
};
//判断方法名来进行相对的操作
if (name == "delete")
{
//执行删除(软删除 将值进行隐藏)
int num = BllProviderProduct.delete(model);
if (num > 0)
{
Response.Write("<script>alert('删除成功');location.href='ProviderProduct.aspx'</script>");
}
}
}
/// <summary>
/// 查询供应商商品表
/// </summary>
/// <returns></returns>
public static List <ModelProviderProduct> select()
{
string sql = "select * from ProviderProduct ";
//此处是多条件查询（根据商品名来进行模糊查询）
//string sql = "select * from ProviderProduct where Providername like''%'+@Providername+'%'''";
SqlDataReader sdr = DBhelp.slelect(sql);
List <ModelProviderProduct> list = new List <ModelProviderProduct>();
if (sdr.HasRows)
{
while (sdr.Read())
{
ModelProviderProduct model = new ModelProviderProduct();
model.Productid = Convert.ToInt32(sdr["Productid"]);
model.Productname = sdr["Productname"].ToString();
model.Productcontent = sdr["Productcontent"].ToString();
model.Productprice = Convert.ToDouble(sdr["Productprice"]);
model.Productimg = sdr["Productimg"].ToString();
model.Userid = Convert.ToInt32(sdr["Userid"]);
list.Add(model);
}
}
return(list);
}
public static int insert(ModelProviderProduct model)
{
return(DalProviderProduct.insert(model));
}
public static int update(ModelProviderProduct model)
{
return(DalProviderProduct.update(model));
}
public static int delete(ModelProviderProduct model)
{
return(DalProviderProduct.delete(model));
}
