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();
        }
Exemplo n.º 2
0
        /// <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);
            }
        }
Exemplo n.º 3
0
        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;
        }
Exemplo n.º 4
0
        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;
            }
        }
Exemplo n.º 5
0
        /// <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);
            }
        }
Exemplo n.º 6
0
        /// <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, "请输入相应标题名称!");
            }
        }