private void LoadData_DetaiChoDuyet() { string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); pages2.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.T_IdieaDAL _T_IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); DataSet _ds; _ds = _T_IdieaDAL.BindGridT_IdieaEditor(pages2.PageIndex, pages2.PageSize, BuildSQL(63, sOrder)); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0) { _ds = _T_IdieaDAL.BindGridT_IdieaEditor(pages2.PageIndex - 1, pages2.PageSize, BuildSQL(63, sOrder)); } dgr_tintuc2.DataSource = _ds; dgr_tintuc2.DataBind(); pages2.TotalRecords = CurrentPage2.TotalRecords = TotalRecords; TabPanel1.HeaderText = "Bài chờ duyệt (" + TotalRecords + ")"; DataSet _dsReturn; _dsReturn = _T_IdieaDAL.BindGridT_IdieaEditor(pages.PageIndex - 1, pages.PageSize, BuildSQL(62, sOrder)); this.tabpnltinXuly.HeaderText = "Đề tài đang xử lý (" + _dsReturn.Tables[1].Rows[0].ItemArray[0].ToString() + ")"; _dsReturn.Clear(); DataSet _dsReturn1; _dsReturn1 = _T_IdieaDAL.BindGridT_IdieaEditor(Pager3.PageIndex - 1, Pager3.PageSize, BuildSQL(64, sOrder)); this.TabPanel2.HeaderText = "Đề tài đã xử lý (" + _dsReturn1.Tables[1].Rows[0].ItemArray[0].ToString() + ")"; _dsReturn1.Clear(); CurrentPage2.TotalPages = pages2.CalculateTotalPages(); CurrentPage2.PageIndex = pages2.PageIndex; }
private void LoadData_Bitralai() { string sOrder = " ORDER BY Date_Duyet DESC"; pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.T_IdieaDAL _T_IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); DataSet _ds; _ds = _T_IdieaDAL.BindGridT_IdieaEditor(pages.PageIndex, pages.PageSize, BuildSQL(33, sOrder)); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0) { _ds = _T_IdieaDAL.BindGridT_IdieaEditor(pages.PageIndex - 1, pages.PageSize, BuildSQL(33, sOrder)); } dgr_tintuc2.DataSource = _ds; dgr_tintuc2.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; #region DETAI BI TRA LAI TabPanel1.HeaderText = "Bài bị trả lại (" + TotalRecords + ")"; GetTotalRecordTinBai(); #endregion }
private void LoadData_DangXuly() { string sOrder = GetOrderString() == "" ? "" : " ORDER BY Date_Duyet"; pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.T_IdieaDAL _T_IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); DataSet _ds; _ds = _T_IdieaDAL.BindGridT_IdieaEditor(pages.PageIndex, pages.PageSize, BuildSQL(32, sOrder)); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0) { _ds = _T_IdieaDAL.BindGridT_IdieaEditor(pages.PageIndex - 1, pages.PageSize, BuildSQL(32, sOrder)); } dgr_tintuc1.DataSource = _ds; dgr_tintuc1.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; #region DETAI BI TRA LAI tabpnltinXuly.HeaderText = "Bài đang xử lý (" + TotalRecords + ")"; DataSet _dsReturn; _dsReturn = _T_IdieaDAL.BindGridT_IdieaEditor(pages.PageIndex, pages.PageSize, BuildSQL(33, sOrder)); this.TabPanel1.HeaderText = "Bài bị trả lại (" + _dsReturn.Tables[1].Rows[0].ItemArray[0].ToString() + ")"; _dsReturn.Clear(); #endregion CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; }
private void DelRecordsCheckedBox() { 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())); } } } else 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())); } } } else if (TabContainer1.ActiveTabIndex == 2) { foreach (DataGridItem m_Item in dgDXL.Items) { CheckBox chk_select = (CheckBox)m_Item.FindControl("optSelect"); if (chk_select != null && chk_select.Checked) { ar.Add(double.Parse(dgDXL.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_IdieaDAL.Update_Status_tintuc(Diea_ID, 55, _user.UserID, DateTime.Now, 0); _T_IdieaDAL.Insert_Version_From_T_idiea_WithUserModify(Diea_ID, 3, 55, _user.UserID, DateTime.Now); ActionsCode = "[Danh sách Đề tài đang chờ xử lý TBT:]-->[Xóa Tin][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(); }
private void Gui_Duyet() { ArrayList ar = new ArrayList(); HPCBusinessLogic.DAL.T_IdieaDAL _T_IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); 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 == 2) { foreach (DataGridItem m_Item in dgDXL.Items) { CheckBox chk_select = (CheckBox)m_Item.FindControl("optSelect"); if (chk_select != null && chk_select.Checked) { ar.Add(double.Parse(dgDXL.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString())); } } } for (int i = 0; i < ar.Count; i++) { double Diea_ID = double.Parse(ar[i].ToString()); T_Idiea obj_Idiea = new T_Idiea(); obj_Idiea = _T_IdieaDAL.GetOneFromT_IdieaByID(int.Parse(Diea_ID.ToString())); if (obj_Idiea.Diea_Lock == true && obj_Idiea.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 (obj_Idiea.Diea_Stype == 2) { if (obj_Idiea.Number != 1) { _T_IdieaDAL.Update_Status_tintuc(Diea_ID, 22, _user.UserID, DateTime.Now, 0); _T_IdieaDAL.Insert_Version_From_T_idiea_WithUserModify(Diea_ID, 6, 22, _user.UserID, DateTime.Now); ActionsCode = "[Danh sách Đề tài đang chờ xử lý TBT:]-->[Gửi TPPV][Diea_ID:" + Diea_ID + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); } else { T_Idiea _objIdiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL _IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); HPCBusinessLogic.DAL.T_NewsDAL _T_NewsDAL = new HPCBusinessLogic.DAL.T_NewsDAL(); T_News _objT_News = SetItem(Diea_ID); _T_NewsDAL.InsertT_news(_objT_News); ActionsCode = "[TBT chuyển bài viết đề tài]-->[TKTS][Diea_ID =" + Diea_ID + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); _T_IdieaDAL.Update_Status_tintuc(Diea_ID, 64, _user.UserID, DateTime.Now, 1); } } else { if (obj_Idiea.Number != 1) { _T_IdieaDAL.Update_Status_tintuc(Diea_ID, 52, _user.UserID, DateTime.Now, 0); _T_IdieaDAL.Insert_Version_From_T_idiea_WithUserModify(Diea_ID, 2, 52, _user.UserID, DateTime.Now); ActionsCode = "[TBT duyệt đề tài:]-->[Gửi TPBT][Diea_ID:" + Diea_ID + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); } else { T_Idiea _objIdiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL _IdieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); HPCBusinessLogic.DAL.T_NewsDAL _T_NewsDAL = new HPCBusinessLogic.DAL.T_NewsDAL(); T_News _objT_News = SetItem(Diea_ID); _T_NewsDAL.InsertT_news(_objT_News); ActionsCode = "[TBT chuyển bài viết đề tài]-->[TKTS][Diea_ID =" + Diea_ID + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); _T_IdieaDAL.Update_Status_tintuc(Diea_ID, 64, _user.UserID, DateTime.Now, 1); } } } 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(); }
private void Send_TKTS() { string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); HPCBusinessLogic.DAL.T_IdieaDAL _ideal = new HPCBusinessLogic.DAL.T_IdieaDAL(); 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) { HPCBusinessLogic.DAL.T_NewsDAL tt = new HPCBusinessLogic.DAL.T_NewsDAL(); tt.IsLock(double.Parse(dgr_tintuc1.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()), 0); ar.Add(double.Parse(dgr_tintuc1.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString())); } } } else 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) { HPCBusinessLogic.DAL.T_NewsDAL tt = new HPCBusinessLogic.DAL.T_NewsDAL(); tt.IsLock(double.Parse(dgr_tintuc2.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()), 0); 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_Bitralai(); } for (int i = 0; i < ar.Count; i++) { double _ID = double.Parse(ar[i].ToString()); _ideal.Update_Status_tintuc(_ID, 23, _user.UserID, DateTime.Now, 0); _ideal.Insert_Version_From_T_idiea_WithUserModify(_ID, 3, 23, _user.UserID, DateTime.Now); this.TabContainer1_ActiveTabChanged(null, null); ActionsCode = "[Danh sách tin bài đang chờ xử lý PV:]-->[Gửi TPPV][TinTuc_ID:" + double.Parse(_ID.ToString()) + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); } if (TabContainer1.ActiveTabIndex == 0) { LoadData_DangXuly(); DataSet _dsReturn; _dsReturn = _ideal.BindGridT_IdieaEditor(pages.PageIndex, pages.PageSize, BuildSQL(32, sOrder)); System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "javascript", "javascript: SetInnerBaiDangxyLy(" + _dsReturn.Tables[1].Rows[0].ItemArray[0].ToString() + ");", true); _dsReturn.Clear(); } else if (TabContainer1.ActiveTabIndex == 1) { LoadData_Bitralai(); DataSet _dsReturn; _dsReturn = _ideal.BindGridT_IdieaEditor(pages.PageIndex, pages.PageSize, BuildSQL(33, sOrder)); System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "javascript", "javascript: SetInnerBaiTraLai(" + _dsReturn.Tables[1].Rows[0].ItemArray[0].ToString() + ");", true); _dsReturn.Clear(); } }