protected void sc_Command(object sender, CommandEventArgs e)
{
string size_id = Convert.ToString(e.CommandArgument);
BLL.size bsize = new BLL.size();
int result = bsize.delete(size_id);
BLL.proimage myb = new BLL.proimage();
SqlDataReader dr = myb.s_imageurl(size_id);
BLL.proimage isize = new BLL.proimage();
int i_result = isize.delete_1(size_id);
dr.Read();
string path = "~/" + dr["_imageurl"].ToString();
dr.Close();
if (File.Exists(Server.MapPath(path)))
{
File.Delete(Server.MapPath(path));
}
if (i_result > 0)
{
msg("删除成功！！");
bing();
}
}
protected void sc_Command(object sender, CommandEventArgs e)
{
string size_id = Convert.ToString(e.CommandArgument);
BLL.size bsize = new BLL.size();
int result = bsize.delete(size_id);
BLL.proimage myb = new BLL.proimage();
MySqlDataReader dr = myb.s_imageurl(size_id);
BLL.proimage isize = new BLL.proimage();
int i_result = isize.delete_1(size_id);
dr.Read();
string path = "~/" + dr["_imageurl"].ToString();
dr.Close();
if (File.Exists(Server.MapPath(path)))
{
File.Delete(Server.MapPath(path));
}
if (i_result > 0)
{
msg("删除成功！！");
bing();
}
}
public void sbing()
{
BLL.size bsize = new BLL.size();
DataSet ds = bsize.select_size(u_sizeid.Text);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
public void sbing()
{
BLL.size bsize = new BLL.size();
DataSet ds = bsize.select_size(u_sizeid.Text);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void tain_Click(object sender, EventArgs e)
{
Model.size mym = new Model.size();
mym.sizeid = u_sizeid.Text;
mym.sizename = Dropsize.SelectedValue;
BLL.size myb = new BLL.size();
int result = myb.insert(mym);
sbing();
}
protected void tain_Click(object sender, EventArgs e)
{
Model.size mym = new Model.size();
mym.sizeid = u_sizeid.Text;
mym.sizename = Dropsize.SelectedValue;
BLL.size myb = new BLL.size();
int result = myb.insert(mym);
sbing();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
Model.product mym = new Model.product();
mym.id = Convert.ToInt32(e.CommandArgument);
BLL.product myb = new BLL.product();
string s_imageid = myb.select_imageid(mym);
BLL.proimage b_image = new BLL.proimage();
DataSet ds = b_image.select_sizeid(s_imageid);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string size_id = Convert.ToString(ds.Tables[0].Rows[i]["_sizeid"]);
BLL.size s_bll = new BLL.size();
int result_s = s_bll.delete(size_id);
string path1 = Convert.ToString(ds.Tables[0].Rows[i]["_imageurl"]);
string path = "~/" + path1;
if (File.Exists(Server.MapPath(path)))
{
File.Delete(Server.MapPath(path));
}
}
int r_image = b_image.delete(s_imageid);
int result = myb.delete_id(mym);
if (result > 0)
{
msg("删除成功！！");
bing();
}
}
if (e.CommandName == "Edit")
{
Response.Redirect("proupdate.aspx?id=" + e.CommandArgument + "");
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int u_id = Convert.ToInt32(e.CommandArgument);
BLL.size b_ss = new BLL.size();
int result = b_ss.delete_1(u_id);
if (result > 0)
{
msg("删除成功！！");
sbing();
}
}
public void siz(string size_id)
{
BLL.size b_size = new BLL.size();
DataSet b_ds = b_size.select_size(size_id);
DataList2.DataSource = b_ds.Tables[0];
DataList2.DataBind();
if (b_ds.Tables[0].Rows.Count > 0)
{
_size.Text = Convert.ToString(b_ds.Tables[0].Rows[0]["_sizename"]);
}
}
protected void qued_Click(object sender, EventArgs e)
{
Model.size mym = new Model.size();
mym.sizeid = sizeidla.Text;
mym.sizename = Dropsize.SelectedValue;
BLL.size myb = new BLL.size();
int result = myb.insert(mym);
if (result > 0)
{
sizela.Text += Dropsize.SelectedValue + ",";
}
}
protected void qued_Click(object sender, EventArgs e)
{
Model.size mym = new Model.size();
mym.sizeid = sizeidla.Text;
mym.sizename = Dropsize.SelectedValue;
BLL.size myb = new BLL.size();
int result = myb.insert(mym);
if (result > 0)
{
sizela.Text += Dropsize.SelectedValue + ",";
}
}
public string sb(string size_id)
{
string str=null;
BLL.size b_size = new BLL.size();
DataSet ds = b_size.select_size(size_id);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
str =str + Convert.ToString( ds.Tables[0].Rows[i]["_sizename"])+" ";
}
return str ;
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int u_id = Convert.ToInt32(e.CommandArgument);
BLL.size b_ss = new BLL.size();
int result = b_ss.delete_1(u_id);
if (result > 0)
{
msg("删除成功！！");
sbing();
}
}
public string sb(string size_id)
{
string str = null;
BLL.size b_size = new BLL.size();
DataSet ds = b_size.select_size(size_id);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
str = str + Convert.ToString(ds.Tables[0].Rows[i]["_sizename"]) + " ";
}
return(str);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
Model.product mym = new Model.product();
mym.id = Convert.ToInt32(e.CommandArgument);
BLL.product myb = new BLL.product();
string s_imageid = myb.select_imageid(mym);
BLL.proimage b_image = new BLL.proimage();
DataSet ds = b_image.select_sizeid(s_imageid);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string size_id = Convert.ToString(ds.Tables[0].Rows[i]["_sizeid"]);
BLL.size s_bll = new BLL.size();
int result_s = s_bll.delete(size_id);
string path1 = Convert.ToString(ds.Tables[0].Rows[i]["_imageurl"]);
string path = "~/" + path1;
if (File.Exists(Server.MapPath(path)))
{
File.Delete(Server.MapPath(path));
}
}
int r_image = b_image.delete(s_imageid);
int result = myb.delete_id(mym);
if (result > 0)
{
msg("删除成功！！");
bing();
}
}
if (e.CommandName == "Edit")
{
Response.Redirect("proupdate.aspx?id="+e.CommandArgument+"");
}
}