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; }