protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { base.CheckAdminPower("ReadUser", PowerCheckType.Single); //this.Sex.DataSource = EnumHelper.ReadEnumList<SexType>(); //this.Sex.DataValueField = "Value"; //this.Sex.DataTextField = "ChineseName"; //this.Sex.DataBind(); //this.Sex.Items.Insert(0, new ListItem("所有", string.Empty)); this.status = RequestHelper.GetQueryString <int>("Status"); UserSearchInfo userSearch = SearchCondition(); if (companyID >= 0) { CompanyName.Value = CompanyBLL.ReadCompany(companyID).CompanyName; } this.UserName.Text = userSearch.UserName; this.RealName.Text = userSearch.RealName; this.Mobile.Text = userSearch.Mobile; this.Email.Text = userSearch.Email; //this.Sex.SelectedValue = userSearch.Sex.ToString(); this.StartRegisterDate.Text = RequestHelper.GetQueryString <string>("StartRegisterDate"); this.EndRegisterDate.Text = RequestHelper.GetQueryString <string>("EndRegisterDate"); base.BindControl(UserBLL.SearchUserList(base.CurrentPage, base.PageSize, userSearch, ref this.Count), this.RecordList, this.MyPager); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { CheckAdminPower("StatisticsUser", PowerCheckType.Single); Sex.DataSource = EnumHelper.ReadEnumList <SexType>(); Sex.DataValueField = "Value"; Sex.DataTextField = "ChineseName"; Sex.DataBind(); Sex.Items.Insert(0, new ListItem("所有", string.Empty)); UserSearchInfo userSearch = new UserSearchInfo(); userSearch.UserName = RequestHelper.GetQueryString <string>("UserName"); userSearch.Sex = RequestHelper.GetQueryString <int>("Sex"); DateTime startDate = RequestHelper.GetQueryString <DateTime>("StartDate"); DateTime endDate = ShopCommon.SearchEndDate(RequestHelper.GetQueryString <DateTime>("EndDate")); UserName.Text = userSearch.UserName; StartDate.Text = RequestHelper.GetQueryString <string>("StartDate"); EndDate.Text = RequestHelper.GetQueryString <string>("EndDate"); Sex.Text = RequestHelper.GetQueryString <int>("Sex").ToString(); string userConsumeType = RequestHelper.GetQueryString <string>("UserConsumeType"); userConsumeType = (userConsumeType == string.Empty) ? "OrderCount" : userConsumeType; UserConsumeType.Text = userConsumeType; BindControl(UserBLL.StatisticsUserConsume(CurrentPage, PageSize, userSearch, ref Count, userConsumeType, startDate, endDate), RecordList, MyPager); } }
/// <summary> /// 搜索用户 /// </summary> private void SearchUser() { UserSearchInfo userSearch = new UserSearchInfo(); userSearch.UserName = RequestHelper.GetQueryString <string>("UserName"); userList = UserBLL.SearchList(userSearch); }
public string CheckMobile() { string Result = string.Empty; string Mobile = RequestHelper.GetQueryString <string>("mobile"); UserSearchInfo userSearch = new UserSearchInfo(); userSearch.Mobile = Mobile; userSearch.GroupId = 36; try { Result = "{\"code\":0,"; if (UserBLL.SearchUserList(userSearch).Count > 0) { Result += "\"data\":false}"; } else { Result += "\"data\":true}"; } } catch { Result = "{\"code\":1,\"message\":\"异常错误!\"}"; } return(Result); }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { base.CheckAdminPower("StatisticsUser", PowerCheckType.Single); this.Sex.DataSource = EnumHelper.ReadEnumList <SexType>(); this.Sex.DataValueField = "Value"; this.Sex.DataTextField = "ChineseName"; this.Sex.DataBind(); this.Sex.Items.Insert(0, new ListItem("Ыљга", string.Empty)); UserSearchInfo userSearch = new UserSearchInfo(); userSearch.UserName = RequestHelper.GetQueryString <string>("UserName"); userSearch.Sex = RequestHelper.GetQueryString <int>("Sex"); userSearch.StartRegisterDate = RequestHelper.GetQueryString <DateTime>("StartRegisterDate"); userSearch.EndRegisterDate = ShopCommon.SearchEndDate(RequestHelper.GetQueryString <DateTime>("EndRegisterDate")); this.UserName.Text = userSearch.UserName; this.StartRegisterDate.Text = RequestHelper.GetQueryString <string>("StartRegisterDate"); this.EndRegisterDate.Text = RequestHelper.GetQueryString <string>("EndRegisterDate"); this.Sex.Text = RequestHelper.GetQueryString <int>("Sex").ToString(); string queryString = RequestHelper.GetQueryString <string>("UserOrderType"); queryString = (queryString == string.Empty) ? "LoginTimes" : queryString; this.UserOrderType.Text = queryString; base.BindControl(UserBLL.StatisticsUserActive(base.CurrentPage, base.PageSize, userSearch, ref this.Count, queryString), this.RecordList, this.MyPager); } }
protected void UserOutXls_Click(object sender, EventArgs e) { UserSearchInfo userSearch = SearchCondition(); userSearch.Condition = "Order by [CompanyId]"; List <UserInfo> userList = UserBLL.SearchUserList(userSearch); ExcelOut(userList); }
public DataTable StatisticsUserStatus(UserSearchInfo userSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, userSearch); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) }; pt[0].Value = mssqlCondition.ToString(); return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "StatisticsUserStatus", pt)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = RequestHelper.GetQueryString <int>("ID"); string Action = RequestHelper.GetQueryString <string>("Action"); if (Action == "Search") { string searchName = RequestHelper.GetQueryString <string>("username"); string searchCompanyName = StringHelper.SearchSafe(RequestHelper.GetQueryString <string>("companyname").Trim()); string searchPostName = StringHelper.SearchSafe(RequestHelper.GetQueryString <string>("postname").Trim()); DateTime startDate = RequestHelper.GetQueryString <DateTime>("StartDate"); DateTime endDate = RequestHelper.GetQueryString <DateTime>("EndDate"); int pageCount = RequestHelper.GetQueryString <int>("PageCount"); if (pageCount > 0) { base.PageSize = pageCount; this.PageCount.Text = pageCount.ToString(); } CompanyName.Text = searchCompanyName; SearchName.Text = searchName; PostName.Text = searchPostName; if (startDate != DateTime.MinValue) { SearchStartDate.Text = startDate.ToString("d"); } if (endDate != DateTime.MinValue) { SearchEndDate.Text = endDate.ToString("d"); } base.CheckAdminPower("ReadTestPaper", PowerCheckType.Single); PostPassInfo postpassSearch = new PostPassInfo(); postpassSearch.SearchStartDate = startDate; postpassSearch.CreateDate = ShopCommon.SearchEndDate(endDate); postpassSearch.PostName = searchPostName; if (!string.IsNullOrEmpty(searchCompanyName)) { postpassSearch.InCompanyID = CompanyBLL.ReadCompanyIdStr(searchCompanyName, 1); } if (!string.IsNullOrEmpty(searchName)) { UserSearchInfo user = new UserSearchInfo(); user.RealName = searchName; postpassSearch.InUserID = UserBLL.ReadUserIdStr(UserBLL.SearchUserList(user)); if (string.IsNullOrEmpty(postpassSearch.InUserID)) { postpassSearch.InUserID = "0"; } } base.BindControl(PostPassBLL.ReadPostPassList(postpassSearch, base.CurrentPage, base.PageSize, ref this.Count), this.RecordList, this.MyPager); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { CheckAdminPower("ReadUser", PowerCheckType.Single); string action = RequestHelper.GetQueryString <string>("Action"); int id = RequestHelper.GetQueryString <int>("Id"); if (id > 0) { switch (action) { case "Delete": CheckAdminPower("DeleteUser", PowerCheckType.Single); UserBLL.Delete(id); AdminLogBLL.Add(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("User"), id); break; default: break; } } //会员类型 usertype.DataSource = EnumHelper.ReadEnumList <UserType>(); usertype.DataTextField = "ChineseName"; usertype.DataValueField = "Value"; usertype.DataBind(); ListItem lt = new ListItem("--所有会员--", ""); usertype.Items.Insert(0, lt); UserSearchInfo userSearch = new UserSearchInfo(); userSearch.UserName = HttpUtility.UrlEncode(RequestHelper.GetQueryString <string>("UserName"), System.Text.Encoding.UTF8); userSearch.Mobile = RequestHelper.GetQueryString <string>("Mobile"); userSearch.Status = RequestHelper.GetQueryString <int>("Status"); userSearch.StartRegisterDate = RequestHelper.GetQueryString <DateTime>("StartRegisterDate"); userSearch.EndRegisterDate = ShopCommon.SearchEndDate(RequestHelper.GetQueryString <DateTime>("EndRegisterDate")); userSearch.UserType = RequestHelper.GetQueryString <int>("Type"); usertype.SelectedValue = userSearch.UserType.ToString(); UserName.Text = HttpUtility.UrlDecode(userSearch.UserName, System.Text.Encoding.UTF8); Mobile.Text = userSearch.Mobile; StartRegisterDate.Text = RequestHelper.GetQueryString <string>("StartRegisterDate"); EndRegisterDate.Text = RequestHelper.GetQueryString <string>("EndRegisterDate"); status = userSearch.Status; PageSize = Session["AdminPageSize"] == null ? 20 : Convert.ToInt32(Session["AdminPageSize"]); var userList = UserBLL.SearchListAndUserGrade(CurrentPage, PageSize, userSearch, ref Count); //Count = userList.Count; AdminPageSize.Text = Session["AdminPageSize"] == null ? "20" : Session["AdminPageSize"].ToString(); userList.ForEach(k => k.UserName = System.Web.HttpUtility.UrlDecode(k.UserName, System.Text.Encoding.UTF8)); //userList = userList.Skip((CurrentPage - 1) * PageSize).Take(PageSize).ToList(); BindControl(userList, RecordList, MyPager); } }
public DataTable StatisticsUserCount(UserSearchInfo userSearch, DateType dateType) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, userSearch); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar), new SqlParameter("@dateType", SqlDbType.Int) }; pt[0].Value = mssqlCondition.ToString(); pt[1].Value = (int)dateType; return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "StatisticsUserCount", pt)); }
public void PrepareCondition(MssqlCondition mssqlCondition, UserSearchInfo userSearch) { mssqlCondition.Add("[UserName]", userSearch.UserName, ConditionType.Like); mssqlCondition.Add("[Email]", userSearch.Email, ConditionType.Like); mssqlCondition.Add("[Sex]", userSearch.Sex, ConditionType.Equal); mssqlCondition.Add("[RegisterDate]", userSearch.StartRegisterDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[RegisterDate]", userSearch.EndRegisterDate, ConditionType.Less); mssqlCondition.Add("[Status]", userSearch.Status, ConditionType.Equal); mssqlCondition.Add("[ID]", userSearch.InUserID, ConditionType.In); }
protected void Page_Load(object sender, EventArgs e) { base.ClearCache(); UserSearchInfo user = new UserSearchInfo(); user.UserName = RequestHelper.GetQueryString <string>("UserName"); this.userList = UserBLL.SearchUserList(base.CurrentPage, base.PageSize, user, ref this.Count); this.MyPager.CurrentPage = base.CurrentPage; this.MyPager.PageSize = base.PageSize; this.MyPager.Count = base.Count; }
/// <summary> /// 页面加载 /// </summary> protected override void PageLoad() { base.PageLoad(); string action = RequestHelper.GetQueryString <string>("Action"); switch (action) { case "Add": PostProductReply(); break; default: break; } int currentPage = RequestHelper.GetQueryString <int>("Page"); if (currentPage < 1) { currentPage = 1; } int pageSize = 8; int count = 0; int commentID = RequestHelper.GetQueryString <int>("CommentID"); productReplyList = ProductReplyBLL.ReadProductReplyList(commentID, currentPage, pageSize, ref count, int.MinValue); ajaxPagerClass.CurrentPage = currentPage; ajaxPagerClass.PageSize = pageSize; ajaxPagerClass.Count = count; ajaxPagerClass.DisCount = false; ajaxPagerClass.ListType = false; string strUserID = string.Empty; foreach (ProductReplyInfo productReply in productReplyList) { if (strUserID == string.Empty) { strUserID = productReply.UserID.ToString(); } else { strUserID += "," + productReply.UserID.ToString(); } } if (strUserID != string.Empty) { UserSearchInfo userSearch = new UserSearchInfo(); userSearch.InUserID = strUserID; userList = UserBLL.SearchUserList(userSearch); } }
/// <summary> /// 统计用户状态 /// </summary> public DataTable StatisticsUserStatus(UserSearchInfo userSearch) { string condition = PrepareCondition(userSearch).ToString(); SqlParameter[] parameters = { new SqlParameter("@type", SqlDbType.VarChar), new SqlParameter("@condition", SqlDbType.NVarChar) }; parameters[0].Value = "StatisticsUserStatus"; parameters[1].Value = condition; return(ShopMssqlHelper.ExecuteDataTable("usp_Usr", parameters)); }
/// <summary> /// 用户数是否超限 /// </summary> /// <param name="companyID"></param> /// <returns></returns> public static bool IsUserNumOverflow(int companyID) { bool isOverflow = false; UserSearchInfo userSearch = new UserSearchInfo(); userSearch.InCompanyID = companyID.ToString(); userSearch.StatusNoEqual = (int)UserState.Del; if (SearchUserList(userSearch).Count >= CompanyBLL.ReadCompany(companyID).UserNum) { isOverflow = true; } return(isOverflow); }
public List <UserInfo> SearchUserList(UserSearchInfo userSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, userSearch); List <UserInfo> userList = new List <UserInfo>(); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) }; pt[0].Value = mssqlCondition.ToString(); using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchUserList", pt)) { this.PrepareUserModel(reader, userList); } return(userList); }
/// <summary> /// 获取userlist 包括usergrade /// </summary> /// <param name="searchInfo"></param> /// <returns></returns> public List <UserInfo> SearchListAndUserGrade(UserSearchInfo searchInfo) { using (var conn = new SqlConnection(connectString)) { string sql = "select * from View_UserGrade"; string condition = PrepareCondition(searchInfo).ToString(); if (!string.IsNullOrEmpty(condition)) { sql += " where " + condition; } sql += " Order by Id desc"; return(conn.Query <UserInfo>(sql).ToList()); } }
protected override void PageLoad() { base.PageLoad(); string queryString = RequestHelper.GetQueryString <string>("Action"); if ((queryString != null) && (queryString == "Delete")) { UserFriendBLL.DeleteUserFriend(RequestHelper.GetQueryString <string>("ID"), base.UserID); ResponseHelper.Write("ok"); ResponseHelper.End(); } int currentPage = RequestHelper.GetQueryString <int>("Page"); if (currentPage < 1) { currentPage = 1; } int pageSize = 0x19; int count = 0; UserFriendSearchInfo userFriend = new UserFriendSearchInfo(); userFriend.UserID = base.UserID; this.userFriendList = UserFriendBLL.SearchUserFriendList(currentPage, pageSize, userFriend, ref count); this.commonPagerClass.CurrentPage = currentPage; this.commonPagerClass.PageSize = pageSize; this.commonPagerClass.Count = count; string str3 = string.Empty; foreach (UserFriendInfo info2 in this.userFriendList) { if (str3 == string.Empty) { str3 = info2.FriendID.ToString(); } else { str3 = str3 + "," + info2.FriendID.ToString(); } } if (str3 != string.Empty) { UserSearchInfo user = new UserSearchInfo(); user.InUserID = str3; this.userList = UserBLL.SearchUserList(user); } }
public DataTable StatisticsUserActive(int currentPage, int pageSize, UserSearchInfo userSearch, ref int count, string orderField) { List <UserInfo> list = new List <UserInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); { class2.TableName = ShopMssqlHelper.TablePrefix + "View_UserActive"; class2.Fields = "[ID],[UserName],[Sex],[RegisterDate],[LoginTimes],[CommentCount],[ReplyCount],[MessageCount]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; } string str = orderField; if (str != null) { if (!(str == "LoginTimes")) { if (str == "CommentCount") { class2.OrderField = "[CommentCount],[ID]"; goto Label_00C1; } if (str == "ReplyCount") { class2.OrderField = "[ReplyCount],[ID]"; goto Label_00C1; } if (str == "MessageCount") { class2.OrderField = "[MessageCount],[ID]"; goto Label_00C1; } } else { class2.OrderField = "[LoginTimes],[ID]"; goto Label_00C1; } } class2.OrderField = "[LoginTimes],[ID]"; Label_00C1: class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, userSearch); class2.Count = count; count = class2.Count; return(class2.ExecuteDataTable()); }
protected override void PageLoad() { base.PageLoad(); string queryString = RequestHelper.GetQueryString <string>("Action"); if ((queryString != null) && (queryString == "Add")) { this.PostProductReply(); } int currentPage = RequestHelper.GetQueryString <int>("Page"); if (currentPage < 1) { currentPage = 1; } int pageSize = 8; int count = 0; int commentID = RequestHelper.GetQueryString <int>("CommentID"); this.productReplyList = ProductReplyBLL.ReadProductReplyList(commentID, currentPage, pageSize, ref count, -2147483648); this.ajaxPagerClass.CurrentPage = currentPage; this.ajaxPagerClass.PageSize = pageSize; this.ajaxPagerClass.Count = count; this.ajaxPagerClass.DisCount = false; this.ajaxPagerClass.ListType = false; string str2 = string.Empty; foreach (ProductReplyInfo info in this.productReplyList) { if (str2 == string.Empty) { str2 = info.UserID.ToString(); } else { str2 = str2 + "," + info.UserID.ToString(); } } if (str2 != string.Empty) { UserSearchInfo user = new UserSearchInfo(); user.InUserID = str2; this.userList = UserBLL.SearchUserList(user); } }
private UserSearchInfo SearchCondition() { UserSearchInfo userSearch = new UserSearchInfo(); if (companyID >= 0) { userSearch.InCompanyID = companyID.ToString(); } userSearch.RealName = RequestHelper.GetQueryString <string>("RealName"); userSearch.UserName = RequestHelper.GetQueryString <string>("UserName"); userSearch.Email = RequestHelper.GetQueryString <string>("Email"); userSearch.Mobile = RequestHelper.GetQueryString <string>("Mobile"); userSearch.Sex = RequestHelper.GetQueryString <int>("Sex"); userSearch.StartRegisterDate = RequestHelper.GetQueryString <DateTime>("StartRegisterDate"); userSearch.EndRegisterDate = ShopCommon.SearchEndDate(RequestHelper.GetQueryString <DateTime>("EndRegisterDate")); userSearch.Status = RequestHelper.GetQueryString <int>("Status"); return(userSearch); }
private MssqlCondition PrepareCondition(UserSearchInfo userSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[UserName]", userSearch.UserName, ConditionType.Like); mssqlCondition.Add("[Mobile]", userSearch.Mobile, ConditionType.Like); mssqlCondition.Add("[Email]", userSearch.Email, ConditionType.Like); mssqlCondition.Add("[Sex]", userSearch.Sex, ConditionType.Equal); mssqlCondition.Add("[RegisterDate]", userSearch.StartRegisterDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[RegisterDate]", userSearch.EndRegisterDate, ConditionType.Less); mssqlCondition.Add("[Status]", userSearch.Status, ConditionType.Equal); mssqlCondition.Add("[Id]", userSearch.InUserId, ConditionType.In); mssqlCondition.Add("[UserType]", userSearch.UserType, ConditionType.Equal); mssqlCondition.Add("[CardNo]", userSearch.CardNo, ConditionType.Like); mssqlCondition.Add("[ProviderNo]", userSearch.ProviderNo, ConditionType.Like); mssqlCondition.Add("[Distributor_Status]", userSearch.Distributor_Status, ConditionType.Equal); return(mssqlCondition); }
private void SendCode() { string Mobile = RequestHelper.GetQueryString <string>("Mobile"); if (!string.IsNullOrEmpty(Mobile)) { UserSearchInfo userSearch = new UserSearchInfo(); userSearch.Mobile = Mobile; List <UserInfo> userList = UserBLL.SearchUserList(userSearch); if (userList.Count > 0) { YXTSMS.YXTSMS api = new YXTSMS.YXTSMS(); string CheckCode = api.MakeCode(); SMSInfo SMSModel = new SMSInfo(); SMSModel.Mobile = Mobile; SMSModel.Content = new string[] { "找回密码", CheckCode, "2" }; if (api.SendSMS(SMSModel)) { SMSRecordInfo SMSRecordModel = new SMSRecordInfo(); SMSRecordModel.Mobile = SMSModel.Mobile; SMSRecordModel.VerCode = CheckCode; SMSRecordModel.DataCreateDate = DateTime.Now; SMSRecordBLL.AddSMSRecord(SMSRecordModel); //验证码加密后写入Cookies中 CookiesHelper.AddCookie("SMSCheckCode", StringHelper.Encode(CheckCode, "SMS"), 2, TimeType.Minute); ResponseHelper.Write("0|发送成功!"); } else { ResponseHelper.Write("1|发送失败!"); } } else { ResponseHelper.Write("2|手机号码不存在!"); } } else { ResponseHelper.Write("1|号码获取失败!"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { CheckAdminPower("ReadUser", PowerCheckType.Single); string action = RequestHelper.GetQueryString <string>("Action"); int id = RequestHelper.GetQueryString <int>("Id"); if (id > 0) { switch (action) { case "Delete": CheckAdminPower("DeleteUser", PowerCheckType.Single); if (ProductBLL.CountByShop(id) > 0) { ScriptHelper.Alert("该供应商存在相关产品,不能删除。"); } else { UserBLL.Delete(id); AdminLogBLL.Add(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("User"), id); } break; default: break; } } UserSearchInfo userSearch = new UserSearchInfo(); userSearch.UserName = RequestHelper.GetQueryString <string>("UserName"); userSearch.ProviderNo = RequestHelper.GetQueryString <string>("ProviderNo"); UserName.Text = userSearch.UserName; ProviderNo.Text = userSearch.ProviderNo; var userList = UserBLL.SearchList(new UserSearchInfo { UserName = userSearch.UserName, ProviderNo = userSearch.ProviderNo, UserType = (int)UserType.Provider }); Count = userList.Count; userList = userList.Skip((CurrentPage - 1) * PageSize).Take(PageSize).ToList(); BindControl(userList, RecordList, MyPager); } }
protected override void PageLoad() { base.PageLoad(); base.Title = "最小学习量达成分析表"; base.CheckUserPower("ReadEMSReport", PowerCheckType.Single); TestPaperInfo testPaperSearch = new TestPaperInfo(); testPaperSearch.TestMinDate = startDate; testPaperSearch.TestMaxDate = ShopCommon.SearchEndDate(endDate); testPaperSearch.Scorse = score; testPaperSearch.IsPass = isPass; testPaperSearch.PaperName = courseName; if (companyID < 0) { testPaperSearch.CompanyIdCondition = base.ExistsSonCompany ? base.SonCompanyID : base.UserCompanyID.ToString(); } else { testPaperSearch.CompanyIdCondition = companyID.ToString(); } if (!string.IsNullOrEmpty(realName) || !string.IsNullOrEmpty(userName)) { UserSearchInfo user = new UserSearchInfo(); user.RealName = realName; user.UserName = userName; user.InCompanyID = testPaperSearch.CompanyIdCondition; testPaperSearch.UserIdCondition = UserBLL.ReadUserIdStr(UserBLL.SearchUserList(user)); if (string.IsNullOrEmpty(testPaperSearch.UserIdCondition)) { testPaperSearch.UserIdCondition = "0"; } } //if (!string.IsNullOrEmpty(courseName)) //{ // testPaperSearch.Condition = "[CateID] in (select ID from [_Product] where [Name] like '%" + courseName + "%')"; //} testPaperList = TestPaperBLL.ReadList(testPaperSearch, base.CurrentPage, base.PageSize, ref this.Count); base.BindPageControl(ref base.CommonPager); }
/// <summary> /// 获取userlist 包括usergrade /// </summary> /// <param name="searchInfo"></param> /// <returns></returns> public List <UserInfo> SearchListAndUserGrade(int currentPage, int pageSize, UserSearchInfo searchModel, ref int count) { using (var conn = new SqlConnection(connectString)) { ShopMssqlPagerClass pc = new ShopMssqlPagerClass() { TableName = "[View_UserGrade]", Fields = "*", CurrentPage = currentPage, PageSize = pageSize, MssqlCondition = PrepareCondition(searchModel), OrderField = "[Id]", OrderType = OrderType.Desc }; count = pc.Count; var data = conn.Query <UserInfo>(pc).ToList(); return(data); } }
public List <UserInfo> SearchUserList(int currentPage, int pageSize, UserSearchInfo userSearch, ref int count) { List <UserInfo> userList = new List <UserInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = "[" + ShopMssqlHelper.TablePrefix + "User]"; class2.Fields = "[ID],[UserName],[UserPassword],[Email],[Sex],[Introduce],[Photo],[MSN],[QQ],[Tel],[Mobile],[RegionID],[Address],[Birthday],[RegisterIP],[RegisterDate],[LastLoginIP],[LastLoginDate],[LoginTimes],[SafeCode],[FindDate],[Status],[OpenID],[GroupID],[RealName],[CompanyID],[WorkingPostID],[StudyPostID],[WorkingPostName],[Department],[IDCard],[PostStartDate],[EntryDate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, userSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserModel(reader, userList); } return(userList); }
public List <UserInfo> SearchReportUserList(UserSearchInfo userSearch) { List <UserInfo> userList = new List <UserInfo>(); StringBuilder sql = new StringBuilder(); sql.Append("select [ID],[UserName],[UserPassword],[Email],[Sex],[Introduce],[Photo],[MSN],[QQ],[Tel],[Mobile],[RegionID],[Address],[Birthday],[RegisterIP],[RegisterDate],[LastLoginIP],[LastLoginDate],[LoginTimes],[SafeCode],[FindDate],[Status],[OpenID],[GroupID],[RealName],[CompanyID],[WorkingPostID],[StudyPostID],[WorkingPostName],[Department],[IDCard],[PostStartDate],[EntryDate] from [" + ShopMssqlHelper.TablePrefix + "User] "); MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, userSearch); if (mssqlCondition.ToString() != string.Empty) { sql.Append("where " + mssqlCondition.ToString()); sql.Append(" Order by [CompanyID] Desc, [Department],[WorkingPostID],[WorkingPostName],[StudyPostID],[RegisterDate]"); using (SqlDataReader reader = DbSQLHelper.ExecuteReader(sql.ToString())) { this.PrepareUserModel(reader, userList); } } return(userList); }
/// <summary> /// 用户消费分析 /// </summary> public DataTable StatisticsUserConsume(int currentPage, int pageSize, UserSearchInfo userSearch, ref int count, string orderField, DateTime startDate, DateTime endDate) { List <UserInfo> userList = new List <UserInfo>(); string orderCondition = string.Empty; MssqlCondition orderCh = new MssqlCondition(); orderCh.Add("[AddDate]", startDate, ConditionType.MoreOrEqual); orderCh.Add("[AddDate]", endDate, ConditionType.Less); orderCondition = orderCh.ToString(); if (!string.IsNullOrEmpty(orderCondition)) { orderCondition = " AND " + orderCondition; } ShopMssqlPagerClass pc = new ShopMssqlPagerClass(); pc.TableName = "(SELECT Id,UserName,Sex,ISNULL(OrderCount,0) AS OrderCount,ISNULL(OrderMoney,0) AS OrderMoney "; pc.TableName += "FROM Usr "; pc.TableName += "LEFT OUTER JOIN (SELECT UserId, COUNT(*) AS OrderCount,Sum(ProductMoney-FavorableMoney+ShippingMoney+OtherMoney-CouponMoney) AS OrderMoney FROM [Order] WHERE OrderStatus=6 " + orderCondition + " GROUP BY UserId) AS TEMP3 ON Usr.Id = TEMP3.UserId where Usr.status = 2) AS PageTable"; pc.Fields = "[Id],[UserName],[Sex],[OrderCount],[OrderMoney]"; pc.CurrentPage = currentPage; pc.PageSize = pageSize; switch (orderField) { case "OrderCount": pc.OrderField = "[OrderCount],[Id]"; break; case "OrderMoney": pc.OrderField = "[OrderMoney],[Id]"; break; default: pc.OrderField = "[OrderCount],[Id]"; break; } pc.OrderType = OrderType.Desc; pc.MssqlCondition = PrepareCondition(userSearch); pc.Count = count; count = pc.Count; return(pc.ExecuteDataTable()); }
/// <summary> /// 是否存在手机号码(只验证非删除的考试人员) /// </summary> /// <param name="mobile"></param> /// <param name="userID"></param> /// <returns></returns> public static bool IsExistMobile(string mobile, int userID) { bool isExist = false; if (!string.IsNullOrEmpty(mobile)) { UserSearchInfo userSearch = new UserSearchInfo(); userSearch.Mobile = mobile; userSearch.StatusNoEqual = (int)UserState.Del; userSearch.GroupId = 36; if (userID > 0) { userSearch.OutUserID = userID.ToString(); } if (UserBLL.SearchUserList(userSearch).Count > 0) { isExist = true; } } return(isExist); }