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

    
    }
}