protected override void Render(HtmlTextWriter writer) { StringBuilder sb = new StringBuilder(); ClientScriptManager cs = this.Page.ClientScript; string _ID = Request["ID"]; string _CQ_ID = Request["CQ_ID"]; string _Ten = Request["Ten"]; string _q = Request["q"]; string _Loai_Ten = Request["Loai_Ten"]; string _Loai_ID = Request["Loai_ID"]; var _HomeUrl = Request["HomeUrl"]; switch (subAct) { case "get": #region Lấy danh sách if (string.IsNullOrEmpty(jgrsidx)) { jgrsidx = "ID"; } if (string.IsNullOrEmpty(jgrsord)) { jgrsord = "asc"; } RoleCollection ListGet = RoleDal.TreeByUsername(Security.Username, _q, _CQ_ID, "ROLE_" + jgrsidx + " " + jgrsord); List <jgridRow> ListRow = new List <jgridRow>(); foreach (Role item in ListGet) { ListRow.Add(new jgridRow(item.ID.ToString() , new string[] { item.ID.ToString(), item.Ten, item.Loai_Ten, item._CoQuan.Ten })); } jgrid grid = new jgrid("1", "1", ListGet.Count.ToString(), ListRow); sb.Append(JavaScriptConvert.SerializeObject(grid)); break; #endregion case "del": #region Xóa if (!string.IsNullOrEmpty(_ID)) { RoleDal.DeleteById(_ID); } break; #endregion case "edit": #region chỉnh sửa if (!string.IsNullOrEmpty(_ID)) { sb.Append("(" + JavaScriptConvert.SerializeObject(RoleDal.SelectById(Convert.ToInt32(_ID))) + ")"); } break; #endregion case "save": #region Lưu var ItemSave = new Role(); if (!string.IsNullOrEmpty(_ID)) { ItemSave = RoleDal.SelectById(Convert.ToInt32(_ID)); } ItemSave.Ten = _Ten; ItemSave.HomeUrl = _HomeUrl; ItemSave.CQ_ID = Convert.ToInt32(_CQ_ID); ItemSave.NgayCapNhat = DateTime.Now; ItemSave.Active = true; ItemSave.HeThong = true; if (!string.IsNullOrEmpty(_Loai_ID)) { ItemSave.Loai_ID = new Guid(_Loai_ID); } ItemSave.Loai_Ten = _Loai_Ten; if (!string.IsNullOrEmpty(_ID)) { ItemSave = RoleDal.Update(ItemSave); } else { ItemSave.NgayTao = DateTime.Now; ItemSave.NguoiTao = Security.Username; ItemSave.RowId = Guid.NewGuid(); ItemSave = RoleDal.Insert(ItemSave); } sb.Append("1"); break; #endregion case "getFunction": #region Lấy function theo role if (!string.IsNullOrEmpty(_ID)) { FunctionCollection ListFnByRole = FunctionDal.SelectAllFunctionByRole(_ID); if (ListFnByRole.Count > 0) { sb.Append(getTop(ListFnByRole)); } else { sb.Append("0"); } } break; #endregion case "updateFunction": #region Cập nhật thay đổi RoleFunctionDal.UpdateByRoleIdFunctionList(_ID, Request["UpdateList"], Security.Username); sb.Append("1"); break; #endregion case "getUserByRole": #region Lấy thành viên trong nhóm if (!string.IsNullOrEmpty(_ID)) { MemberCollection ListUserByRole = MemberDal.SelectByRole(_ID); if (ListUserByRole.Count > 0) { foreach (Member item in ListUserByRole) { sb.AppendFormat(@"<input type=""checkbox"" _username=""{0}"" {2} > <b>{0}</b> [ {1} ] <br/>" , item.Username, item.Ten, item.Khoa ? @"checked=""checked""" : ""); } } else { sb.Append("0"); } } break; #endregion case "updateUsers": #region Lưu thay đổi thành viên trong nhóm if (!string.IsNullOrEmpty(_ID)) { MemberRoleDal.UpdateUserListRole(Request["UpdateList"], _ID, Security.Username); sb.AppendFormat("1"); } break; #endregion default: #region nạp FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId); sb.Append(@"<div class=""mdl-head""> <span class=""mdl-head-searchPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-quanLyQuyen"" /> </span> <a class=""mdl-head-btn mdl-head-add"" id=""quanLyQuyenMdl-addBtn"" href=""javascript:quanLyQuyen.add();"">Thêm</a> <a class=""mdl-head-btn mdl-head-edit"" id=""quanLyQuyenMdl-editBtn"" href=""javascript:quanLyQuyen.edit();"">Sửa</a> <a class=""mdl-head-btn mdl-head-del"" id=""quanLyQuyenMdl-delBtn"" href=""javascript:quanLyQuyen.del();"">Xóa</a> <span class=""mdl-head-filterPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" _value="""" class=""mdl-head-filter mdl-head-filterQuanLyQuyenByCQID""/> </span> </div> <table id=""quanLyQuyenMdl-List"" class=""mdl-list""> </table> <div id=""quanLyQuyenMdl-Pager""></div> <div class=""sub-mdl quanLyQuyenMdl-subMdl""> <ul> <li> <a id=""quanLyQuyenMdl-functionmdl-subMdlBtn"" href=""#quanLyQuyenMdl-subMdl-mdl1"">Quyền</a> </li> <li> <a id=""quanLyQuyenMdl-usermdl-subMdlBtn"" href=""#quanLyQuyenMdl-subMdl-mdl2"">Người dùng thuộc nhóm</a> </li> </ul> <div id=""quanLyQuyenMdl-subMdl-mdl1""> <div id=""quanLyQuyenMdl-functionmdl-roleFnMdl""> </div> </div> <div id=""quanLyQuyenMdl-subMdl-mdl2""> <div id=""quanLyQuyenMdl-functionmdl-UserInRoleMdl""> </div> </div> </div> "); sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>" , cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.hethong.quanLyQuyen.JScript1.js") , "{quanLyQuyen.loadgrid();}"); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn)); break; #endregion } writer.Write(sb.ToString()); base.Render(writer); }
protected override void Render(HtmlTextWriter writer) { StringBuilder sb = new StringBuilder(); ClientScriptManager cs = this.Page.ClientScript; #region Tham số string _ID = Request["ID"]; string _CQ_ID = Request["CQ_ID"]; string _Username = Request["Username"]; string _Password = Request["Password"]; string _Pwd = Request["Pwd"]; string _Ten = Request["Ten"]; string _Khoa = Request["Khoa"]; string _Luong = Request["Luong"]; string _q = Request["q"]; string _Anh = Request["Anh"]; string _Loai = Request["Loai"]; string _ThuKy = Request["ThuKy"]; string _refUsername = Request["refUsername"]; string _Email = Request["Email"]; string _Captcha = Request["Captcha"]; string _Mobile = Request["Mobile"]; string _DiaChi = Request["DiaChi"]; string _MoTa = Request["MoTa"]; string _Loai_Ten = Request["Loai_Ten"]; string _CQ_Ma = Request["CQ_Ma"]; string TVDV_ID = Request["TVDV_ID"]; string _Lang = Request["Lang"]; #endregion //if (!Security.IsAuthenticated()) //{ // Response.End(); //} switch (subAct) { case "get": #region lấy danh sách if (string.IsNullOrEmpty(jgrsidx)) { jgrsidx = "ID"; } if (string.IsNullOrEmpty(jgrsord)) { jgrsord = "asc"; } Pager <Member> PagerGet = MemberDal.pagerAllChildByUsername("", false, "MEM_" + jgrsidx + " " + jgrsord, Security.Username, _CQ_ID, _q, Request["rows"]); List <jgridRow> ListRow = new List <jgridRow>(); foreach (Member item in PagerGet.List) { ListRow.Add(new jgridRow(item.ID.ToString(), new string[] { item.ID.ToString() , item.Ten , item._CoQuan.Ten , item.Loai_Ten , item.Email , item.Mobile , item.Username , item.Password.Length > 2 ? item.Password.Substring(0, item.Password.Length - 2) : "" , item.Active.ToString() , item.NguoiTao })); } jgrid grid = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, PagerGet.TotalPages.ToString(), PagerGet.Total.ToString(), ListRow); sb.Append(JavaScriptConvert.SerializeObject(grid)); break; #endregion case "getpid": #region lấy danh sách cho autocomplete Pager <Member> PagerGetPid = MemberDal.pagerAllChildByUsername("", true, null, string.IsNullOrEmpty(Security.Username) ? "sspa" : Security.Username, null, _q, "20"); sb.Append(JavaScriptConvert.SerializeObject(PagerGetPid.List)); break; #endregion case "GetLamDichVuList": #region lấy danh sách cho autocomplete var listLamDichVu = MemberDal.SelectLamDichVu(TVDV_ID, "sspa"); sb.Append(JavaScriptConvert.SerializeObject(listLamDichVu)); break; #endregion case "getpuse": #region lấy danh sách cho autocomplete Pager <Member> PagerGetPues = MemberDal.pagerAllByUsername("", true, null, Security.Username, null, _q, "20"); sb.Append(JavaScriptConvert.SerializeObject(PagerGetPues.List)); break; #endregion case "SelectByNodeAndWfId": #region lấy danh sách cho autocomplete string Username = Security.Username; //if (Request["WF_ID"] == "4" && string.IsNullOrEmpty(Request["NODE_ID"])) //{ // sb.Append(JavaScriptConvert.SerializeObject(MemberDal.SelectLanhDaoByCQMa("1"))); //} //else //{ // if (!string.IsNullOrEmpty(_CQ_ID)) // { // MemberCollection mem = MemberDal.SelectLanhDaoByCQMa(_CQ_ID); // foreach (Member m in mem) // { // Username = m.Username; // break; // } // } sb.Append(JavaScriptConvert.SerializeObject(MemberDal.SelectByNodeAndWfId(Request["NODE_ID"], Request["WF_ID"], _q, "20", Username))); //} break; #endregion case "del": #region xóa MemberDal.DeleteByIdList(Request["ID"]); break; #endregion case "edit": #region chỉnh sửa if (!string.IsNullOrEmpty(_ID)) { sb.Append("(" + JavaScriptConvert.SerializeObject(MemberDal.SelectById(Convert.ToInt32(_ID))) + ")"); } break; #endregion case "editX": #region editX if (!string.IsNullOrEmpty(_ID)) { sb.Append(MemberDal.SelectById(Convert.ToInt32(_ID)).Loai.ToString()); } break; #endregion case "save": #region lưu Member ItemSave = new Member(); if (string.IsNullOrEmpty(_Username)) { sb.Append("0"); break; } if (!string.IsNullOrEmpty(_ID)) { ItemSave = MemberDal.SelectById(Convert.ToInt32(_ID)); } else { if (MemberDal.ValidEmailUsername(_Email, _Username) != "-1" || MemberDal.ValidEmailUsername(_Email, _Username) != (string.IsNullOrEmpty(_ID) ? "-1" : _ID)) { sb.Append("0"); break; } } ItemSave.Luong = Convert.ToDouble(_Luong); ItemSave.Anh = _Anh; ItemSave.CQ_ID = Convert.ToInt32(_CQ_ID); ItemSave.DiaChi = string.Empty; ItemSave.Email = _Email; ItemSave.Ho = string.Empty; ItemSave.Khoa = Convert.ToBoolean(_Khoa); ItemSave.Loai = Convert.ToInt32("0"); ItemSave.Mobile = _Mobile; ItemSave.Mota = string.Empty; ItemSave.NgayCapNhat = DateTime.Now; ItemSave.NguoiTao = Security.Username; ItemSave.RefUsername = _refUsername; ItemSave.Ten = _Ten; ItemSave.Loai_Ten = _Loai_Ten; ItemSave.ThuKy = Convert.ToBoolean(_ThuKy); ItemSave.XacNhan = false; if (!string.IsNullOrEmpty(_ID)) { if (!string.IsNullOrEmpty(_Password)) { //ItemSave.Password = maHoa.EncryptString(_Password, _Username); ItemSave.Password = maHoa.MD5Encrypt(_Password); } ItemSave = MemberDal.Update(ItemSave); } else { ItemSave.NgayTao = DateTime.Now; //ItemSave.Password = maHoa.EncryptString(_Password, _Username); ItemSave.Password = maHoa.MD5Encrypt(_Password); ItemSave.RowId = Guid.NewGuid(); ItemSave.Username = _Username; ItemSave = MemberDal.Insert(ItemSave); } sb.Append("1"); break; #endregion case "sendmail": #region gửi email if (!string.IsNullOrEmpty(_Email)) { string[] _email = _Email.Split(new char[] { ',' }); sendEmailDelegate _send = new sendEmailDelegate(sendMail); //_send.BeginInvoke(_email, _Ten, _MoTa, null, null); sb.Append("1"); } else { sb.Append("0"); } break; #endregion case "getRoles": #region lấy quyền của thành viên if (!string.IsNullOrEmpty(_Username)) { sb.AppendFormat(getRoleByUsername(_Username)); } break; #endregion case "saveRoles": #region lưu quyền if (!string.IsNullOrEmpty(_Username)) { string roleList = Request["roleList"]; if (!string.IsNullOrEmpty(roleList)) { MemberRoleDal.UpdateRoleListUsername(roleList, _Username); } } break; #endregion case "SelectLanhDaoByCQID": #region lấy lãnh đạo theo cơ quan if (!string.IsNullOrEmpty(_CQ_ID)) { MemberCollection PG = MemberDal.SelectLanhDaoByCQID(_CQ_ID); sb.Append(JavaScriptConvert.SerializeObject(PG)); } break; #endregion case "SelectLanhDaoVanBanDi": #region lấy lãnh đạo theo cơ quan MemberCollection _SelectLanhDaoVanBanDi = MemberDal.SelectLanhDaoVanBanDi(); sb.Append(JavaScriptConvert.SerializeObject(_SelectLanhDaoVanBanDi)); break; #endregion case "SelectLanhDaoByMaCQ": #region tim lanh dao theo ma co quan MemberCollection _SelectLanhDaoByMaCoQuan = MemberDal.SelectLanhDaoByCQMa(_CQ_Ma); sb.Append(JavaScriptConvert.SerializeObject(_SelectLanhDaoByMaCoQuan)); break; #endregion case "ValidateEmail": #region tim lanh dao theo ma co quan if (!string.IsNullOrEmpty(_Email)) { if (MemberDal.ValidEmail(_Email)) { sb.Append("1"); } else { sb.Append("0"); } } break; #endregion case "ValidateCaptcha": #region tim lanh dao theo ma co quan if (!string.IsNullOrEmpty(_Captcha)) { if (Session["capcha"] != null) { if (Session["capcha"].ToString() == _Captcha) { sb.Append("1"); } else { sb.Append("0"); } } else { sb.Append("0"); } } else { sb.Append("0"); } break; #endregion case "cungDonVi": #region cungDonVi : Lấy thành viên cùng đơn vị sb.Append(JavaScriptConvert.SerializeObject(MemberDal.SelectCungDonVi(Security.Username))); break; #endregion case "dangKyCaNhan": #region dangKyCaNhan using (SqlConnection con = DAL.con()) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { CoQuan ItemCq = CoQuanDal.SelectByMa(tran, "RAOVAT"); //Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.EncryptString(_Pwd, _Email)); Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.MD5Encrypt(_Password)); MemberRole ItemMR = MemberRoleDal.InsertDangKyCaNhan(tran, ItemCq.ID, _Email); Security.Login(_Email, "true"); sb.Append("1"); tran.Commit(); } catch (Exception ex) { tran.Rollback(); Security.LogOut(); sb.Append(ex.ToString()); } finally { con.Close(); } } break; #endregion case "dangKyGh": #region dangKyGh using (SqlConnection con = DAL.con()) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { CoQuan ItemCqP = CoQuanDal.SelectByMa(tran, "GIANHANG"); CoQuan ItemCq = CoQuanDal.Insert(tran, ItemCqP.ID, _Ten, _Email); //Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.EncryptString(_Pwd, _Email)); Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.MD5Encrypt(_Pwd)); MemberRoleDal.InsertDangKyGianHang(tran, ItemCq.ID, _Email, _Ten, _Lang); //LienHe itemLH = LienHeDal.InsertLH(tran, ItemMe.RowId.ToString()); Security.Login(_Email, "true"); sb.Append("1"); tran.Commit(); } catch (Exception ex) { tran.Rollback(); Security.LogOut(); sb.Append(ex.ToString()); } finally { con.Close(); } } break; #endregion case "scpt": #region Nạp js sb.AppendFormat(@"{0}" , cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.hethong.thanhvien.JScript1.js")); break; #endregion default: //Session["capcha"] #region nạp FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId); sb.Append(@"<div class=""mdl-head""> <span class=""mdl-head-searchPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-thanhvien"" /> </span> <a class=""mdl-head-btn mdl-head-add"" id=""thanhvienmdl-addBtn"" href=""javascript:thanhvien.add();"">Thêm</a> <a class=""mdl-head-btn mdl-head-edit"" id=""thanhvienmdl-editBtn"" href=""javascript:thanhvien.edit();"">Sửa</a> <a class=""mdl-head-btn mdl-head-del"" id=""thanhvienmdl-delBtn"" href=""javascript:thanhvien.del();"">Xóa</a> <a class=""mdl-head-btn mdl-head-sendmail"" id=""thanhvienmdl-emailBtn"" href=""javascript:thanhvien.sendmail();"">Email</a> <a class=""mdl-head-btn mdl-head-resetPwd"" id=""thanhvienmdl-reSendPwdBtn"" href=""javascript:thanhvien.resendPwd();"">Cấp mật khẩu</a> <span class=""mdl-head-filterPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" _value="""" class=""mdl-head-filter mdl-head-filterThanhVienByCQID""/> </span> </div> <table id=""thanhvienmdl-List"" class=""mdl-list""> </table> <div id=""thanhvienmdl-Pager""></div><div class=""sub-mdl""><ul><li><a id=""thanhvienmdl-rolemdl-subMdlBtn"" href=""#mdl-1"">Quyền</a></li></ul><div id=""mdl-1""> <div class=""sub-mdl-list"" id=""thanhvienmdl-rolemdl-mdl""></div> </div></div>"); sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>" , cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.hethong.thanhvien.JScript1.js") , "{thanhvien.loadgrid();}"); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn)); break; #endregion } writer.Write(sb.ToString()); base.Render(writer); }