private T_News SetItem(double id)
        {
            T_News  obj_news  = new T_News();
            T_Idiea _objIdiea = new T_Idiea();

            HPCBusinessLogic.DAL.T_IdieaDAL _IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL();
            _objIdiea = _IdieaDAL.GetOneFromT_IdieaByID(int.Parse(id.ToString()));

            obj_news.News_Tittle        = _objIdiea.Title;
            obj_news.CAT_ID             = _objIdiea.Cat_ID;
            obj_news.Lang_ID            = _objIdiea.Lang_ID;
            obj_news.News_Body          = _objIdiea.Diea_Articles;
            obj_news.News_PublishNumber = int.Parse(DateTime.Now.Month.ToString());
            obj_news.News_PublishYear   = int.Parse(DateTime.Now.Year.ToString());
            obj_news.News_DateCreated   = DateTime.Now;
            obj_news.News_DateEdit      = DateTime.Now;
            obj_news.News_DatePublished = DateTime.Now;
            obj_news.News_DateApproved  = DateTime.Now;
            obj_news.News_AuthorID      = _objIdiea.User_Created;
            obj_news.News_AprovedID     = _user.UserID;
            obj_news.News_EditorID      = _user.UserID;
            obj_news.News_PublishedID   = _user.UserID;
            obj_news.News_CopyFrom      = 0;
            obj_news.News_Status        = 22;

            return(obj_news);
        }
        protected void dgDXL_EditCommand1(object source, DataGridCommandEventArgs e)
        {
            if (e.CommandArgument.ToString().ToLower() == "edit")
            {
                int tab = TabContainer1.ActiveTabIndex;

                HPCBusinessLogic.DAL.T_IdieaDAL Dal = new HPCBusinessLogic.DAL.T_IdieaDAL();
                string _ID = dgDXL.DataKeys[e.Item.ItemIndex].ToString();

                if (Dal.GetOneFromT_IdieaByID(int.Parse(_ID)).Diea_Lock == true && Dal.GetOneFromT_IdieaByID(int.Parse(_ID)).User_Edit != _user.UserID)
                {
                    System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('Bài đang có người làm việc.!');", true);
                    return;
                }


                Dal.IsLock(double.Parse(_ID), 1, _user.UserID, DateTime.Now);// trang thai bai lock
                Response.Redirect("Edit_DuyetDeTaiTBT.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&ID=" + _ID.ToString() + "&Tab=" + tab);
            }
        }
        private void TraLai()
        {
            HPCBusinessLogic.DAL.T_IdieaDAL _T_IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL();
            string    sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
            ArrayList ar     = new ArrayList();

            if (TabContainer1.ActiveTabIndex == 0)
            {
                foreach (DataGridItem m_Item in dgr_tintuc1.Items)
                {
                    CheckBox chk_select = (CheckBox)m_Item.FindControl("optSelect");
                    if (chk_select != null && chk_select.Checked)
                    {
                        ar.Add(double.Parse(dgr_tintuc1.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()));
                    }
                }
            }
            if (TabContainer1.ActiveTabIndex == 1)
            {
                foreach (DataGridItem m_Item in dgr_tintuc2.Items)
                {
                    CheckBox chk_select = (CheckBox)m_Item.FindControl("optSelect");
                    if (chk_select != null && chk_select.Checked)
                    {
                        ar.Add(double.Parse(dgr_tintuc2.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()));
                    }
                }
            }

            if (TabContainer1.ActiveTabIndex == 0)
            {
                LoadData_DangXuly();
            }
            else if (TabContainer1.ActiveTabIndex == 1)
            {
                LoadData_DetaiChoDuyet();
            }
            else if (TabContainer1.ActiveTabIndex == 2)
            {
                LoadData_Bitralai();
            }

            for (int i = 0; i < ar.Count; i++)
            {
                double  Diea_ID   = double.Parse(ar[i].ToString());
                T_Idiea _objIdiea = new T_Idiea();
                _objIdiea = _T_IdieaDAL.GetOneFromT_IdieaByID(int.Parse(Diea_ID.ToString()));

                if (_objIdiea.Diea_Lock == true && _objIdiea.User_Edit != _user.UserID)
                {
                    FuncAlert.AlertJS(this, "Bài đang có người làm việc.!");
                    return;
                }

                _T_IdieaDAL.IsLock(Diea_ID, 0, _user.UserID, DateTime.Now);

                if (_T_IdieaDAL.GetOneFromT_IdieaVersionByID(int.Parse(Diea_ID.ToString()), 5, 63) == true)
                {
                    _T_IdieaDAL.Update_Status_tintuc(Diea_ID, 53, _user.UserID, DateTime.Now, 0);
                    _T_IdieaDAL.Insert_Version_From_T_idiea_WithUserModify(Diea_ID, 6, 53, _user.UserID, DateTime.Now);

                    ActionsCode = "[Danh sách Đề tài đang chờ xử lý TBT:]-->[Trả lại Dề xuất ĐT][Diea_ID:" + Diea_ID + "]";
                    UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode);
                }
                else
                {
                    _T_IdieaDAL.Update_Status_tintuc(Diea_ID, 13, _user.UserID, DateTime.Now, 0);
                    _T_IdieaDAL.Insert_Version_From_T_idiea_WithUserModify(Diea_ID, 6, 13, _user.UserID, DateTime.Now);

                    ActionsCode = "[Danh sách Đề tài đang chờ xử lý TBT:]-->[Trả lại Đề xuât ĐT][Diea_ID:" + Diea_ID + "]";
                    UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode);
                }
            }
            if (TabContainer1.ActiveTabIndex == 0)
            {
                LoadData_DangXuly();
            }
            else if (TabContainer1.ActiveTabIndex == 1)
            {
                LoadData_DetaiChoDuyet();
            }
            else if (TabContainer1.ActiveTabIndex == 2)
            {
                LoadData_Bitralai();
            }
            DataSet _dsReturn;
            DataSet _dsReturn1;
            DataSet _dsReturn2;

            _dsReturn  = _T_IdieaDAL.BindGridT_IdieaEditor(pages.PageIndex, pages.PageSize, BuildSQL(62, sOrder));
            _dsReturn1 = _T_IdieaDAL.BindGridT_IdieaEditor(pages2.PageIndex - 1, pages2.PageSize, BuildSQL(63, sOrder));
            _dsReturn2 = _T_IdieaDAL.BindGridT_IdieaEditor(Pager3.PageIndex - 1, Pager3.PageSize, BuildSQL(64, sOrder));
            System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "javascript", "javascript: SetTotal(" + _dsReturn.Tables[1].Rows[0].ItemArray[0].ToString() + "," + _dsReturn1.Tables[1].Rows[0].ItemArray[0].ToString() + "," + _dsReturn2.Tables[1].Rows[0].ItemArray[0].ToString() + ");", true);
            _dsReturn.Clear();
            _dsReturn1.Clear();
            _dsReturn2.Clear();
        }