public void Danhsach_Yeucau() { string where = " Loai = 2 "; if (!String.IsNullOrEmpty(this.hdnValue.Value.ToString().Trim())) { where += " AND Ma_Khachhang = " + string.Format(hdnValue.Value.ToString()) + " "; } if (!String.IsNullOrEmpty(this.txt_Noidung.Text.Trim())) { where += " AND TenQuangCao like N'%" + this.txt_Noidung.Text.Trim() + "%'"; } pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.YeucauDAL _yeucauDAL = new HPCBusinessLogic.DAL.YeucauDAL(); DataSet _ds; _ds = _yeucauDAL.BindGridT_Yeucauquangcao(pages.PageIndex, pages.PageSize, where); 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 = _yeucauDAL.BindGridT_Yeucauquangcao(pages.PageIndex - 1, pages.PageSize, where); } grdList.DataSource = _ds.Tables[0]; grdList.DataBind(); _ds.Clear(); hdnValue.Value = ""; pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["PageIndex"] = pages.PageIndex; }
public void grdList_EditCommand(object source, DataGridCommandEventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion HPCBusinessLogic.DAL.YeucauDAL objDAL = new HPCBusinessLogic.DAL.YeucauDAL(); if (e.CommandArgument.ToString().ToLower() == "edit") { int cusID = Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString()); Response.Redirect("~/Phathanh/YeucauPHEdit.aspx?Menu_ID=" + Page.Request["Menu_ID"].ToString() + "&ID=" + cusID); } if (e.CommandArgument.ToString().ToLower() == "isstatus") { double _ID = Convert.ToDouble(this.grdList.DataKeys[e.Item.ItemIndex].ToString()); Int16 _check = objDAL.GetOneFromT_YeuCauByID(_ID).Trangthai; if (_check == 0) { objDAL.UpdateinfoT_Yeucau(" [Trangthai] = 1 where ID = " + _ID.ToString()); action.Thaotac = "[Cập nhật trạng thái bảng T_Yeucau][ID:" + _ID.ToString() + " ][Trangthai = 1]"; Danhsach_Yeucau(); } if (_check == 1) { bool _bool; _bool = IsHopdongExsits(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString())); if (_bool == false) { objDAL.UpdateinfoT_Yeucau(" [Trangthai] = 0 where ID = " + _ID.ToString()); action.Thaotac = "[Cập nhật trạng thái bảng T_Yeucau][ID:" + _ID.ToString() + " ][Trangthai = 0]"; } else { System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('Yêu cầu này đã làm hợp đồng!');", true); return; } Danhsach_Yeucau(); } } if (e.CommandArgument.ToString().ToLower() == "delete") { bool _bool; _bool = IsHopdongExsits(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString())); if (_bool == false) { objDAL.DeleteFromT_YeuCauQCByID(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString())); action.Thaotac = "[Thao tác Xóa Trong Bảng T_Yeucau][ID:" + this.grdList.DataKeys[e.Item.ItemIndex].ToString() + " ]"; Danhsach_Yeucau(); } else { return; } } }
private void GetItem(double _id) { T_Yeucau _objYeucau = new T_Yeucau(); HPCBusinessLogic.DAL.YeucauDAL _yeucauDAL = new HPCBusinessLogic.DAL.YeucauDAL(); _objYeucau = _yeucauDAL.GetOneFromT_YeuCauByID(_id); if (_id > 0) { this.ddl_TenKH.SelectedIndex = UltilFunc.GetIndexControl(ddl_TenKH, _objYeucau.Ma_Khachhang.ToString()); this.ddl_TenKH.Enabled = false; } this.txt_Tieude.Text = _objYeucau.TenQuangCao; this.ckeNoidung.Text = _objYeucau.NoidungQC; }
protected void Save_Click(object sender, EventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion this.Page.Validate(vs_Themmoi.ValidationGroup); if (!Page.IsValid) { return; } HopdongDAL _hopdongDAL = new HopdongDAL(); T_Hopdong _hopdong = SetItem(); int menuID = 0; if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty) { menuID = int.Parse(Request["ID"].ToString()); } int _return = _hopdongDAL.InsertT_Hopdong(_hopdong); if (Page.Request.Params["id"] == null) { #region Update T_Yeucau khi da co hop dong --> Trangthai = 2 HPCBusinessLogic.DAL.YeucauDAL _yeucauDAL = new HPCBusinessLogic.DAL.YeucauDAL(); _yeucauDAL.UpdateinfoT_Yeucau(" [Trangthai] = 2 where ID = " + ddl_Yeucau.SelectedValue.ToString()); #endregion action.Thaotac = "[Thêm mới hợp đồng]-->[mã hợp đồng:" + _return.ToString() + " ]"; System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + Global.RM.GetString("VALIDATE_ADDNEWS") + "');", true); actionDAL.InserT_Lichsu_Thaotac_Hethong(action); Clear(); BindCombo(); return; } if (Page.Request.Params["id"] != null) { action.Thaotac = "[Sửa hợp đồng]-->[Mã hợp đồng:" + Page.Request["id"].ToString() + " ]"; System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + Global.RM.GetString("UpdateSuccessfully") + "');", true); actionDAL.InserT_Lichsu_Thaotac_Hethong(action); Clear(); BindCombo(); return; } }
protected void Save_Click(object sender, EventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion this.Page.Validate(vs_Themmoi.ValidationGroup); if (!Page.IsValid) { return; } HPCBusinessLogic.DAL.YeucauDAL _cvDAL = new HPCBusinessLogic.DAL.YeucauDAL(); T_Yeucau _yc = SetItem(); int menuID = 0; if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty) { menuID = int.Parse(Request["ID"].ToString()); } double _return = _cvDAL.InsertT_YecauQuangCao(_yc); if (Page.Request.Params["id"] == null) { action.Thaotac = "[Thêm mới yêu cầu phát hành]-->[mã yêu cầu:" + _return.ToString() + " ]"; System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + Global.RM.GetString("VALIDATE_ADDNEWS") + "');", true); actionDAL.InserT_Lichsu_Thaotac_Hethong(action); Clear(); BindCombo(); return; } if (Page.Request.Params["id"] != null) { action.Thaotac = "[Sửa nội dung yêu cầu phát hành]-->[Mã yêu cầu:" + Page.Request["id"].ToString() + " ]"; System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + Global.RM.GetString("UpdateSuccessfully") + "');", true); actionDAL.InserT_Lichsu_Thaotac_Hethong(action); Clear(); BindCombo(); return; } }