void PopulateItem(int _ID) { T_Idiea obj_Idiea = new T_Idiea(); T_IdieaDAL obj_DAL = new T_IdieaDAL(); obj_Idiea = obj_DAL.GetOneFromT_IdieaByID(_ID); Txt_tieude.Text = obj_Idiea.Title; 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_Idiea.Comment; txt_noidungbaiviet.Text = obj_Idiea.Diea_Articles; cbb_Loai.SelectedValue = "1"; }
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()); }
protected void linkSend_Click(object sender, EventArgs e) { if (CheckForm()) { T_Idiea _t_idiea = SetItem(); HPCBusinessLogic.DAL.T_IdieaDAL _T_dieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); int id = 0; string ActionsCode = string.Empty; if (ChildID == 0) { id = _T_dieaDAL.InsertT_Idiea(_t_idiea); ActionsCode = "[Nhập mới Đề Tài PV:]-->[Thêm Mới][Tintuc_id:" + id.ToString() + " ]"; } else { id = _T_dieaDAL.InsertT_Idiea(_t_idiea); ActionsCode = "[Tin đang xử lý PV:]-->[Sửa ][Tintuc_id:" + _t_idiea.Diea_ID.ToString() + " ]"; } _T_dieaDAL.Update_Status_tintuc(id, 62, _user.UserID, DateTime.Now, 0); _T_dieaDAL.Insert_Version_From_T_idiea_WithUserModify(id, 1, 62, _user.UserID, DateTime.Now); ActionsCode = "[Danh sách Đề tài đang chờ xử lý PV:]-->[Gửi Duyêt đề tài (TBT)][Diea_ID:" + id + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); if (Page.Request["Tab"].ToString() != "-1") { Response.Redirect("List_Idiea.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&Tab=" + Page.Request["Tab"].ToString()); } else { Response.Redirect("List_Idiea.aspx?Menu_ID=" + Request["Menu_ID"].ToString()); } } }
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); }
void PopulateItem(int _ID) { T_Idiea obj_Idiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL obj_DAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); obj_Idiea = obj_DAL.GetOneFromT_IdieaByID(_ID); Txt_tieude.Text = obj_Idiea.Title; ddlLang.SelectedValue = obj_Idiea.Lang_ID.ToString(); if (ddlLang.SelectedIndex > 0) { 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_Idiea.Comment; if (obj_Idiea.Diea_Stype == 1) { txt_noidungbaiviet.Text = obj_Idiea.Diea_Articles; cbb_Loai.SelectedValue = obj_Idiea.Diea_Stype.ToString(); } else { lb_noidungbaiviet.Visible = false; txt_noidungbaiviet.Visible = false; cbb_Loai.SelectedValue = "2"; } }
protected void linkDuyet_Click(object sender, EventArgs e) { if (CheckForm()) { T_Idiea _t_idiea = SetItem(); HPCBusinessLogic.DAL.T_IdieaDAL _T_dieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); int id = 0; if (ChildID == 0) { // Insert id = _T_dieaDAL.InsertT_Idiea(_t_idiea); ActionsCode = "[TBT Nhập mới Đề Tài:]-->[Thêm Mới][Tintuc_id:" + id.ToString() + " ]"; } else { // update id = _T_dieaDAL.InsertT_Idiea(_t_idiea); ActionsCode = "[Tin đang xử lý. TBT:]-->[Sửa ][Tintuc_id:" + _t_idiea.Diea_ID.ToString() + " ]"; } _T_dieaDAL.Update_Status_tintuc(id, 22, _user.UserID, DateTime.Now, 0); _T_dieaDAL.Insert_Version_From_T_idiea_WithUserModify(id, 6, 22, _user.UserID, DateTime.Now); ActionsCode = "[Danh sách Đề tài đang chờ xử lý TBT:]-->[Gửi TPPV][Diea_ID:" + id + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); _T_dieaDAL.IsLock(_t_idiea.Diea_ID, 0, _user.UserID, DateTime.Now);//Unlock; if (int.Parse(Page.Request["Tab"].ToString()) == 1) { Response.Redirect("List_DuyetDeTaiTBT.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&Tab=" + Page.Request["Tab"].ToString()); } else { Response.Redirect("List_DuyetDeTaiTBT.aspx?Menu_ID=" + Request["Menu_ID"].ToString()); } } }
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 PopulateItem(int _ID) { T_Idiea obj_Idiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL obj_DAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); obj_Idiea = obj_DAL.GetOneFromT_IdieaByID(_ID); Txt_tieude.Text = obj_Idiea.Title; txt_noidung.Text = obj_Idiea.Comment; 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(" Hoatdong=1 and Ma_Anpham= " + this.ddlLang.SelectedValue + " AND Ma_Chuyenmuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), "---Tất 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(); } if (obj_Idiea.Diea_Stype == 1) { txt_noidungbaiviet.Text = obj_Idiea.Diea_Articles; cbb_Loai.SelectedValue = obj_Idiea.Diea_Stype.ToString(); this.pnlEdit_Editor1.Visible = false; } else { if (Page.Request["Tab"].ToString() == "1") { this.pnlEdit_Editor1.Visible = true; lb_noidungbaiviet.Visible = true; txt_noidungbaiviet.Visible = true; cbb_Loai.SelectedValue = "2"; txt_noidungbaiviet.Text = obj_Idiea.Diea_Articles; txt_FromDate.Text = obj_Idiea.Date_From.ToString(); txt_ToDate.Text = obj_Idiea.Date_To.ToString(); BindComboxNguoiNhan(0); cbo_NguoiNhan.SelectedValue = obj_Idiea.User_NguoiNhan.ToString(); ddlGroup.Enabled = false; cbo_NguoiNhan.Enabled = false; txt_FromDate.Enabled = false; txt_ToDate.Enabled = false; cbb_LoaiBaiviet.Enabled = false; } else { this.pnlEdit_Editor1.Visible = true; lb_noidungbaiviet.Visible = false; txt_noidungbaiviet.Visible = false; cbb_Loai.SelectedValue = "2"; } } }
public T_Idiea SetItem() { T_Idiea obj_Idiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL Dal = new HPCBusinessLogic.DAL.T_IdieaDAL(); if (Page.Request.Params["id"] != null) { obj_Idiea = Dal.GetOneFromT_IdieaByID(int.Parse(Page.Request["id"].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.Lang_ID = Convert.ToInt32(this.ddlLang.SelectedValue.ToString()); obj_Idiea.Date_Edit = DateTime.Now; obj_Idiea.User_Edit = _user.UserID; obj_Idiea.Diea_Lock = true; obj_Idiea.Diea_Stype = int.Parse(cbb_Loai.SelectedValue.ToString()); if (cbb_Loai.Visible == true) { obj_Idiea.Diea_Articles = txt_noidungbaiviet.Text; } if (Page.Request["Tab"] != null) { tab = Convert.ToInt32(Page.Request["Tab"].ToString()); } if (tab == 0) { obj_Idiea.Status = 62; } else if (tab == -1) { obj_Idiea.Status = 62; } else if (tab == 1) { obj_Idiea.Status = 63; } return(obj_Idiea); }
public int InsertT_Idiea(T_Idiea _objT_Idiea) { int _inserted; try { _inserted = HPCDataProvider.Instance().InsertObjectReturn(_objT_Idiea, "Sp_InsertT_Idiea"); } catch (Exception ex) { throw ex; } return(_inserted); }
public T_Idiea SetItem() { T_Idiea obj_Idiea = new T_Idiea(); if (Page.Request.Params["id"] != null) { obj_Idiea.Diea_ID = Convert.ToInt32(Page.Request["id"].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.Lang_ID = Convert.ToInt32(this.ddlLang.SelectedValue.ToString()); obj_Idiea.Date_Edit = DateTime.Now; obj_Idiea.User_Edit = _user.UserID; obj_Idiea.Diea_Stype = 2; if (Page.Request["Tab"] != null) { tab = Convert.ToInt32(Page.Request["Tab"].ToString()); } if (tab == 0) { obj_Idiea.Status = 12; } else if (tab == -1) { obj_Idiea.Status = 12; } else if (tab == 1) { obj_Idiea.Status = 13; } return(obj_Idiea); }
protected void Page_Load(object sender, EventArgs e) { if (Request["Menu_ID"] != null && Request["Menu_ID"].ToString() != "" && Request["Menu_ID"].ToString() != String.Empty) { if (CommonLib.IsNumeric(Request["Menu_ID"]) == true) { if (!HPCSecurity.IsAccept(Convert.ToInt32(Request["Menu_ID"]))) { Response.Redirect("~/Errors/AccessDenied.aspx"); } _user = _NguoidungDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name); if (!Page.IsPostBack) { int id = int.Parse(Page.Request.QueryString["ID"].ToString()); if (Page.Request.QueryString["Menu_ID"] != null) { T_Idiea obj = new T_Idiea(); T_IdieaDAL dal = new T_IdieaDAL(); ChuyenmucDAL caDal = new ChuyenmucDAL(); obj = dal.GetOneFromT_IdieaByID(id); //add by Hung viet if (obj.Cat_ID > 0) { this.litCatName.Text = caDal.GetOneFromT_ChuyenmucByID(int.Parse(obj.Cat_ID.ToString())).Ten_ChuyenMuc; } else { this.litCatName.Text = ""; } this.litTittle.Text = obj.Title.ToString(); this.litTacgia.Text = UltilFunc.GetUserFullName(obj.User_Created); this.litContent.Text = CleanHTMLFont(obj.Comment.ToString()); this.lit_baiviet.Text = CleanHTMLFont(obj.Diea_Articles.ToString()); string count = this.litContent.Text + "" + this.lit_baiviet.Text; this.LitCount.Text = UltilFunc.WordCount(count) + " từ "; if (obj.Status == 6) { this.LitDatePublisher.Text = obj.Date_Duyet.ToString("dd/MM/yyyy HH:mm") + " (GMT + 7)"; } ViewState["ver"] = -1; } } } } }
private void LoadComboBox() { int id = int.Parse(Page.Request.QueryString["ID"].ToString()); T_Idiea obj = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL dal = new HPCBusinessLogic.DAL.T_IdieaDAL(); int _curentID = dal.GetOneFromT_IdieaByID(id).User_Created; UltilFunc.BindCombox(ddlLang, "ID", "TenNgonNgu", "T_NgonNgu", " Hoatdong=1 and ID=" + HPCComponents.Global.DefaultCombobox + " and ID in (select Ma_Ngonngu from T_Nguoidung_NgonNgu where Ma_Nguoidung=" + _user.UserID + ")", "---Tất cả---"); ddlLang.SelectedIndex = UltilFunc.GetIndexControl(ddlLang, HPCComponents.Global.DefaultCombobox); if (ddlLang.SelectedIndex != 0) { UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + ddlLang.SelectedValue, "-Chọn chuyên mục-", "Ma_Chuyenmuc_Cha"); } UltilFunc.BindCombox(ddlGroup, "Ma_nhom", "Ten_nhom", "T_Nhom", " 1=1 Order by Ten_Nhom", ""); BindComboxNguoiNhan(0); }
protected void dgData_EditCommand3(object source, DataGridCommandEventArgs e) { if (e.CommandArgument.ToString().ToLower() == "edit") { int tab = TabContainer1.ActiveTabIndex; T_Idiea obj = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL Dal = new HPCBusinessLogic.DAL.T_IdieaDAL(); string _ID = dgr_tintuc3.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; } int CV_ID = Dal.GetOneFromT_IdieaByID(Convert.ToInt32(_ID.ToString())).CV_id; Dal.IsLock(double.Parse(_ID), 1, _user.UserID, DateTime.Now);// trang thai bai lock Response.Redirect("Edit_TraLaiPV.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&CV=" + CV_ID + "&ID=" + _ID.ToString() + "&Tab=" + tab); } }
protected void linkSave_Click(object sender, EventArgs e) { if (CheckForm()) { T_Idiea _t_idiea = SetItem(); HPCBusinessLogic.DAL.T_IdieaDAL _T_dieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); int id = 0; string ActionsCode = string.Empty; if (ChildID == 0) { id = _T_dieaDAL.InsertT_Idiea(_t_idiea); ActionsCode = "[Nhập mới Đề Tài PV:]-->[Thêm Mới][Tintuc_id:" + id.ToString() + " ]"; } else { 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.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); Response.Redirect("Edit_Idiea.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&Tab=" + Page.Request["Tab"].ToString() + "&ID=" + id.ToString()); } }
public T_Allotments SetItem1() { int id = Convert.ToInt32(Page.Request["id"].ToString()); T_Idiea _objIdiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL _idieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); _objIdiea = _idieaDAL.GetOneFromT_IdieaByID(id); T_Allotments _obj_Allotment = new T_Allotments(); _obj_Allotment.Idiea_ID = id; _obj_Allotment.Lang_ID = Convert.ToInt32(this.ddlLang.SelectedValue.ToString()); _obj_Allotment.User_Created = _user.UserID; _obj_Allotment.User_Duyet = _user.UserID; _obj_Allotment.Date_Created = DateTime.Now; _obj_Allotment.Type = Convert.ToInt32(cbb_LoaiBaiviet.SelectedValue); _obj_Allotment.Request = txt_noidung.Text; _obj_Allotment.Date_start = txt_FromDate.Text; _obj_Allotment.Date_End = txt_ToDate.Text; _obj_Allotment.Lock = false; _obj_Allotment.User_NguoiNhan = int.Parse(cbo_NguoiNhan.SelectedValue); _obj_Allotment.Cat_ID = _objIdiea.Cat_ID; _obj_Allotment.Title = Txt_tieude.Text.ToString(); if (Page.Request["Tab"] != null) { int _tab = Convert.ToInt32(Page.Request["Tab"].ToString()); if (_tab == 0) { _obj_Allotment.Status = 32; } else { _obj_Allotment.Status = 23; } } return(_obj_Allotment); }
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; } }
protected void PopulateItem(int _ID) { T_Idiea obj_Idiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL obj_DAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); obj_Idiea = obj_DAL.GetOneFromT_IdieaByID(_ID); Txt_tieude.Text = obj_Idiea.Title; ddlLang.SelectedValue = obj_Idiea.Lang_ID.ToString(); cbo_chuyenmuc.Items.Clear(); if (ddlLang.SelectedIndex > 0) { UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + ddlLang.SelectedValue, "-Chọn chuyên mục-", "Ma_Chuyenmuc_Cha"); 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_Idiea.Comment; }
protected void Page_Load(object sender, EventArgs e) { if (Request["Menu_ID"] != null && Request["Menu_ID"].ToString() != "" && Request["Menu_ID"].ToString() != String.Empty) { if (CommonLib.IsNumeric(Request["Menu_ID"]) == true) { if (!HPCSecurity.IsAccept(Convert.ToInt32(Request["Menu_ID"]))) { Response.Redirect("~/Errors/AccessDenied.aspx"); } _user = _NguoidungDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name); if (!Page.IsPostBack) { int id = int.Parse(Page.Request.QueryString["ID"].ToString()); if (Page.Request.QueryString["Menu_ID"] != null) { T_Idiea obj = new T_Idiea(); T_IdieaVersion _obj2 = new T_IdieaVersion(); T_IdieaDAL dal = new T_IdieaDAL(); ChuyenmucDAL caDal = new ChuyenmucDAL(); obj = dal.GetOneFromT_IdieaByID(id); //add by nvthai T_IdieaVersion _objVer = new T_IdieaVersion(); if (obj.Diea_Stype == 1) { _objVer = dal.GetOneFromT_IdieaVersionByIDVersion(id, 4, 54); _obj2 = dal.GetOneFromT_IdieaVersionByIDVersion(id, 1, 62); } else { _objVer = dal.GetOneFromT_IdieaVersionByIDVersion(id, 4, 54); _obj2 = dal.GetOneFromT_IdieaVersionByIDVersion(id, 3, 23); } //add by Hung viet if (obj.Cat_ID > 0) { this.litCatName.Text = caDal.GetOneFromT_ChuyenmucByID(int.Parse(_obj2.Cat_ID.ToString())).Ten_ChuyenMuc; this.litCM.Text = caDal.GetOneFromT_ChuyenmucByID(int.Parse(_objVer.Cat_ID.ToString())).Ten_ChuyenMuc; } else { this.litCatName.Text = ""; this.litCM.Text = ""; } this.litTittle.Text = _obj2.Title.ToString(); this.litTacgia.Text = UltilFunc.GetUserFullName(_obj2.User_Created); this.litContent.Text = CleanHTMLFont(_obj2.Comment.ToString()); this.lit_baiviet.Text = CleanHTMLFont(_obj2.Diea_Articles.ToString()); string coutstring = this.litContent.Text + " " + this.lit_baiviet.Text; this.litCounter.Text = UltilFunc.WordCount(coutstring).ToString() + " từ"; this.litTenDetai.Text = _objVer.Title.ToString(); this.literNguoiviet.Text = UltilFunc.GetUserFullName(_objVer.User_Edit); this.litContents.Text = CleanHTMLFont(_objVer.Comment.ToString()); this.litbai.Text = CleanHTMLFont(_objVer.Diea_Articles.ToString()); string coutstring2 = this.litContents.Text + " " + this.litbai.Text; this.litCouter2.Text = UltilFunc.WordCount(coutstring2).ToString() + " từ"; ViewState["ver"] = -1; } } } } }
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(); }
private void Gui_DuyetBT() { double DieaID = double.Parse(Page.Request["id"].ToString()); T_Idiea _t_idiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL _T_dieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); HPCBusinessLogic.DAL.T_AllotmentDAL _objT_AllDAL = new HPCBusinessLogic.DAL.T_AllotmentDAL(); T_Allotments _obj = new T_Allotments(); T_Idiea _objIdiea = _T_dieaDAL.GetOneFromT_IdieaByID(int.Parse(DieaID.ToString())); int id = 0; if (_objIdiea.Diea_Stype == 1) { _t_idiea = SetItem(); id = _T_dieaDAL.InsertT_Idiea(_t_idiea); if (_T_dieaDAL.GetOneFromT_IdieaByID(int.Parse(DieaID.ToString())).Diea_Lock == true && _T_dieaDAL.GetOneFromT_IdieaByID(int.Parse(DieaID.ToString())).User_Edit != _user.UserID) { FuncAlert.AlertJS(this, "Bài đang có người làm việc.!"); return; } _T_dieaDAL.IsLock(DieaID, 0, _user.UserID, DateTime.Now); _T_dieaDAL.Update_Status_tintuc(DieaID, 52, _user.UserID, DateTime.Now, 0); _T_dieaDAL.Insert_Version_From_T_idiea_WithUserModify(DieaID, 2, 52, _user.UserID, DateTime.Now); ActionsCode = "[Gửi Duyệt(TBT)][Diea_ID:" + DieaID + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); } else { if (DateTime.Parse(txt_FromDate.Text.Trim(), new System.Globalization.CultureInfo("fr-FR")) > DateTime.Parse(txt_ToDate.Text.Trim(), new System.Globalization.CultureInfo("fr-FR")) || DateTime.Parse(txt_FromDate.Text.Trim() + " 23:59:59", new System.Globalization.CultureInfo("fr-FR")) < DateTime.Now) { FuncAlert.AlertJS(this, "Ngày bắt đầu phải lớn hơn hoặc bằng ngày hiện tại và nhỏ hơn hoặc bằng ngày kết thúc!"); return; } if (cbo_NguoiNhan.SelectedIndex == 0) { FuncAlert.AlertJS(this, "Trước khi lưu bạn phải chọn người nhận việc "); return; } _obj = SetItem1(); id = _objT_AllDAL.InsertT_Allotment(_obj); _t_idiea = SetItem(); id = _T_dieaDAL.InsertT_Idiea(_t_idiea); if (_T_dieaDAL.GetOneFromT_IdieaByID(int.Parse(DieaID.ToString())).Diea_Lock == true && _T_dieaDAL.GetOneFromT_IdieaByID(int.Parse(DieaID.ToString())).User_Edit != _user.UserID) { FuncAlert.AlertJS(this, "Bài đang có người làm việc.!"); return; } _T_dieaDAL.IsLock(DieaID, 0, _user.UserID, DateTime.Now); _T_dieaDAL.Update_Status_tintuc(DieaID, 52, _user.UserID, DateTime.Now, 0); _T_dieaDAL.Insert_Version_From_T_idiea_WithUserModify(DieaID, 2, 52, _user.UserID, DateTime.Now); ActionsCode = "[Gửi Duyệt(TBT)][Diea_ID:" + DieaID + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); } _T_dieaDAL.IsLock(DieaID, 0, _user.UserID, DateTime.Now); if (int.Parse(Page.Request["Tab"].ToString()) != 0) { Response.Redirect("List_DuyetDeTaiTPPV.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&Tab=" + Page.Request["Tab"].ToString()); } else { Response.Redirect("List_DuyetDeTaiTPPV.aspx?Menu_ID=" + Request["Menu_ID"].ToString()); } }
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(); }
public T_Idiea SetItem() { T_Idiea obj_Idiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL _objDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); if (Page.Request.Params["ID"] != null && cbb_Loai.SelectedValue == "1") { obj_Idiea = _objDAL.GetOneFromT_IdieaByID(int.Parse(Page.Request["id"].ToString())); obj_Idiea.Diea_Stype = 1; obj_Idiea.Diea_Articles = txt_noidungbaiviet.Text; } else { obj_Idiea = _objDAL.GetOneFromT_IdieaByID(int.Parse(Page.Request["id"].ToString())); if (Page.Request["Tab"] != null) { int _tab = Convert.ToInt32(Page.Request["Tab"].ToString()); if (_tab == 2) { obj_Idiea.Status = 26; } else { obj_Idiea.Status = 23; } } obj_Idiea.Diea_Stype = 2; obj_Idiea.Date_From = txt_FromDate.Text; obj_Idiea.Date_To = txt_ToDate.Text; obj_Idiea.User_NguoiNhan = int.Parse(cbo_NguoiNhan.SelectedValue); } 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 (txt_noidungbaiviet.Text.Length > 0) { obj_Idiea.Diea_Articles = txt_noidungbaiviet.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.Lang_ID = Convert.ToInt32(this.ddlLang.SelectedValue.ToString()); obj_Idiea.Date_Edit = DateTime.Now; obj_Idiea.User_Edit = _user.UserID; if (Page.Request["Tab"] != null) { tab = Convert.ToInt32(Page.Request["Tab"].ToString()); } return(obj_Idiea); }
protected void linkSave_Click(object sender, EventArgs e) { if (CheckForm()) { double DieaID = double.Parse(Page.Request["id"].ToString()); T_Idiea _t_idiea = new T_Idiea(); HPCBusinessLogic.DAL.T_IdieaDAL _T_dieaDAL = new HPCBusinessLogic.DAL.T_IdieaDAL(); HPCBusinessLogic.DAL.T_AllotmentDAL _objT_AllDAL = new HPCBusinessLogic.DAL.T_AllotmentDAL(); T_Allotments _obj = new T_Allotments(); T_Idiea _objIdiea = _T_dieaDAL.GetOneFromT_IdieaByID(int.Parse(DieaID.ToString())); int id = 0; if (_objIdiea.Diea_Stype == 1) { _t_idiea = SetItem(); id = _T_dieaDAL.InsertT_Idiea(_t_idiea); _T_dieaDAL.Insert_Version_From_T_idiea_WithUserModify(DieaID, 2, 23, _user.UserID, DateTime.Now); ActionsCode = "[TPPV Sửa đề tài:]-->[ Sửa][Đề tài_ID=" + id.ToString() + " ]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); } else { if (DateTime.Parse(txt_FromDate.Text.Trim(), new System.Globalization.CultureInfo("fr-FR")) > DateTime.Parse(txt_ToDate.Text.Trim(), new System.Globalization.CultureInfo("fr-FR")) || DateTime.Parse(txt_FromDate.Text.Trim() + " 23:59:59", new System.Globalization.CultureInfo("fr-FR")) < DateTime.Now) { FuncAlert.AlertJS(this, "Ngày bắt đầu phải lớn hơn hoặc bằng ngày hiện tại và nhỏ hơn hoặc bằng ngày kết thúc!"); return; } if (cbo_NguoiNhan.SelectedValue == "0" || cbo_NguoiNhan.SelectedValue == "-1") { FuncAlert.AlertJS(this, "Trước khi lưu bạn phải chọn người nhận việc !"); return; } _obj = SetItem1(); id = _objT_AllDAL.InsertT_Allotment(_obj); if (Page.Request["Tab"] != null) { int _tab = Convert.ToInt32(Page.Request["Tab"].ToString()); if (_tab == 0) { _T_dieaDAL.Update_Status_tintuc(DieaID, 32, _user.UserID, DateTime.Now, 0); } else { _t_idiea = SetItem(); id = _T_dieaDAL.InsertT_Idiea(_t_idiea); if (_tab == 2) { _T_dieaDAL.Update_Status_tintuc(DieaID, 26, _user.UserID, DateTime.Now, 0); } else { _T_dieaDAL.Update_Status_tintuc(DieaID, 23, _user.UserID, DateTime.Now, 0); } } } ActionsCode = "[TPPV Phân công công việc:]-->[PCCV][T_Allotment_ID=" + id + "]"; UltilFunc.Log_Action(_user.UserID, _user.UserName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), ActionsCode); } _T_dieaDAL.IsLock(DieaID, 0, _user.UserID, DateTime.Now); if (int.Parse(Page.Request["Tab"].ToString()) != 0) { Response.Redirect("List_DuyetDeTaiTPPV.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&Tab=" + Page.Request["Tab"].ToString()); } else { Response.Redirect("List_DuyetDeTaiTPPV.aspx?Menu_ID=" + Request["Menu_ID"].ToString()); } } }