protected void link_edit(object sender, System.EventArgs e)
{
LinkButton obj = sender as LinkButton;
Selected_id.Value = obj.CommandArgument;
ProductData = productController.GetProduct(Selected_id.Value);
price.Text = ProductData.Price.ToString();
p_id.Text = ProductData.P_id.ToString();
productname.Text = ProductData.Productname;
storage.Text = ProductData.Storage.ToString();
description.Text = ProductData.Description;
status.SelectedValue = ProductData.Status;
categoryid.SelectedIndex = categoryid.Items.IndexOf(categoryid.Items.FindByValue(ProductData.Categoryid.ToString()));
stringArray[1] = ProductData.Pic1;
stringArray[2] = ProductData.Pic2;
stringArray[3] = ProductData.Pic3;
stringArray[0] = ProductData.Logo;
keywords = ProductData.Keyword;
sort.Text = ProductData.Sort;
memo.Text = ProductData.Memo;
videourl.Text = ProductData.Videourl;
productcode.Text = ProductData.Productcode;
supplierid.SelectedIndex = supplierid.Items.IndexOf(supplierid.Items.FindByValue(ProductData.Supplierid.ToString()));
Image1.ImageUrl = "/upload/" + stringArray[1] + "?" + DateTime.Now.ToString("yyyyMMddhhmmss");
Image2.ImageUrl = "/upload/" + stringArray[2] + "?" + DateTime.Now.ToString("yyyyMMddhhmmss");
Image3.ImageUrl = "/upload/" + stringArray[3] + "?" + DateTime.Now.ToString("yyyyMMddhhmmss");
Imagelogo.ImageUrl = "/upload/" + stringArray[0] + "?" + DateTime.Now.ToString("yyyyMMddhhmmss");
spec.Text = ProductData.Spec;
viewcount.Text = ProductData.Viewcount.ToString();
MultiView1.ActiveViewIndex = 1;
Btn_save.CommandArgument = "edit";
if (obj.CommandName == "copy")
{
Btn_save.CommandArgument = "copy";
}
}
protected void Btn_save_Click(object sender, System.EventArgs e)
{
int i = 0;
LinkButton obj = sender as LinkButton;
NameValueCollection nvc = new NameValueCollection();
string strsql = "";
if (Btn_save.CommandArgument == "copy" || Btn_save.CommandArgument == "add")
{
strsql = "insert into tbl_productdata (viewcount) values (@viewcount ) ";
nvc.Add("viewcount", "0");
i = DbControl.Data_add(strsql, nvc);
strsql = "select max(p_id ) from tbl_productdata where p_id >@p_id ";
nvc.Clear();
nvc.Add("p_id", "0");
DataTable dt = DbControl.Data_Get(strsql, nvc);
p_id.Text = dt.Rows[0][0].ToString();
}
else
{
ProductData = productController.GetProduct(Selected_id.Value);
stringArray[1] = ProductData.Pic1;
stringArray[2] = ProductData.Pic2;
stringArray[3] = ProductData.Pic3;
stringArray[0] = ProductData.Logo;
}
string img_path = "../upload/";
string picname = DateTime.Now.ToString("yyyyMMddhhmmssfff");
if (FileUpload1.FileName != "")
{
FileUpload1.SaveAs(Server.MapPath(img_path + picname + "-1.jpg"));
stringArray[1] = picname + "-1.jpg";
}
if (FileUpload2.FileName != "")
{
FileUpload2.SaveAs(Server.MapPath(img_path + picname + "-2.jpg"));
stringArray[2] = picname + "-2.jpg";
}
if (FileUpload3.FileName != "")
{
FileUpload3.SaveAs(Server.MapPath(img_path + picname + "-3.jpg"));
stringArray[3] = picname + "-3.jpg";
}
if (FileUploadlogo.FileName != "")
{
FileUploadlogo.SaveAs(Server.MapPath(img_path + picname + "-logo.jpg"));
stringArray[0] = picname + "-logo.jpg";
}
if (sort.Text == "")
{
sort.Text = "0";
}
strsql = @"UPDATE tbl_productdata SET productname=@productname,price=@price
,productcode=@productcode,videourl=@videourl
,description = @description, storage = @storage, pic1 = @pic1, pic2 = @pic2
, pic3 = @pic3 ,keyword = @keyword,memo=@memo,
categoryid = @categoryid, status = @status,sort=@sort,logo=@logo
,kindid=@kindid, supplierid=@supplierid,spec=@spec where p_id=@id ";
nvc.Clear();
nvc.Add("productname", productname.Text);
nvc.Add("price", price.Text);
nvc.Add("productcode", productcode.Text);
nvc.Add("videourl", videourl.Text);
nvc.Add("storage", storage.Text);
nvc.Add("description", Server.HtmlDecode(description.Text));
nvc.Add("status", status.SelectedValue);
nvc.Add("categoryid", categoryid.SelectedValue);
nvc.Add("logo", stringArray[0] == null ? "" : stringArray[0]);
nvc.Add("pic1", stringArray[1] == null ? "" : stringArray[1]);
nvc.Add("pic2", stringArray[2] == null ? "" : stringArray[2]);
nvc.Add("pic3", stringArray[3] == null ? "" : stringArray[3]);
nvc.Add("keyword", Request["keywords"]);
nvc.Add("memo", memo.Text);
nvc.Add("spec", spec.Text);
nvc.Add("sort", sort.Text);
nvc.Add("supplierid", supplierid.SelectedValue);
nvc.Add("kindid", "1");
i = DbControl.Data_Update(strsql, nvc, p_id.Text);
selectSQL();
MultiView1.ActiveViewIndex = 0;
}
