protected void Button4_Click(object sender, EventArgs e)
{
tGallery x = db.tGallery.FirstOrDefault(t => t.fIdGallery == Convert.ToInt32(Session[CDKey.deletegallery].ToString()));
if (x != null)
{
x.fDelete = "True";
}
/* var deletePhoto = from gp in db.tGalleryPhoto
* where gp.fIdGallery == Convert.ToInt32(Session[CDKey.deletegallery].ToString())
* select gp;
* var deleteGallery = (from g in db.tGallery
* where g.fIdGallery == Convert.ToInt32(Session[CDKey.deletegallery].ToString())
* select g).First();
* foreach (tGalleryPhoto od in deletePhoto)
* {
* db.tGalleryPhoto.DeleteOnSubmit(od);
* }
* db.tGallery.DeleteOnSubmit(deleteGallery);*/
db.SubmitChanges();
Session.Remove(CDKey.deletegallery);
Response.Redirect("memberCenter_Store.aspx?delete=2");
}
protected void btnSave_Click(object sender, EventArgs e)
{
string date1 = DateTime.Now.ToString("ddMMyyyyHHmmss"), date2 = DateTime.Now.ToString("ddMMyyyyHHmmss");;
string filename = "";
var n = new tGallery();
n.GalleryName = txtName.Text.Trim();
n.Content = fckContent.Value;
n.CreateAt = DateTime.Now;
n.CreateBy = int.Parse(Session["cm_userId"].ToString());
n.Description = txtDescription.Text.Trim();
if (fuImage.HasFile)
{
filename = fuImage.FileName.Trim();
n.Image1 = "/upload/gallery/" + date1 + "_" + filename.Substring(filename.LastIndexOf('.'));
}
if (fuImage2.HasFile)
{
date2 = DateTime.Now.ToString("ddMMyyyyHHmmss");
filename = fuImage2.FileName.Trim();
n.Image2 = "/upload/gallery/" + date2 + "_" + filename.Substring(filename.LastIndexOf('.'));
}
n.Status = byte.Parse(dlActive.SelectedValue);
n.BranchTypeId = int.Parse(dlBranchType.SelectedValue);
db.tGalleries.InsertOnSubmit(n);
db.SubmitChanges();
if (fuImage.HasFile)
{
if (dlBranchType.SelectedValue == "1")
{
fuImage.SaveAs(Server.MapPath("/upload/cnice/gallery/" + date1 + "_" + filename.Substring(filename.LastIndexOf('.'))));
}
else if (dlBranchType.SelectedValue == "2")
{
fuImage.SaveAs(Server.MapPath("/upload/cfashion/gallery/" + date1 + "_" + filename.Substring(filename.LastIndexOf('.'))));
}
}
if (fuImage2.HasFile)
{
if (dlBranchType.SelectedValue == "1")
{
fuImage2.SaveAs(Server.MapPath("/upload/cnice/gallery/" + date2 + "_" + filename.Substring(filename.LastIndexOf('.'))));
}
else if (dlBranchType.SelectedValue == "2")
{
fuImage2.SaveAs(Server.MapPath("/upload/cfashion/gallery/" + date2 + "_" + filename.Substring(filename.LastIndexOf('.'))));
}
}
txtDescription.Text = "";
txtName.Text = "";
fckContent.Value = "";
Response.Redirect("/gallery");
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "bbb")
{
//Label3.Text = (e.Item.FindControl("Label2") as Label).Text;
tGallery ga = db.tGallery.FirstOrDefault(t => t.fIdGallery == Convert.ToInt32((e.Item.FindControl("Label1") as Label).Text));
if (ga != null)
{
ga.fIdPhotoCover = Convert.ToInt32((e.Item.FindControl("Label2") as Label).Text);
}
db.SubmitChanges();
Label4.Text = "更換封面成功";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var newGallery = new tGallery
{
fIdStores = id,
fName = txtname.Text,
fDescription = txtDescription.Text,
fUploadTime = DateTime.Now,
fIdServicesSubClass = Convert.ToInt32(DWServices.SelectedItem.Value),
fIdPhotoCover = 1
};
db.tGallery.InsertOnSubmit(newGallery);
db.SubmitChanges();
Button2.Visible = true;
Label4.Visible = true;
}
