private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); if (this.site_id > 0) { this.ddlSiteId.SelectedValue = this.site_id.ToString(); } if (this.group_id > 0) { this.ddlGroupId.SelectedValue = this.group_id.ToString(); } this.txtStartTime.Text = this.start_time; this.txtEndTime.Text = this.end_time; this.txtKeywords.Text = this.keywords; BLL.users bll = new BLL.users(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("user_list.aspx", "site_id={0}&group_id={1}&start_time={2}&end_time={3}&keywords={4}&page={5}", this.site_id.ToString(), this.group_id.ToString(), this.start_time, this.end_time, this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
/// 注册 /// </summary> public void regist(HttpContext context) { string outmsg = "{\"status\":1,\"msg\":\"注册成功!\"}"; string mobile = _Request.GetString("mobile"); string usersname = _Request.GetString("usersname"); string password = _Request.GetString("password"); string usersaera = _Request.GetString("usersaera"); string usernick = _Request.GetString("usernick");//y用户昵称 string userPwd1 = Vincent._MD5Encrypt.GetMD5(password.Trim()); Model.users model = new Model.users(); BLL.users bll = new BLL.users(); model.user_name = mobile; model.mobile = mobile; model.isEmail = 0; model.isMobile = 0; model.Parentid = 0; model.Leftor_right = 0; model.MarketId = 0; model.OrganizeId = 0; model.PreId = 0; model.nick_name = usernick;//用户昵称 //model.password = Vincent._DESEncrypt.Encrypt(password.Trim()); //model.password = Vincent._DESEncrypt.Encrypt(password.Trim()); model.salt = Vincent._DTcms.Utils.GetCheckCode(6); //获得6位的salt加密字符串 model.password = _DESEncrypt.Encrypt(password, model.salt); if (!bll.ExistsMobile(mobile)) { int id = bll.AddPc(model); if (id > 0) { DataTable dt = bll.GetList(0, "id =" + id + " ", "id asc").Tables[0]; if (dt != null && dt.Rows.Count > 0) { outmsg = CreateJsonParameters(dt); } //// 保存session值 context.Session[DTKeys.SESSION_USER_INFO] = model; context.Session.Timeout = 45; context.Response.Clear(); context.Response.Write(outmsg); context.Response.End(); } else { context.Response.Clear(); context.Response.Write("{\"status\":0,\"msg\":\"注册未成功!\"}"); context.Response.End(); } } else { context.Response.Clear(); context.Response.Write("{\"status\":0,\"msg\":\"注册未成功!\"}"); context.Response.End(); } }
private void Bind(int pageindex) { DTcms.BLL.users userbll = new BLL.users(); int count = 0; repdata.DataSource = userbll.GetList(10, pageindex, " group_id=5 ", " id", out count); repdata.DataBind(); aspPage.RecordCount = count; aspPage.PageSize = 10; }
private void loadUser() { BLL.users bllUser = new BLL.users(); DataTable dt = bllUser.GetList(100000, "", "ID DESC").Tables[0]; if (dt != null) { Repeater1.DataSource = dt.DefaultView; Repeater1.DataBind(); } }
/// <summary> /// 数据列表绑定 /// </summary> private void RptBind(string whereStr) { //绑定数据 this.page = Common.Utils.GetQueryInt("page", 1); rpt_list.DataSource = bll.GetList(this.pagesize, this.page, whereStr, " id asc", out this.totalCount); rpt_list.DataBind(); txtTotalCount.InnerText = totalCount.ToString();//绑定总记录数 //txtPageNum.Text = this.pagesize.ToString();//绑定页码 // txtPageNum.InnerText = this.pagesize.ToString();//绑定页码 string pageUrl = Common.Utils.CombUrlTxt("user_list.aspx", "page={0}", "__id__"); PageContent.InnerHtml = Common.Utils.OutPageList(this.pagesize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); this.txtKeywords.Text = this.keywords; BLL.users bll = new BLL.users(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("user_audit.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); //this.txtKeywords.Text = this.keywords; BLL.users bll = new BLL.users(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("user_audit.aspx", "keywords={0}&page={1}", txtKeywords.Text, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
protected void btnLogin_Click(object sender, EventArgs e) { BLL.users userService = new BLL.users(); string userName = txtUserName.Text.Trim(); string password = Maticsoft.Common.DEncrypt.DESEncrypt.Encrypt(txtPassword.Text.Trim(), ConfigHelper.GetConfigString("PassWordEncrypt")); //string password = txtPassword.Text.Trim(); DataTable userList = userService.GetList("userName='******' and password='******' and roleId in (4,10,11)").Tables[0]; if (userList.Rows.Count > 0) { if (userList.Rows[0]["status"].ToString() == "0") { MessageBox.Show(this, "此用户名已被冻结,无法登陆!"); return; } //写入Cookie try { Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_UserId, 2, userList.Rows[0]["userId"].ToString()); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_UserName, 2, txtUserName.Text.Trim()); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_TrueName, 2, DESEncrypt.Encrypt(userList.Rows[0]["trueName"].ToString())); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_RoleId, 2, userList.Rows[0]["roleId"].ToString()); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_RoleName, 2, DESEncrypt.Encrypt(userList.Rows[0]["roleName"].ToString())); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_DeptId, 2, userList.Rows[0]["deptId"].ToString()); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_IsAdmin, 2, userList.Rows[0]["isAdmin"].ToString()); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_Avatar, 2, userList.Rows[0]["avatar_small"].ToString()); Common.Cookie.SetObject(StatusHelpercs.Cookie_Admin_LastLoginTime, 2, DateTime.Parse(userList.Rows[0]["lastLoginTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss")); } catch { //Session["userName"] = txtUserName.Text.Trim(); //Session["userType"] = ddrUserTyp.SelectedValue; //Session["orgId"] = userList.Rows[0]["orgId"].ToString(); } //更新最后登陆时间 Model.users userModel = userService.GetModel(int.Parse(userList.Rows[0]["userId"].ToString())); userModel.lastLoginTime = DateTime.Now; userService.Update(userModel); Response.Redirect("index.aspx"); //MessageBox.ShowAndRedirect(this, "登录成功!", "index.html"); } else { MessageBox.Show(this, "用户名或密码错误!"); } }
protected void btnLogin_Click(object sender, EventArgs e) { BLL.users userService = new BLL.users(); string userName = txtUserName.Text.Trim(); string password = Maticsoft.Common.DEncrypt.DESEncrypt.Encrypt(txtPassword.Text.Trim(), ConfigHelper.GetConfigString("PassWordEncrypt")); //string password = txtPassword.Text.Trim(); DataTable userList = userService.GetList("userName='******' and password='******'").Tables[0]; if (userList.Rows.Count > 0) { if (userList.Rows[0]["status"].ToString() == "0") { MessageBox.Show(this, "此用户名已被冻结,无法登陆!"); return; } //写入Cookie try { Common.Cookie.SetObject("userName", 2, txtUserName.Text.Trim()); Common.Cookie.SetObject("roleId", 2, userList.Rows[0]["roleId"].ToString()); Common.Cookie.SetObject("roleName", 2, DESEncrypt.Encrypt(userList.Rows[0]["roleName"].ToString())); Common.Cookie.SetObject("userId", 2, userList.Rows[0]["userId"].ToString()); Common.Cookie.SetObject("deptId", 2, userList.Rows[0]["deptId"].ToString()); Common.Cookie.SetObject("trueName", 2, DESEncrypt.Encrypt(userList.Rows[0]["trueName"].ToString())); Common.Cookie.SetObject("isAdmin", 2, userList.Rows[0]["isAdmin"].ToString()); Common.Cookie.SetObject("lastLoginTime", 2, DESEncrypt.Encrypt(DateTime.Parse(userList.Rows[0]["lastLoginTime"].ToString()).ToString("yyyy年MM月dd日 HH时mm分ss秒"))); } catch { //Session["userName"] = txtUserName.Text.Trim(); //Session["userType"] = ddrUserTyp.SelectedValue; //Session["orgId"] = userList.Rows[0]["orgId"].ToString(); } //更新最后登陆时间 Model.users userModel = userService.GetModel(int.Parse(userList.Rows[0]["userId"].ToString())); userModel.lastLoginTime = DateTime.Now; userService.Update(userModel); Response.Redirect("index.html"); //MessageBox.ShowAndRedirect(this, "登录成功!", "index.html"); } else { MessageBox.Show(this, "用户名或密码错误!"); } }
private void RptBind(string _strWhere, string _orderby) { this.page = MXRequest.GetQueryInt("page", 1); if (this.group_id > 0) { this.ddlGroupId.SelectedValue = this.group_id.ToString(); } this.txtKeywords.Text = this.keywords; BLL.users bll = new BLL.users(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("user_list.aspx", "group_id={0}&keywords={1}&page={2}", this.group_id.ToString(), this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = Vincent._DTcms.DTRequest.GetQueryInt("page", 1); if (this.group_id > 0) { this.ddlGroupId.SelectedValue = this.group_id.ToString(); } this.txtKeywords.Text = this.keywords; BLL.users bll = new BLL.users(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere + " and 1=1 and isDelete = 0", _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Vincent._DTcms.Utils.CombUrlTxt("user_list_level.aspx", "group_id={0}&keywords={1}&page={2}", this.group_id.ToString(), this.keywords, "__id__"); PageContent.InnerHtml = Vincent._DTcms.Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void TreeBindLevel(string strWhere) { BLL.users bll = new BLL.users(); DataTable dt = bll.GetList(0, strWhere, "id asc").Tables[0]; this.DropDownList1.Items.Clear(); this.DropDownList1.Items.Add(new ListItem("请选择店长...", "")); foreach (DataRow dr in dt.Rows) { if (dr["nick_name"].ToString() != "") { this.DropDownList1.Items.Add(new ListItem(dr["nick_name"].ToString(), dr["id"].ToString())); } } }
protected void Session_Start(object sender, EventArgs e) { //在新会话启动时运行的代码 #region 构建购物车内存表 //构建购物车内存表 DataTable dtShopCart = new DataTable(); //添加产品编号字段 DataColumn keyCol = new DataColumn("GoodsId", typeof(Int32)); dtShopCart.Columns.Add(keyCol); //添加产品内容字段 dtShopCart.Columns.Add(new DataColumn("GoodsName", typeof(string))); dtShopCart.Columns.Add(new DataColumn("GoodsImage", typeof(string))); dtShopCart.Columns.Add(new DataColumn("GoodsPrice", typeof(decimal))); dtShopCart.Columns.Add(new DataColumn("GoodsCount", typeof(int))); dtShopCart.Columns.Add(new DataColumn("GoodsTotal", typeof(decimal))); dtShopCart.Columns.Add(new DataColumn("GoodsActive", typeof(int))); //将产品编号设置为主键 DataColumn[] primKey = { keyCol }; dtShopCart.PrimaryKey = primKey; //将数据表结构写入Session Session["DGCart"] = dtShopCart; #endregion #region 规定时间未付款,降级为普通会员 DateTime dtNow = DateTime.Now; BLL.users bllUser = new BLL.users(); DataTable dtUserList = bllUser.GetList(1000000, " group_id<>5 and is_lock=0", " reg_time desc").Tables[0]; if (dtUserList != null) { for (int i = 0; i < dtUserList.Rows.Count; i++) { if (!string.IsNullOrEmpty(dtUserList.Rows[i]["reg_time"].ToString())) { DateTime UserRegTime = DateTime.Parse(dtUserList.Rows[i]["reg_time"].ToString()).AddYears(2); DateTime SetEmailUserRegTime = DateTime.Parse(dtUserList.Rows[i]["reg_time"].ToString()).AddDays(699); int isFee = int.Parse(dtUserList.Rows[i]["isFee"].ToString()); int UserID = int.Parse(dtUserList.Rows[i]["ID"].ToString()); //int length = ((TimeSpan)(dtNow - UserRegTime)).Days; string GroupID = dtUserList.Rows[i]["group_id"].ToString(); string GroupName = "普通會員"; switch (GroupID) { case "1": GroupName = "普通會員"; break; case "2": GroupName = "尊榮卡"; break; case "3": GroupName = "柏金卡"; break; case "4": GroupName = "御皇卡"; break; } if (isFee == 0 && dtNow == UserRegTime) { bllUser.UpUserSetCommon(UserID); int bk = bllUser.UpFee(UserID, 0); } else if (isFee == 0 && dtNow == SetEmailUserRegTime) { string UserName = dtUserList.Rows[i]["user_name"].ToString(); string email = dtUserList.Rows[i]["email"].ToString(); string Contnet = "親愛的" + UserName + ",你的" + GroupName + "會員將在" + DateTime.Now.AddDays(30).ToString() + "到期" + ",請您儘快續費"; setEmail(email, ""); } } } } #endregion }
protected void btnExport1_Click(object sender, EventArgs e) { string fileName = "用戶資料" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xls"; BLL.users bll = new BLL.users(); string strurl = "0"; for (int ai = 0; ai < rptList.Items.Count; ai++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[ai].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[ai].FindControl("chkId"); if (cb.Checked) { strurl = strurl + "," + id.ToString();; } } DataTable dt = new DataTable(); //if (strurl.Length > 1) //{ // dt = bll.GetList(0, "id in(" + strurl + ")" + CombSqlTxt(this.group_id, this.keywords), "reg_time desc,id desc").Tables[0]; //} //else //{ dt = bll.GetList(0, "id>0 and exp=1" + CombSqlTxt(this.group_id, this.keywords), "reg_time desc,id desc").Tables[0]; //} string[] titleCol = new string[] { "姓名", "性別", "⽣⽇_年", "⽣⽇_⽉", "⽣⽇_⽇", "電話1", "電話2", "傳真1", "傳真2", "⼿機1", "⼿機2", "Email1", "Email2", "Email3", "郵遞區號", "住址", "即時通訊", "群組", "啟⽤電⼦報", "公司名稱", "部⾨職稱", "公司電話", "公司傳真", "公司地址1", "公司地址2", "統⼀編號", "網站", "備註" }; Response.Clear(); Response.Buffer = true; Response.Charset = "UTF-8"; Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8"); Response.Write("<metahttp-equiv=Content-Type content=application/ms-excel;charset=UTF-8>"); Response.ContentType = "application/ms-excel;charset=UTF-8"; ////定义表对象与行对象,同时用DataSet对其值进行初始化 //DataTable dt = ds.Tables[0]; DataRow[] myRow = dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的 int i = 0; int j = 0; StringBuilder sb = new StringBuilder(); sb.Append("<table borderColor='black' border='1' >"); sb.Append("<thead>"); sb.Append("<tr>"); //取得数据表各列标题,各标题之间以t分割,最后一个列标题后加回车符 for (i = 0; i < titleCol.Length; i++) { sb.Append("<th>" + titleCol[i].ToString() + "</th>"); } sb.Append("</tr>"); sb.Append("</thead>"); sb.Append("<tbody>"); //向HTTP输出流中写入取得的数据信息 //逐行处理数据 foreach (DataRow dr in dt.Rows) { sb.Append("<tr>"); for (i = 0; i < titleCol.Length; i++) { switch (i) { case 0: sb.Append("<td>" + dr["nick_name"].ToString() + "</td>"); break; case 1: sb.Append("<td>" + dr["sex"].ToString() + "</td>"); break; case 2: sb.Append("<td>" + Utils.StrToDateTime(dr["birthday"].ToString()).Year + "</td>"); break; case 3: sb.Append("<td>" + Utils.StrToDateTime(dr["birthday"].ToString()).Month + "</td>"); break; case 4: sb.Append("<td>" + Utils.StrToDateTime(dr["birthday"].ToString()).Day + "</td>"); break; case 5: sb.Append("<td>" + dr["mobile"].ToString() + "</td>"); break; case 6: sb.Append("<td></td>"); break; case 7: sb.Append("<td></td>"); break; case 8: sb.Append("<td></td>"); break; case 9: sb.Append("<td>" + dr["mobile"].ToString() + "</td>"); break; case 10: sb.Append("<td></td>"); break; case 11: sb.Append("<td>" + dr["email"].ToString() + "</td>"); break; case 12: sb.Append("<td></td>"); break; case 13: sb.Append("<td></td>"); break; case 14: sb.Append("<td>" + dr["qq"].ToString() + "</td>"); break; case 15: sb.Append("<td>" + dr["area"].ToString() + "," + dr["address"].ToString() + "</td>"); break; case 16: sb.Append("<td></td>"); break; case 17: sb.Append("<td></td>"); break; case 18: sb.Append("<td>" + getexp(dr["exp"].ToString()) + "</td>"); break; case 19: sb.Append("<td></td>"); break; case 20: sb.Append("<td></td>"); break; case 21: sb.Append("<td></td>"); break; case 22: sb.Append("<td></td>"); break; case 23: sb.Append("<td></td>"); break; case 24: sb.Append("<td></td>"); break; case 25: sb.Append("<td></td>"); break; case 26: sb.Append("<td></td>"); break; case 27: sb.Append("<td></td>"); break; } } sb.Append("</tr>"); } sb.Append("</tbody></table>"); Response.Write(sb.ToString()); Response.End(); }