using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace UI.images.Expro
{
    public partial class NewsEdit :BLL.AdminPage
    {
    
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                BindSortData();
                UpdateBindData();
                BindData();             

            }
        }
        public void UpdateBindData()
        {
            string Gid = this.GetRequest("Gid");
            if (Gid.Length > 0)
            {
               SQLDB.Expro_news Expro_news = new SQLDB.Expro_news();
                Expro_news.Gid = Gid;
                Expro_news = Expro_news.SelectById();
                this.DdlGTypeId.SelectedIndex = this.DdlGTypeId.Items.IndexOf(this.DdlGTypeId.Items.FindByValue(Expro_news.GTypeId));
                this.TbGTitle.Text=Expro_news.GTitle;
                this.TbGKeyWord.Text=Expro_news.GKeyWord;
                this.TbGDescription.Text=Expro_news.GDescription;
                this.TbGContent.Text=Expro_news.GContent;
                TbGAddTime.Text=Expro_news.GAddTime;
                CbGRecommend.Checked=Expro_news.GRecommmend=="1"?(true):(false);
            }
        }
        public void BindData()
        {
 
        }
        public void BindSortData()
        {
            DataTable dt = this.Db.GetTable("select Column_ID,Column_Name,Column_Depth from Expro_NewsType where Column_Depth=1");
            SortList(dt,"0");
        }
        public void SortList(DataTable dt,string parentId)
        {
         
            if (dt != null)
            {
                DataRow dr = null;
                string tempColumnId = "";
                string tempColumn_Name = "";
                int tempColumn_Depth = 0;

                if (dt.Rows.Count > 0)
                {

      

                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        dr = dt.Rows[i];
                        tempColumnId = Convert.ToString(dr["Column_ID"] ?? "");
                        tempColumn_Name = Convert.ToString(dr["Column_Name"] ?? "");
                        tempColumn_Depth = int.Parse(Convert.ToString(dr["Column_Depth"] ?? ""));

                        DataTable dtTemp = this.Db.GetTable("select Column_ID,Column_Name,Column_Depth from Expro_NewsType where Parent_ID=@Parent_ID", new System.Data.SqlClient.SqlParameter("@Parent_ID", tempColumnId));
                        if (dtTemp != null && dtTemp.Rows.Count>0)
                        {
                            string tempGe = "";
                            for (int j = 0; j < tempColumn_Depth - 1; j++)
                            {
                                tempGe += "";
                            }
                            this.DdlGTypeId.Items.Add(new ListItem(tempGe + tempColumn_Name, tempColumnId));
                            SortList(dtTemp, tempColumnId);
                        }
                        else
                        {

                            string tempGe = "";
                            for (int j = 0; j < tempColumn_Depth-1; j++)
                            {
                                tempGe += "";
                            }
                            this.DdlGTypeId.Items.Add(new ListItem(tempGe+tempColumn_Name, tempColumnId));
                        }


                    }
                }
     
            }
           
        }


        protected void BtEdit_Click(object sender, EventArgs e)
        {
            UI.cs.Util.UploadFile uf = new UI.cs.Util.UploadFile();
            string tempGPic = uf.GetSqlFile("Expro/News", 600, 360);

              SQLDB.Expro_news Expro_news = new SQLDB.Expro_news();
              Expro_news.GTypeId = this.DdlGTypeId.SelectedValue.ToString();
              Expro_news.GTitle = this.TbGTitle.Text;
              Expro_news.GKeyWord = this.TbGKeyWord.Text;
              Expro_news.GDescription = this.TbGDescription.Text;
              Expro_news.GContent = this.TbGContent.Text;
              Expro_news.GAddTime = this.TbGAddTime.Text;
              Expro_news.GPic = tempGPic;
              Expro_news.GRecommmend=CbGRecommend.Checked?("1"):("0");

            

              string Gid = this.GetRequest("Gid");
              Expro_news.Gid = Gid.Length>0?(Gid):("");
           
              if (Expro_news.Update())
              {
                  this.JSMessage = "成功编辑新闻!";
                  this.JSScript = "document.location=document.location";
              }
              else
              {
                  this.JSMessage = "更新数据时发生错误!";
                  this.JSScript = "history.go(-1)";
              }
              this.ShowMessage(JSMessage, JSScript);

 

        }

     

    
    }
}

posted on 2009-03-13 18:19 sanmao 阅读(63) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航:
 

常用链接

留言簿(5)

随笔分类

随笔档案

搜索

  •  

最新评论

阅读排行榜

评论排行榜