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);
}
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;
}
protected void linkSave_Click(object sender, EventArgs e)
{
T_Idiea _t_idiea = SetItem();
HPCBusinessLogic.DAL.T_IdieaDAL _T_dieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL();
int id = 0;
if (_t_idiea.Diea_ID == 0)
{
// Insert
id = _T_dieaDAL.InsertT_Idiea(_t_idiea);
ActionsCode = "[Nhập mới Đề Tài PV:]-->[Thêm Mới][Tintuc_id:" + id.ToString() + " ]";
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), ActionsCode);
}
else
{
// update
id = _T_dieaDAL.InsertT_Idiea(_t_idiea);
ActionsCode = "[Tin đang xử lý PV:]-->[Sửa ][Tintuc_id:" + _t_idiea.Diea_ID.ToString() + " ]";
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), ActionsCode);
}
Response.Redirect("Edit_XuLyCongViec.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&DT_id=" + Page.Request["DT_id"].ToString() + "&id=" + id.ToString() + "&Tab=" + Page.Request["Tab"].ToString());
}
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;
}
protected void dgData_EditCommand(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 = dgr_tintuc1.DataKeys[e.Item.ItemIndex].ToString();
Response.Redirect("Edit_XuLyCongViec.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&DT_id=" + Request["DT_id"].ToString() + "&ID=" + _ID.ToString() + "&Tab=" + tab);
}
}
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 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();
}
}