/// <summary> /// 根据账号密码获取信息 /// </summary> /// <param name="loginname">账号</param> /// <param name="pwd">密码</param> /// <returns></returns> public static M_Users GetM_UserByUserName(string loginname, string pwd, string operateip) { pwd = ProBusiness.Encrypt.GetEncryptPwd(pwd, loginname); DataTable dt = new M_UsersDAL().GetM_UserByUserName(loginname, pwd); M_Users model = null; if (dt.Rows.Count > 0) { model = new M_Users(); model.FillData(dt.Rows[0]); if (!string.IsNullOrEmpty(model.RoleID)) { model.Role = ManageSystemBusiness.GetRoleByID(model.RoleID); } //权限 if (model.Role != null && model.Role.IsDefault == 1) { model.Menus = CommonBusiness.ClientMenus; } else if (model.IsAdmin == 1) { model.Menus = CommonBusiness.ClientMenus; } else { model.Menus = model.Role.Menus; } } return(model); }
public ActionResult Login() { if (CurrentUser != null) { return(Redirect("/Home/Index")); } HttpCookie cook = Request.Cookies["cp"]; if (cook != null) { if (cook["status"] == "1") { string operateip = OperateIP; int result; M_Users model = ProBusiness.M_UsersBusiness.GetM_UserByProUserName(cook["username"], cook["pwd"], operateip, out result); if (model != null) { model.LastLoginIP = OperateIP; Session["Manager"] = model; return(Redirect("/Home/Index")); } } } return(View()); }
public ActionResult UploadEmployeePhoto() { #region Save to Server bool isSuccess = false; string serverMessage = string.Empty; var fileOne = Request.Files[0] as HttpPostedFileBase; string uploadPath = Server.MapPath(@"~/PictureResources/UsersPhoto/"); string newFileOne = Path.Combine(uploadPath, fileOne.FileName); //fileOne.SaveAs(newFileOne); //fileOne.SaveAs(HttpContext.Server.MapPath("~/PictureResources/UsersPhoto/") + Path.GetFileName(fileOne.FileName)); fileOne.SaveAs(HttpContext.Server.MapPath("~/PictureResources/UsersPhoto/") + Path.GetFileName(Regex.Replace(fileOne.FileName, @"\s+", ""))); #endregion #region ImageSet M_Users pack = (from c in db.M_Users where c.UserName == user.UserName select c).FirstOrDefault(); string[] data = fileOne.FileName.Split('\\'); //pack.UserPhoto = data[data.Length - 1];//fileOne.FileName; pack.UserPhoto = Regex.Replace(data[data.Length - 1], @"\s+", "");//fileOne.FileName; db.Entry(pack).State = EntityState.Modified; db.SaveChanges(); #endregion M_Users check = (from c in db.M_Users where c.UserName == user.UserName select c).FirstOrDefault(); System.Web.HttpContext.Current.Session["user"] = check; return(Json(new { wew = "" }, JsonRequestBehavior.AllowGet)); }
public M_Users _getUserInfo(string UId) { try { M_Users s = new M_Users(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getUserInfoResult> ckuser = datacontext._getUserInfo(UId); foreach (_getUserInfoResult result in ckuser) { s.Designation = result.Designation; s.UserName = result.PersonName; s.UserId = result.UserID; s.IsActive = result.IsActive; s.Email = result.Email; s.UserGroup = result.UserGroupID; } } return(s); } catch (Exception ex) { // Console.WriteLine(ex.Message.ToString()); ErrorLog.LogError(ex); return(null); } }
public ActionResult GetPageAccess(string UserName) { M_Users userchosen = (from c in db.M_Users where c.UserName == UserName select c).FirstOrDefault(); List <M_SP_PageandAccess_Result> MasterPageList = db.M_SP_PageandAccess(UserName, "Master").ToList(); List <M_SP_PageandAccess_Result> ApplicationFormPageList = db.M_SP_PageandAccess(UserName, "Application Form").ToList(); List <M_SP_PageandAccess_Result> SummaryPageList = db.M_SP_PageandAccess(UserName, "Reports").ToList(); List <M_SP_PageandAccess_Result> ForeCastList = db.M_SP_PageandAccess(UserName, "ForeCast").ToList(); if (userchosen.Section == null || userchosen.Section == "") { ApplicationFormPageList = ApplicationFormPageList.Where(x => x.PageIndex != "OT" && x.PageIndex != "ChangeSchedule" && x.PageIndex != "DTR").ToList(); } int MasterGoodcount = MasterPageList.Where(x => x.AccessType == true).Count(); int AFGoodcount = ApplicationFormPageList.Where(x => x.AccessType == true).Count(); int REGoodcount = SummaryPageList.Where(x => x.AccessType == true).Count(); int FCGoodcount = ForeCastList.Where(x => x.AccessType == true).Count(); return(Json(new { MasterPageList = MasterPageList, ApplicationFormPageList = ApplicationFormPageList, SummaryPageList = SummaryPageList, ForeCastList = ForeCastList, GoodCount = MasterGoodcount + AFGoodcount + REGoodcount + FCGoodcount }, JsonRequestBehavior.AllowGet)); }
public string setNewUser(M_Users Model, string Createdby) { try { bool Uname = checkUserName(Model.UserId); if (Uname) { return("IN"); } string pass = Encrypt_Decrypt.Encrypt(Model.Password_, Password); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; datacontext._setNewUser(Model.UserId, Model.UserGroup, Model.UserName, pass, Model.Designation, Model.Email, Createdby); datacontext.SubmitChanges(); return("Success"); } } catch (Exception ex) { // Console.WriteLine(ex.Message.ToString()); ErrorLog.LogError(ex); return("Error"); } }
public List <M_Users> getBackEndUsers() { try { List <M_Users> lstUser = new List <M_Users>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getBackendSystemUsersResult> lst = datacontext._getBackendSystemUsers(); foreach (_getBackendSystemUsersResult result in lst) { M_Users usr = new M_Users(); usr.UserId = result.UserID; usr.UserGroup = result.UserGroupID; usr.UserName = result.PersonName; usr.IsActive = result.IsActive; usr.Email = result.Email; usr.Designation = result.Designation; lstUser.Add(usr); } } return(lstUser); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
/// <summary> /// 保存会员信息 /// </summary> /// <param name="bHeight"></param> /// <param name="bWeight"></param> /// <param name="jobs"></param> /// <param name="bPay"></param> /// <param name="isMarry"></param> /// <param name="myContent"></param> /// <param name="name"></param> /// <param name="talkTo"></param> /// <param name="age"></param> /// <param name="myservice"></param> /// <returns></returns> public JsonResult SaveUserInfo(string bHeight, string bWeight, string jobs, string bPay, int isMarry, string myContent, string name, string talkTo, int age, string myservice) { M_Users users = CurrentUser; users.BHeight = bHeight; users.BWeight = bWeight; users.Jobs = jobs; users.TalkTo = talkTo; users.BPay = bPay; users.IsMarry = isMarry; users.MyService = myservice; users.Age = age; users.Name = name; users.IsMarry = isMarry; users.MyContent = myContent; var result = M_UsersBusiness.UpdateM_UserBase(CurrentUser.UserID, bHeight, bWeight, jobs, bPay, isMarry, myContent, name, talkTo, age, myservice); if (result) { Session["Manage"] = users; } JsonDictionary.Add("result", result); return(new JsonResult { Data = JsonDictionary, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
/// <summary> /// 获取订单基本信息 /// </summary> public static ClientOrder GetClientOrderInfo(string orderID) { DataTable dt = ClientOrderDAL.BaseProvider.GetClientOrderInfo(orderID); ClientOrder model = new ClientOrder(); if (dt.Rows.Count == 1) { DataRow row = dt.Rows[0]; model.FillData(row); model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID); if (string.IsNullOrEmpty(model.CreateUser.Name)) { M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID); if (mUser != null && !string.IsNullOrEmpty(mUser.Name)) { model.CreateUser.Name = mUser.Name; } } if (!string.IsNullOrEmpty(model.CheckUserID)) { model.CheckUser = OrganizationBusiness.GetUserByUserID(model.CheckUserID, model.ClientID); if (string.IsNullOrEmpty(model.CheckUser.Name)) { M_Users mUser = M_UsersBusiness.GetUserDetail(model.CheckUserID); if (mUser != null && !string.IsNullOrEmpty(mUser.Name)) { model.CheckUser.Name = mUser.Name; } } } } return(model); }
public static int CreateBettOrderList(List <LotteryBettAuto> models, M_Users user, string ip, int isStart, ref string errmsg) { int k = 0; string msg = ""; models.ForEach(x => { string errormsg = ""; string orderCode = Getordercode() + user.AutoID; x.TypeName = x.TypeName.Replace("大小单双", "").Replace("趣味型", "趣味"); if (x.CPCode.ToLower() != "bjsc") { x.TypeName = x.TypeName.Replace("龙虎斗", ""); } var result = CreateBettOrder(orderCode, x.StartNum, x.Type, x.TypeName, x.CPCode, x.CPName, x.Content.Replace("\"", ""), x.Num, x.PayFee, user.UserID, x.PMuch, x.RPoint, ip, isStart, x.BettNum, x.BMuch, x.TotalFee, x.Profits, x.WinFee, x.BettType, x.JsonContent, x.ModelName, x.MType, ref errormsg); if (!result) { //msg += x.Content + " " + errormsg + "/n"; msg += errormsg; } else { k++; } }); errmsg = msg; return(k); }
public static List <M_Users> GetImgList(string userid, int sex, int pageIndex, int pageSize, ref int totalCount, ref int pageCount) { string whereSql = " a.Status<>9 and b.ImgCount>0"; if (sex > -1) { whereSql += " and a.Sex=" + sex; } if (!string.IsNullOrEmpty(userid)) { whereSql += " and a.UserID='" + userid + "' "; } string clumstr = "a.userID,a.Avatar,a.Name,a.Age,a.LoginName,a.MyService,a.Province,a.City,a.District,a.CreateTime,a.Status,a.Sex,a.IsMarry,a.Education," + "a.BHeight,a.Levelid,a.BWeight,a.MyContent,a.MyCharacter,a.TalkTo,a.BPay,a.Account,b.ImgCount,b.IsLogin,b.RecommendCount,b.SeeCount"; DataTable dt = CommonBusiness.GetPagerData("M_Users a join userReport b on a.Userid=b.Userid ", clumstr, whereSql, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount); List <M_Users> list = new List <M_Users>(); foreach (DataRow item in dt.Rows) { M_Users model = new M_Users(); model.FillData(item); list.Add(model); } return(list); }
/// <summary> /// 新增或修改用户信息 /// </summary> public static int CreateM_User(M_Users musers) { int bl = M_UsersDAL.BaseProvider.CreateM_User(musers.UserName, musers.Password, musers.Email, musers.IsAdmin, musers.RoleID, musers.Email, musers.Mobile, musers.Salt, musers.Avatar, musers.AdminGid); return(bl); }
public static List <M_Users> GetUsers(string keyWords, string roleID, int pageSize, int pageIndex, ref int totalCount, ref int pageCount) { string whereSql = " Status<>9"; if (!string.IsNullOrEmpty(keyWords)) { whereSql += " and ( Name like '%" + keyWords + "%' or MobilePhone like '%" + keyWords + "%' or Email like '%" + keyWords + "%')"; } if (!string.IsNullOrEmpty(roleID)) { whereSql += " and RoleID='" + roleID + "'"; } DataTable dt = CommonBusiness.GetPagerData("M_Users", "*", whereSql, "AutoID", pageSize, pageIndex, out totalCount, out pageCount); List <M_Users> list = new List <M_Users>(); M_Users model; foreach (DataRow item in dt.Rows) { model = new M_Users(); model.FillData(item); if (!string.IsNullOrEmpty(model.RoleID)) { model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID); } list.Add(model); } return(list); }
public static List <M_Users> GetUsers(int pageSize, int pageIndex, ref int totalCount, ref int pageCount, int type = 2, int status = -1, string keyWords = "", string colmonasc = "", bool isasc = false) { string whereSql = " a.isfreeze<>9"; if (type > -1) { whereSql += " and a.admingid=" + type + " "; } if (status > -1) { whereSql += " and a.isfreeze=" + status; } if (!string.IsNullOrEmpty(keyWords)) { whereSql += " and (a.UserName like '%" + keyWords + "%' or a.mobile like'%" + keyWords + "%' or a.email like'%" + keyWords + "%') "; } string cstr = @" a.*,convert(varchar(25),b.registertime,120) registertime,convert(varchar(25),b.lastvisittime,120) lastvisittime "; DataTable dt = CommonBusiness.GetPagerData("Owzx_Users a join owzx_userdetails b on a.uid=b.uid ", cstr, whereSql, "a.Uid", colmonasc, pageSize, pageIndex, out totalCount, out pageCount, isasc); List <M_Users> list = new List <M_Users>(); M_Users model; foreach (DataRow item in dt.Rows) { model = new M_Users(); model.FillData(item); if (!string.IsNullOrEmpty(model.RoleID)) { model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID); } list.Add(model); } return(list); }
public JsonResult UserRegister(string userName, string pwd, string id) { string Errmsg = ""; M_Users user = new M_Users() { Type = 0, SourceType = 0, UserName = userName, LoginName = userName, LoginPwd = pwd, Description = "自动注册", RoleID = "48eb0491-d92c-4664-ab27-37320ac7de38" //dd87ca0a-b425-4e1e-b7ec-7a1e02dad0f8 代理角色 //48eb0491-d92c-4664-ab27-37320ac7de38 会员ID }; var result = M_UsersBusiness.CreateM_User(user, ref Errmsg); if (string.IsNullOrEmpty(Errmsg)) { return(UserLogin(userName, pwd)); } else { JsonDictionary.Add("result", result); JsonDictionary.Add("Errmsg", Errmsg); return(new JsonResult { Data = JsonDictionary, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public void RefreshPageAccess(string UserName, string Section) { #region For Page Access M_Users userchosen = (from c in db.M_Users where c.UserName == UserName select c).FirstOrDefault(); //if (userchosen.Section == "Production Engineering") //{ // MasterPageList = db.M_SP_PageandAccess(UserName, "Master").Where(x => x.AccessType == true).ToList(); ; //} //else //{ // MasterPageList = db.M_SP_PageandAccess(UserName, "Master").Where(x => x.PageIndex != "CostCenter" && x.PageIndex != "FormatorTemplate" && x.PageIndex != "Section" && x.AccessType == true).ToList(); //} List <M_SP_PageandAccess_Result> MasterPageList = db.M_SP_PageandAccess(UserName, "Master").Where(x => x.AccessType == true).ToList(); List <M_SP_PageandAccess_Result> ApplicationFormPageList = db.M_SP_PageandAccess(UserName, "Application Form").Where(x => x.AccessType == true).ToList(); List <M_SP_PageandAccess_Result> SummaryPageList = db.M_SP_PageandAccess(UserName, "Reports").Where(x => x.AccessType == true).ToList(); List <M_SP_PageandAccess_Result> ForeCastList = db.M_SP_PageandAccess(UserName, "ForeCast").Where(x => x.AccessType == true).ToList(); #region FORCE REMOVE Form to super user if (Section == null || Section == "") { ApplicationFormPageList = ApplicationFormPageList.Where(x => x.PageIndex != "OT" && x.PageIndex != "ChangeSchedule" && x.PageIndex != "DTR").ToList(); } #endregion System.Web.HttpContext.Current.Session["MasterPageList"] = MasterPageList; System.Web.HttpContext.Current.Session["ApplicationFormPageList"] = ApplicationFormPageList; System.Web.HttpContext.Current.Session["SummaryPageList"] = SummaryPageList; System.Web.HttpContext.Current.Session["ForeCastList"] = ForeCastList; #endregion }
public ActionResult Login() { if (CurrentUser != null) { return(Redirect("/User/UserInfo")); } HttpCookie cook = Request.Cookies["zpy"]; if (cook != null) { if (cook["status"] == "1") { string operateip = OperateIP; int result; M_Users model = PCDDBusiness.M_UsersBusiness.GetM_UserByProUserName(cook["username"], cook["pwd"], operateip, out result); if (model != null) { if (DateTime.Now.CompareTo(model.AuthorETime) < 1) { model.AuthorType = 0; } Session["Manager"] = model; return(Redirect("/User/UserInfo")); } } } return(View()); }
public ActionResult CreateUser(M_Users data) { try { data.CreateID = user.UserName; data.CreateDate = DateTime.Now; data.UpdateID = user.UserName; data.UpdateDate = DateTime.Now; data.IsDeleted = false; M_Users checker = (from c in db.M_Users where c.UserName == data.UserName && c.IsDeleted == false select c).FirstOrDefault(); if (checker == null) { db.M_Users.Add(data); db.SaveChanges(); return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet)); } }
public static List <M_Users> GetUsers(int pageSize, int pageIndex, ref int totalCount, ref int pageCount, int type = -1, int status = -1, string keyWords = "", string colmonasc = "", bool isasc = false) { string whereSql = " a.Status<>9"; if (type > -1) { whereSql += " and a.type=" + type + " "; } if (status > -1) { whereSql += " and a.Status=" + status; } if (!string.IsNullOrEmpty(keyWords)) { whereSql += " and (a.UserName like '%" + keyWords + "%' or a.LoginName like'%" + keyWords + "%') "; } string cstr = @" a.* "; DataTable dt = CommonBusiness.GetPagerData("M_Users a ", cstr, whereSql, "a.AutoID", colmonasc, pageSize, pageIndex, out totalCount, out pageCount, isasc); List <M_Users> list = new List <M_Users>(); M_Users model; foreach (DataRow item in dt.Rows) { model = new M_Users(); model.FillData(item); if (!string.IsNullOrEmpty(model.RoleID)) { model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID); } list.Add(model); } return(list); }
public static M_Users GetNewUserInfo(Grid userInfoGrid, Grid workTimeInfoGrid) { var user = new M_Users { P_Names = new List <M_Names> { new M_Names { NameFirst = ((TextBox)userInfoGrid.FindName("TB_UserFN")).Text, NameLast = ((TextBox)userInfoGrid.FindName("TB_UserSN")).Text, NameThird = ((TextBox)userInfoGrid.FindName("TB_UserTN")).Text } }, Address = ((TextBox)userInfoGrid.FindName("TB_UsesrAddr")).Text, D_Birth = ((DateTimePicker)userInfoGrid.FindName("DP_UserBithday")).SelectedDate, HourRate = Convert.ToDouble(((TextBox)workTimeInfoGrid.FindName("TB_HourRate")).Text), OvertimeRate = Convert.ToDouble(((TextBox)workTimeInfoGrid.FindName("TB_OverTimerate")).Text), IsAdmin = ((CheckBox)userInfoGrid.FindName("CB_IsAdmin")).IsChecked, IsDirector = ((CheckBox)userInfoGrid.FindName("CB_IsDirecor")).IsChecked, IsAccountant = ((CheckBox)userInfoGrid.FindName("CB_IsAccountant")).IsChecked, IsUser = true, P_Phones = GetNewPhones((TextBox)userInfoGrid.FindName("PhoneNumber1"), (TextBox)userInfoGrid.FindName("PhoneNumber2"), (TextBox)userInfoGrid.FindName("PhoneNumber3"), (TextBox)userInfoGrid.FindName("TB_UserPhone")) }; return(user); }
public static string GetPhotoPath(M_Users user, bool isImageExists, string img) { if (!isImageExists) { return(null); } if (string.IsNullOrEmpty(img)) { return(null); } var imageFile = new FileInfo(img); var imageName = string.Empty; imageName = string.Format("{0}_{1}_{2}.{3}", user.ID, user.P_Names.FirstOrDefault().NameFirst.Replace(" ", string.Empty), user.P_Names.FirstOrDefault().NameLast.Replace(" ", string.Empty), imageFile.ToString().Split('.').Last() ); var dir = new DirectoryInfo(Singelton.PathToPhoto); if (!dir.Exists) { dir.Create(); } var source = img; var dest = Path.Combine(dir.FullName, imageName); //File.Delete(dest); File.Copy(img, dest, true); //imageFile.CopyTo(Path.Combine(dir.FullName, imageName), true); return(imageName); }
public ActionResult Modify(M_Users User) { object result = ""; try { B_Users bUser = new B_Users(); var oldUser = bUser.GetUsers(User.Id); if (oldUser.ImageName.ToLower() != "default.jpg" && oldUser.ImageName.ToLower() != User.ImageName) { System.IO.File.Delete(Server.MapPath("~/Areas/Admin/Images/Profile") + "/" + oldUser.ImageName); } bUser.Edit(User); result = "Success"; } catch (Exception ex) { M_SystemLog exx = new M_SystemLog(E_SystemType.SHAHRDARI_WEB_APPLICATION, E_LogType.ERROR, ex); result = "Error"; if (ex.Source == E_LogType.SYSTEM_ERROR.ToString()) { exx.LogType = E_LogType.SYSTEM_ERROR; result = exx; } L_Log.SubmitLog(exx); } return(Json(result)); }
public ActionResult Login1() { //if (Session["IsLogin"] == null || Session["IsLogin"].ToString() != CommonBusiness.GetAppSet().Where(x => x.KName == "Login").FirstOrDefault().KValue) //{ // Session.RemoveAll(); // return Redirect("/Home/Login"); //} if (CurrentUser != null) { return(Redirect("/Home/Index")); } HttpCookie cook = Request.Cookies["cp"]; if (cook != null) { if (cook["status"] == "1") { string operateip = OperateIP; int result; M_Users model = ProBusiness.M_UsersBusiness.GetM_UserByProUserName(cook["username"], cook["pwd"], operateip, out result); if (model != null) { model.LastLoginIP = OperateIP; Session["Manager"] = model; Session["KFUrl"] = CommonBusiness.KFUrl; M_UsersBusiness.UpdLine(model.UserID, 1); return(Redirect("/Home/Index")); } } } return(View()); }
void run(int Id) { RfidContext db = new RfidContext(); M_Users user = new M_Users(); user = db.C_Users.Where(z => z.ID == Id).Single(); List <M_Rfids> prfids = new List <M_Rfids>(); prfids = user.P_Rfids.ToList(); var rfideCode = prfids.Where(x => x.IsArhive == false).Single(); RFIDCodeTags.Content = rfideCode.RfidID.ToString(); var queryAllCustomers = from cust in db.C_Rfids where cust.IsArhive == true && cust.P_Users.ID == Id select new { cust.Date, cust.RfidID, cust.Comment }; List <M_Rfids> queryAllCustomers1 = db.C_Rfids.Where(x => x.IsArhive == true && x.P_Users.ID == Id).ToList(); var ListQueryAllCustomers = queryAllCustomers.ToList(); LAadded.Content = user.P_Rfids.ToList()[0].Date.ToShortDateString(); GridRegistryChangesRFIDtags.ItemsSource = queryAllCustomers.ToList(); dynamic sdsdd = GridRegistryChangesRFIDtags.Items.CurrentItem; dynamic sdsdd1 = GridRegistryChangesRFIDtags.Items; if (GridRegistryChangesRFIDtags.Columns.Count > 0) { this.GridRegistryChangesRFIDtags.Columns[0].ClipboardContentBinding.StringFormat = "dd.MM.yyyy"; } GridRegistryChangesRFIDtags.Items.Refresh(); }
public JsonResult UserRegister2(string entity) { M_Users users = JsonConvert.DeserializeObject <M_Users>(entity); users.OfficePhone = ""; users.Avatar = ""; users.CreateUserID = ""; users.IsAdmin = 0; users.RoleID = ""; users.Description = ""; users.UserID = ((M_Users)Session["PartManage"]).UserID; var result = PCDDBusiness.M_UsersBusiness.UpdateM_UserBase(users); if (result) { var outresult = 0; PCDDEntity.Manage.M_Users model = PCDDBusiness.M_UsersBusiness.GetUserDetail(((M_Users)Session["PartManage"]).UserID); if (model != null) { CurrentUser = model; Session["Manager"] = model; } } JsonDictionary.Add("result", result); return(new JsonResult { Data = JsonDictionary, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public void SetInfoAboutSelectedUser(int?selectedId = null, M_Users selectedUser = null) { _selectedId = selectedId; _selectedUser = selectedUser; DP_SigleDate.Culture = App.Language; DP_StarDate.Culture = App.Language; DP_EndDate.Culture = App.Language; }
public static List <M_Users> GetUsers(int sex, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string address = "", string age = "", int sourcetype = 0, int status = -1, string keyWords = "") { string whereSql = " a.Status<>9"; if (sex > -1) { whereSql += " and a.Sex=" + sex; } if (status > -1) { whereSql += " and a.Status=" + status; } if (!string.IsNullOrEmpty(keyWords)) { whereSql += " and (a.Name like '%" + keyWords + "%' or a.LoginName like'%" + keyWords + "%') "; } if (sourcetype > -1) { whereSql += " and a.sourcetype=" + sourcetype; } if (!string.IsNullOrEmpty(address)) { string[] strArr = address.Split(','); for (int i = 0; i < strArr.Length; i++) { whereSql += (i == 0 ? " and a. province='" : i == 1 ? " and a.City='" : i == 2 ? " and a.District='" : "") + strArr[i] + "'"; } } if (!string.IsNullOrEmpty(age)) { string[] strArr = age.Split('~'); for (int i = 0; i < strArr.Length; i++) { whereSql += (i == 0? " and a.Age>=": " and a.Age<=") + strArr[i]; } } string cstr = @"a.AuthorBTime,a.AuthorETime,a.AuthorType,a.userID,a.Avatar,a.Name,a.LoginName,a.Age,a.MyService,a.Province,a.City,a.District,a.CreateTime,a.Status,a.Sex,a.IsMarry,a.Education,a.ROleID, a.BHeight,a.Levelid,a.BWeight,a.MyContent,a.MyCharacter,a.BPay,a.Account,a.TalkTo,a.Description"; DataTable dt = CommonBusiness.GetPagerData("M_Users a", cstr, whereSql, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount); List <M_Users> list = new List <M_Users>(); M_Users model; foreach (DataRow item in dt.Rows) { model = new M_Users(); model.FillData(item); if (!string.IsNullOrEmpty(model.RoleID)) { model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID); } list.Add(model); } return(list); }
public static void UpdateInOutTimes(Grid workTimeInfoGrid, M_Users user) { var newTimes = GetInOutValidTimes(workTimeInfoGrid); user.P_InOutValidTimes.Start = newTimes.Start; user.P_InOutValidTimes.End = newTimes.End; user.P_InOutValidTimes.Valid = newTimes.Valid; user.P_InOutValidTimes.Dinner = newTimes.Dinner; }
/// <summary> /// 新增或修改用户信息 /// </summary> public static string CreateM_User(M_Users musers, ref string errormsg) { string userid = Guid.NewGuid().ToString(); musers.LoginPwd = ProBusiness.Encrypt.GetEncryptPwd(musers.LoginPwd, musers.LoginName); bool bl = M_UsersDAL.BaseProvider.CreateM_User(userid, musers.LoginName, musers.LoginPwd, musers.UserName, musers.SourceType, musers.Type, musers.RoleID, out errormsg, musers.Description); return(bl ? userid : ""); }
/// <summary> /// 获取客户订单账目列表 /// </summary> public static List <ClientOrderAccount> GetClientOrderAccounts(string keyWords, string orderID, string clientID, int payType, int status, int type, int pageSize, int pageIndex, ref int totalCount, ref int pageCount) { string sqlWhere = "a.Status<>9"; if (!string.IsNullOrEmpty(keyWords)) { sqlWhere += " and ( a.OrderID like '%" + keyWords + "%' or a.ClientID like '%" + keyWords + "%' )"; } if (!string.IsNullOrEmpty(orderID)) { sqlWhere += " and ( a.OrderID ='" + orderID + "' )"; } if (!string.IsNullOrEmpty(clientID)) { sqlWhere += " and ( a.ClientID ='" + clientID + "' )"; } if (payType > 0) { sqlWhere += " and ( a.PayType ='" + payType + "' )"; } if (type > 0) { sqlWhere += " and ( a.Type ='" + type + "' )"; } if (status > 0) { sqlWhere += " and ( a.Status ='" + status + "' )"; } string sqlColumn = @" * "; DataTable dt = CommonBusiness.GetPagerData("ClientOrderAccount a", sqlColumn, sqlWhere, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount); List <ClientOrderAccount> list = new List <ClientOrderAccount>(); ClientOrderAccount model; foreach (DataRow item in dt.Rows) { model = new ClientOrderAccount(); model.FillData(item); if (!string.IsNullOrEmpty(model.CreateUserID)) { model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID); if (string.IsNullOrEmpty(model.CreateUser.Name)) { M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID); model.CreateUser.Name = mUser != null ? mUser.Name : ""; model.CreateUser.UserID = model.CreateUserID; } } if (!string.IsNullOrEmpty(model.CheckUserID)) { model.CheckerUser = M_UsersBusiness.GetUserDetail(model.CheckUserID); } list.Add(model); } return(list); }
/// <summary> /// 根据账号密码获取信息(登录) /// </summary> /// <param name="loginname">账号</param> /// <param name="pwd">密码</param> /// <returns></returns> public static M_Users GetM_UserByUserName(string loginname, string pwd, string operateip) { pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname); DataTable dt = new M_UsersDAL().GetM_UserByUserName(loginname, pwd); M_Users model = null; if (dt.Rows.Count > 0) { model = new M_Users(); model.FillData(dt.Rows[0]); } //记录登录日志 LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Manage, operateip, "", "", ""); return model; }
/// <summary> /// 根据账号密码获取信息(登录) /// </summary> /// <param name="loginname"></param> /// <param name="pwd"></param> /// <param name="operateip"></param> /// <param name="result"></param> /// <returns></returns> public static M_Users GetM_UserByProUserName(string loginname, string pwd, string operateip, out int result) { pwd = CloudSalesTool.Encrypt.GetEncryptPwd(pwd, loginname); DataSet ds = new M_UsersDAL().GetM_UserByProUserName(loginname, pwd, out result); M_Users model = null; if (ds.Tables.Contains("M_User") && ds.Tables["M_User"].Rows.Count > 0) { model = new M_Users(); model.FillData(ds.Tables["M_User"].Rows[0]); if (!string.IsNullOrEmpty(model.RoleID)) model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID); //权限 if (model.Role != null && model.Role.IsDefault == 1) { model.Menus = CommonBusiness.ManageMenus; } else if (model.IsAdmin == 1) { model.Menus = CommonBusiness.ManageMenus; } else { model.Menus = new List<Menu>(); foreach (DataRow dr in ds.Tables["Permission"].Rows) { Menu menu = new Menu(); menu.FillData(dr); model.Menus.Add(menu); } } } //记录登录日志 LogBusiness.AddLoginLog(loginname, model != null, CloudSalesEnum.EnumSystemType.Manage, operateip, "", "", ""); return model; }
/// <summary> /// 新增或修改用户信息 /// </summary> public string CreateM_User(M_Users musers) { string userid = Guid.NewGuid().ToString(); musers.LoginPWD = CloudSalesTool.Encrypt.GetEncryptPwd(musers.LoginPWD, musers.LoginName); bool bl = M_UsersDAL.BaseProvider.CreateM_User(userid, musers.LoginName, musers.LoginPWD, musers.Name, musers.IsAdmin, musers.RoleID, musers.Email, musers.MobilePhone, musers.OfficePhone, musers.Jobs, musers.Avatar, musers.Description, musers.CreateUserID); if (bl) { return userid; } return ""; }
public static List<M_Users> GetUsers(string keyWords, string roleID, int pageSize, int pageIndex, ref int totalCount, ref int pageCount) { string whereSql = " Status<>9"; if (!string.IsNullOrEmpty(keyWords)) whereSql += " and ( Name like '%" + keyWords + "%' or MobilePhone like '%" + keyWords + "%' or Email like '%" + keyWords + "%')"; if (!string.IsNullOrEmpty(roleID)) whereSql += " and RoleID='" + roleID + "'"; DataTable dt = CommonBusiness.GetPagerData("M_Users", "*", whereSql, "AutoID", pageSize, pageIndex, out totalCount, out pageCount); List<M_Users> list = new List<M_Users>(); M_Users model; foreach (DataRow item in dt.Rows) { model = new M_Users(); model.FillData(item); if (!string.IsNullOrEmpty(model.RoleID)) model.Role = ManageSystemBusiness.GetRoleByIDCache(model.RoleID); list.Add(model); } return list; }
public static M_Users GetUserDetail(string userID) { DataTable dt = M_UsersDAL.BaseProvider.GetUserDetail(userID); M_Users model = null; if (dt.Rows.Count == 1) { model = new M_Users(); model.FillData(dt.Rows[0]); } return model; }