void PopulateItem1(int _ID)
{
T_Allotments _obj = new T_Allotments();
T_AllotmentDAL _objDAL = new T_AllotmentDAL();
T_Idiea obj_Idiea = new T_Idiea();
T_IdieaDAL obj_DAL = new T_IdieaDAL();
_obj = _objDAL.GetOneFromT_AllotmentByID(_ID);
obj_Idiea = obj_DAL.GetOneFromT_IdieaByID(_obj.Idiea_ID);
ddlLang.SelectedValue = obj_Idiea.Lang_ID.ToString();
cbo_chuyenmuc.Items.Clear();
if (ddlLang.SelectedIndex > 0)
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_Chuyenmuc", "Ten_Chuyenmuc", "T_Chuyenmuc", string.Format(" Ma_Anpham=" + this.ddlLang.SelectedValue.ToString() + " AND Ma_Chuyenmuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), "---Chọn chuyên mục---", "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
cbo_chuyenmuc.SelectedIndex = CommonLib.GetIndexControl(cbo_chuyenmuc, obj_Idiea.Cat_ID.ToString());
}
else
{
this.cbo_chuyenmuc.DataSource = null;
this.cbo_chuyenmuc.DataBind();
}
txt_noidung.Text = _obj.Request;
txt_noidungbaiviet.Text = obj_Idiea.Diea_Articles;
cbb_Loai.SelectedValue = "1";
}
private void LoadData_Bitralai()
{
string sOrder = GetOrderString1() == "" ? "" : " ORDER BY " + GetOrderString1();
pages.PageSize = Global.MembersPerPage;
T_AllotmentDAL _DAL = new T_AllotmentDAL();
DataSet _ds;
_ds = _DAL.BindGridT_AllotmentEditor(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 = _DAL.BindGridT_AllotmentEditor(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 DANG XU LY
TabPanel1.HeaderText = "Đề tài đã hoàn thành (" + TotalRecords + ")";
DataSet _dsReturn;
_dsReturn = _DAL.BindGridT_AllotmentEditor(pages.PageIndex - 1, pages.PageSize, BuildSQL(32, sOrder));
this.tabpnltinXuly.HeaderText = "Đề tài đang xử lý (" + _dsReturn.Tables[1].Rows[0].ItemArray[0].ToString() + ")";
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "javascript", "javascript: SetTotal(" + _dsReturn.Tables[1].Rows[0].ItemArray[0].ToString() + "," + TotalRecords + ");", true);
_dsReturn.Clear();
#endregion
}
public T_Idiea SetItem()
{
T_IdieaDAL _objDAL = new T_IdieaDAL();
T_Idiea obj_Idiea = new T_Idiea();
T_Allotments obj_All = new T_Allotments();
T_AllotmentDAL _DAL = new T_AllotmentDAL();
if (Page.Request.Params["id"] != null)
{
int Diea_ID = Convert.ToInt32(Page.Request["id"].ToString());
obj_Idiea = _objDAL.GetOneFromT_IdieaByID(Diea_ID);
}
obj_All = _DAL.GetOneFromT_AllotmentByIdieaID(int.Parse(Page.Request["DT_id"].ToString()));
obj_Idiea.Lang_ID = Convert.ToInt32(this.ddlLang.SelectedValue.ToString());
if (Txt_tieude.Text != "")
{
obj_Idiea.Title = UltilFunc.CleanFormatTags(Txt_tieude.Text);
}
if (txt_noidung.Text.Length > 0)
{
obj_Idiea.Comment = txt_noidung.Text;
}
if (int.Parse(cbo_chuyenmuc.SelectedIndex.ToString()) > 0)
{
obj_Idiea.Cat_ID = int.Parse(cbo_chuyenmuc.SelectedValue.ToString());
}
obj_Idiea.User_Created = _user.UserID;
obj_Idiea.User_Duyet = _user.UserID;
obj_Idiea.Date_Created = DateTime.Now;
obj_Idiea.Date_Duyet = DateTime.Now;
obj_Idiea.Diea_Stype = 2;
obj_Idiea.Date_Edit = DateTime.Now;
obj_Idiea.User_Edit = _user.UserID;
obj_Idiea.Diea_Articles = txt_noidungbaiviet.Text;
//Add by nvthai
if (obj_All != null)
{
obj_Idiea.Date_From = obj_All.Date_start;
obj_Idiea.Date_To = obj_All.Date_End;
obj_Idiea.User_NguoiNhan = obj_All.User_NguoiNhan;
}
//end
if (Page.Request["Tab"] != null)
{
tab = Convert.ToInt32(Page.Request["Tab"].ToString());
}
if (int.Parse(Page.Request["Tab"].ToString()) == 1)
{
obj_Idiea.Status = 33;
}
else
{
obj_Idiea.Status = 32;
}
obj_Idiea.CV_id = int.Parse(Page.Request["DT_id"].ToString());
return(obj_Idiea);
}
private void DelRecordsCheckedBox()
{
T_AllotmentDAL _T_IdieaDAL = new T_AllotmentDAL();
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()));
}
}
}
if (TabContainer1.ActiveTabIndex == 0)
{
LoadData_DangXuly();
}
else if (TabContainer1.ActiveTabIndex == 1)
{
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);
ActionsCode = "[Danh sách Đề tài đang chờ xử lý PV:]-->[Xóa Tin][Diea_ID:" + Diea_ID + "]";
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), ActionsCode);
}
if (TabContainer1.ActiveTabIndex == 0)
{
LoadData_DangXuly();
}
else if (TabContainer1.ActiveTabIndex == 1)
{
LoadData_Bitralai();
}
SetTotal();
}
public void SetTotal()
{
string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
T_AllotmentDAL _T_IdieaDAL = new T_AllotmentDAL();
DataSet _dsReturn;
DataSet _dsReturn1;
_dsReturn = _T_IdieaDAL.BindGridT_AllotmentEditor(pages.PageIndex, pages.PageSize, BuildSQL(32, sOrder));
_dsReturn1 = _T_IdieaDAL.BindGridT_AllotmentEditor(pages.PageIndex, pages.PageSize, BuildSQL(33, 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() + ");", true);
_dsReturn.Clear();
_dsReturn1.Clear();
}
public override void DataBind()
{
T_Idiea obj = new T_Idiea();
T_Allotments _Allotment = new T_Allotments();
T_IdieaDAL dal = new T_IdieaDAL();
T_AllotmentDAL _AllotmentDAL = new T_AllotmentDAL();
ChuyenmucDAL caDal = new ChuyenmucDAL();
if (Request["DT_id"] != null && Request["DT_id"].ToString() != "" && Request["DT_id"].ToString() != String.Empty)
{
int id = int.Parse(Page.Request["DT_id"].ToString());
_Allotment = _AllotmentDAL.GetOneFromT_AllotmentByID(id);
obj = dal.GetOneFromT_IdieaByID(_Allotment.Idiea_ID);
this.T_AllotmentNgayHT.Text = _Allotment.Date_End.ToString();
this.ltrYeuCau.Text = _Allotment.Request.ToString();
if (obj.Cat_ID > 0)
{
this.lblNameCM.Text = caDal.GetOneFromT_ChuyenmucByID(int.Parse(obj.Cat_ID.ToString())).Ten_ChuyenMuc;
}
if (obj.Title.ToString().Length > 0)
{
this.lbtieude.Text = obj.Title.ToString();
}
if (_Allotment.Type == 1)
{
ltr_loaibai1.Text = "Bài viết";
}
else
{
ltr_loaibai1.Text = "Bài ảnh";
}
MaCM = obj.Cat_ID;
}
}
private void Gui_Duyet()
{
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()));
}
}
}
if (TabContainer1.ActiveTabIndex == 0)
{
LoadData_DangXuly();
}
else if (TabContainer1.ActiveTabIndex == 1)
{
LoadData_Bitralai();
}
for (int i = 0; i < ar.Count; i++)
{
T_Idiea _obj = new T_Idiea();
T_IdieaDAL _objDAL = new T_IdieaDAL();
double _ID = double.Parse(ar[i].ToString());
if (_objDAL.BinT_Idiea(_ID, 32) == true || _objDAL.BinT_Idiea(_ID, 33) == true)
{
FuncAlert.AlertJS(this, "Bạn vẫn còn bài chưa gửi đi trong đề tài này!");
return;
}
T_AllotmentDAL DAL = new T_AllotmentDAL();
DAL.Update_Status_tintuc(_ID, 33, _user.UserID, DateTime.Now);
ActionsCode = "[Danh sách công việc đang xử lý:]-->[hoàn thành(CV)][ID: " + _ID + "]";
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), ActionsCode);
}
if (TabContainer1.ActiveTabIndex == 0)
{
LoadData_DangXuly();
}
else if (TabContainer1.ActiveTabIndex == 1)
{
LoadData_Bitralai();
}
SetTotal();
}
