예제 #1
0
        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"]);
            }

            AlbumDAL dal = new AlbumDAL();

            int statein = 0;

            try
            {
                statein = Convert.ToInt32(dal.GetAlbumValue("IsDel", strID));
            }
            catch (Exception)
            {
                statein = 0;
            }
            switch (statein)
            {
            case 0:
                statein = 1;
                break;

            default:
                statein = 0;
                break;
            }
            PA_Album model = new PA_Album();

            model.IsDel = statein;
            model.ID    = strID;
            switch (strAction)
            {
            case "del":
                if (dal.UpdateAlbum(model))
                {
                    strMessage = "操作成功!";
                }
                else
                {
                    strMessage = "操作失败!";
                }
                break;

            default:
                break;
            }
            Response.Write(strMessage);
            Response.End();
        }
예제 #2
0
        public void ShowArticleInfo(string strID)
        {
            AlbumDAL dal   = new AlbumDAL();
            DataSet  ds    = dal.GetAlbumDetail(strID);
            PA_Album model = DataConvert.DataRowToModel <PA_Album>(ds.Tables[0].Rows[0]);

            this.hd_content.Value           = model.Note;
            this.ddlAlbumType.SelectedIndex = this.ddlAlbumType.Items.IndexOf(this.ddlAlbumType.Items.FindByValue(model.Type));
            this.AlbumName.Text             = model.Name;
            this.img0.Src = "../../" + model.Photo;
            if (strAction == "show")
            {
                this.btnReset.Visible = false;
                this.btnSave.Visible  = false;
            }
        }
예제 #3
0
        /// <summary>
        /// 修改相册信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateAlbum(PA_Album model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("UPDATE PA_Album SET ");
            if (!string.IsNullOrEmpty(model.Type))
            {
                strSql.Append("[Type]='" + model.Type + "',");
            }
            if (!string.IsNullOrEmpty(model.Name))
            {
                strSql.Append("[Name]='" + model.Name + "',");
            }
            if (!string.IsNullOrEmpty(model.Photo))
            {
                strSql.Append("[Photo]='" + model.Photo + "',");
            }
            if (!string.IsNullOrEmpty(model.Note))
            {
                strSql.Append("[Note]='" + model.Note + "',");
            }
            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);
            }
        }
예제 #4
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         dsAlbumList = dalAlbum.GetAlbumList(AlbumTypeID);
            List <PA_Album> liAlbumList = new List <PA_Album>();

            if (null != dsAlbumList && dsAlbumList.Tables.Count > 0 && dsAlbumList.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow row in dsAlbumList.Tables[0].Rows)
                {
                    PA_Album model = DataConvert.DataRowToModel <PA_Album>(row);
                    liAlbumList.Add(model);
                }
            }

            context.TempData["albumlist"] = liAlbumList;
        }
예제 #5
0
        /// <summary>
        /// 添加相册
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InsertAlbum(PA_Album model)
        {
            string sql = @"INSERT INTO [PA_Album]
                        ([ID]
                        ,[Type]
                        ,[Name]
                        ,[Photo]
                        ,[Note]
                         ,[IsDel])
                 VALUES
                        (@ID
                       ,@Type
                       ,@Name
                       ,@Photo
                       ,@Note
                       ,@IsDel)";

            System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
            {
                new System.Data.SqlClient.SqlParameter("@ID", model.ID),
                new System.Data.SqlClient.SqlParameter("@Type", model.Type),
                new System.Data.SqlClient.SqlParameter("@Name", model.Name),
                new System.Data.SqlClient.SqlParameter("@Photo", model.Photo),
                new System.Data.SqlClient.SqlParameter("@Note", model.Note),
                new System.Data.SqlClient.SqlParameter("@IsDel", model.IsDel)
            };
            int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);

            if (rowsAffected > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #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());
            }

            AlbumDAL dal   = new AlbumDAL();
            PA_Album model = new PA_Album();

            if (AlbumName.Text.Trim() != null && AlbumName.Text.Trim() != "")
            {
                model.Name  = AlbumName.Text;
                model.Note  = hd_content.Value;
                model.Photo = strIconSaveFileName;
                model.Type  = ddlAlbumType.SelectedValue;
                model.ID    = strID;
                if (dal.UpdateAlbum(model))
                {
                    MessageBox.Show(this, "修改成功!");
                }
                else
                {
                    MessageBox.Show(this, "修改失败!");
                }
            }
            else
            {
                MessageBox.Show(this, "请输入相应标题名称!");
            }
        }