protected void Page_Load(object sender, EventArgs e) { if (null != Common.Common.NoHtml(Request.QueryString["action"])) { strAction = Common.Common.NoHtml(Request.QueryString["action"]); } if (null != Common.Common.NoHtml(Request.QueryString["id"])) { strID = Common.Common.NoHtml(Request.QueryString["id"]); } AlbumTypeDAL dal = new AlbumTypeDAL(); int statein = 0; try { statein = Convert.ToInt32(dal.GetAlbumTypeValue("IsDel", strID)); } catch (Exception) { statein = 0; } switch (statein) { case 0: statein = 1; break; default: statein = 0; break; } PA_AlbumType model = new PA_AlbumType(); model.ID = strID; model.IsDel = statein; switch (strAction) { case "del": if (dal.UpdateAlbumType(model)) { strMessage = "操作成功!"; } else { strMessage = "操作失败!"; } break; default: break; } Response.Write(strMessage); Response.End(); }
/// <summary> /// 修改相册类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateAlbumType(PA_AlbumType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE PA_AlbumType SET "); if (!string.IsNullOrEmpty(model.SiteCode)) { strSql.Append("[SiteCode]='" + model.SiteCode + "',"); } if (!string.IsNullOrEmpty(model.Name)) { strSql.Append("[Name]='" + model.Name + "',"); } if (!string.IsNullOrEmpty(model.Cover)) { strSql.Append("[Cover]='" + model.Cover + "',"); } if (!string.IsNullOrEmpty(model.Content)) { strSql.Append("[Content]='" + model.Content + "',"); } if (model.IsDel > 0) { strSql.Append("[IsDel]=" + model.IsDel + ","); } else { strSql.Append("[IsDel]=0,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" WHERE ID ='" + model.ID + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
protected override void AddTempData(JinianNet.JNTemplate.TemplateContext context) { //取站点信息 DAL.SYS.AccountDAL dalAccount = new DAL.SYS.AccountDAL(); DAL.Album.AlbumDAL dalAlbum = new DAL.Album.AlbumDAL(); //取站点相册列表 DataSet dsAlbumType = dalAlbum.GetAlbumTypeList(SiteCode); List <PA_AlbumType> liAlbumType = new List <PA_AlbumType>(); if (null != dsAlbumType && dsAlbumType.Tables.Count > 0 && dsAlbumType.Tables[0].Rows.Count > 0) { foreach (DataRow row in dsAlbumType.Tables[0].Rows) { PA_AlbumType model = DataConvert.DataRowToModel <PA_AlbumType>(row); liAlbumType.Add(model); } } context.TempData["AlbumTypelist"] = liAlbumType; }
public void ShowArticleInfo(string strID) { AlbumTypeDAL dal = new AlbumTypeDAL(); DataSet ds = dal.GetAlbumTypeDetail(strID); PA_AlbumType model = DataConvert.DataRowToModel <PA_AlbumType>(ds.Tables[0].Rows[0]); this.hd_content.Value = model.Content; this.AlbumTypeName.Text = model.Name; this.img0.Src = "../../" + model.Cover; if (model.IsDel == 0) { isstateyes.Checked = true; } else { isstateno.Checked = true; } if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; } }
/// <summary> /// 添加相册类别 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddAlbumType(PA_AlbumType model) { string sql = @"INSERT INTO [PA_AlbumType] ([ID] ,[SiteCode] ,[Name] ,[Cover] ,[Content] ,[IsDel]) VALUES (@ID ,@SiteCode ,@Name ,@Cover ,@Content ,@IsDel)"; System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ID", model.ID), new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode), new System.Data.SqlClient.SqlParameter("@Name", model.Name), new System.Data.SqlClient.SqlParameter("@Cover", model.Cover), new System.Data.SqlClient.SqlParameter("@Content", model.Content), new System.Data.SqlClient.SqlParameter("@IsDel", model.IsDel) }; int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 单击"保存"按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"]) { Response.Write("<script language=JavaScript>;parent.location.href='../Index.aspx';</script>"); Response.End(); } //上传封面图像 string strIconFileName = string.Empty; //封面图像路径 string strIconSaveFileName = string.Empty; //网址路径 try { if (this.file0.PostedFile.FileName == "") { strIconSaveFileName = ""; } else { if (!System.IO.Directory.Exists(Server.MapPath("~") + @"/Images")) { System.IO.Directory.CreateDirectory(Server.MapPath("~") + @"/Images"); } if (!System.IO.Directory.Exists(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString()))) { System.IO.Directory.CreateDirectory(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString())); } string orignalName = this.file0.PostedFile.FileName; //获取客户机上传文件的文件名 string extendName = orignalName.Substring(orignalName.LastIndexOf(".")); //获取扩展名 if (extendName != ".gif" && extendName != ".jpg" && extendName != ".jpeg" && extendName != ".png") { MessageBox.Show(this, "文件格式有误!"); return; }//检查文件格式 string newName = String.Format("{0}_{1}{2}", DateTime.Now.Millisecond, file0.PostedFile.ContentLength, extendName);//对文件进行重命名 strIconFileName = String.Format(@"{0}Images/{1}/{2}", Server.MapPath("~"), Session["strSiteCode"].ToString(), newName); strIconSaveFileName = String.Format(@"Images/{0}/{1}", Session["strSiteCode"].ToString(), newName); file0.PostedFile.SaveAs(strIconFileName); } } catch (Exception ex) { MessageBox.Show(this, "上传发生错误!原因是:" + ex.ToString()); } AlbumTypeDAL dal = new AlbumTypeDAL(); PA_AlbumType model = new PA_AlbumType(); if (AlbumTypeName.Text.Trim() != null && AlbumTypeName.Text.Trim() != "") { model.Name = AlbumTypeName.Text; model.Content = hd_content.Value; model.Cover = strIconSaveFileName; model.SiteCode = Session["strSiteCode"].ToString(); model.ID = strID; model.IsDel = isstateyes.Checked ? 0 : 1; if (dal.UpdateAlbumType(model)) { MessageBox.Show(this, "修改成功!"); } else { MessageBox.Show(this, "修改失败!"); } } else { MessageBox.Show(this, "请输入相应标题名称!"); } }