public int cou(Model.user aa) { string sql = "select count(* )from [user] where _username like '%" + aa.username + "%' "; int result = Convert.ToInt32(Common.DB.ExecuteScalar(sql)); return(result); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; int id = Convert.ToInt32(context.Request["id"]); BLL.blogs bll_blog = new BLL.blogs(); Model.blogs model_blog = bll_blog.GetModel(id); //阅读排行榜 List <Model.blogs> list_blog = bll_blog.GetModelList("Blog_delete = 0 and Blog_is = 1 order by Blog_read desc LIMIT 4"); //评论 BLL.tell bll_tell = new BLL.tell(); List <Model.tell> list_tell = bll_tell.GetModelList("Tell_blogid=" + id + ""); BLL.user bll_user = new BLL.user(); for (int i = 0; i < list_tell.Count; i++) { Model.user model_user = bll_user.GetModel((int)list_tell[i].Tell_userid); list_tell[i].Tell_name = model_user.User_name; } Model.showblog model_show = new Model.showblog() { Show_blog = model_blog, Show_list = list_blog, Show_tell = list_tell }; System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); string is_show = js.Serialize(model_show); context.Response.Write(is_show); }
public Boolean zhuce(Model.user u) { bool q = new bool(); //注册 try { con.Open();//打开连接 SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = "insert into user1(账号,密码) values ('" + u.username + "','" + u.password + "')"; if (com.ExecuteNonQuery() != 0) { q = true; } else { q = false; } } catch (Exception e) { System.Console.Write("错误" + e); } finally { con.Close(); } return(q); }
//更新会员信息 public int upuse(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("update [user] set _user_name=@username,_pwd=@pwd,_email=@email,_qq=@qq,_msn=@msn,_safe_question=@safeque,_safe_pwd=@safepwd where _user_id=@id"); SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@username", SqlDbType.VarChar, 50), new SqlParameter("@pwd", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@qq", SqlDbType.VarChar, 50), new SqlParameter("@msn", SqlDbType.VarChar, 50), new SqlParameter("@safeque", SqlDbType.VarChar, 150), new SqlParameter("@safepwd", SqlDbType.VarChar, 150) }; par[0].Value = aa.userid; par[1].Value = aa.username; par[2].Value = Common.DESEncrypt.Encrypt(aa.pwd); par[3].Value = aa.email; par[4].Value = aa.qq; par[5].Value = aa.msn; par[6].Value = aa.safequestion; par[7].Value = aa.safepwd; return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par)); }
//注册会员 public int insert(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("insert into [user] ( _user_name,_pwd,_email,_qq,_msn,_safe_question,_safe_pwd ) values(@username,@pwd,@email,@qq,@msn,@safeque,@safepwd)"); SqlParameter[] par = { new SqlParameter("@username", SqlDbType.VarChar, 50), new SqlParameter("@pwd", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@qq", SqlDbType.VarChar, 50), new SqlParameter("@msn", SqlDbType.VarChar, 50), new SqlParameter("@safeque", SqlDbType.VarChar, 150), new SqlParameter("@safepwd", SqlDbType.VarChar, 150) }; par[0].Value = aa.username; par[1].Value = Common.DESEncrypt.Encrypt(aa.pwd); par[2].Value = aa.email; par[3].Value = aa.qq; par[4].Value = aa.msn; par[5].Value = aa.safequestion; par[6].Value = aa.safepwd; return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par)); }
private bool DoEdit(int _id) { try { BLL.user bll = new BLL.user(); Model.user model = bll.GetModel(_id); model.nickname = txtName.Text; model.status = Convert.ToInt32(rblStatus.SelectedValue); model.sex = Convert.ToInt32(rblSex.SelectedValue); model.point = Convert.ToInt32(txtPoint.Text); model.parent_id = Convert.ToInt32(txtParent.Text); model.phone = txtPhone.Text; model.email = txtEmail.Text; model.login_time = Convert.ToDateTime(txtLoginTime.Text); model.reg_time = Convert.ToDateTime(txtRegTime.Text); if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改产品经理信息"); //记录日志 return(true); } } catch { return(false); } return(false); }
public DataSet dsu(int a, int b, string c, Model.user aa) { string sql = "select * from [user] where _username like '%" + aa.username + "%' "; DataSet ds = Common.DB.PagedataSet(sql, a, b, c); return(ds); }
private void label2_Click(object sender, EventArgs e) { try { Model.user u = new Model.user(); u.Name = this.txtname.Text.Trim(); u.Pwd = this.txtpwd.Text.Trim(); if (IfInput(u.Name, u.Pwd)) { bool b = um.ExistsUsers(u); if (b) { main_interface admin = new main_interface(); admin.Show(); this.Visible = false; } else { MessageBox.Show("登陆失败"); } } } catch { } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; if (Convert.ToString(context.Session["USER"]) != "") { string text_tell = context.Request["text_tell"]; int bid = Convert.ToInt32(context.Request["bid"]); object a = context.Session["USER"]; Model.user user = (Model.user)a; Model.tell model_tell = new Model.tell() { Tell_blogid = bid, Tell_userid = user.User_id, Tell_text = text_tell }; BLL.tell bll_tell = new BLL.tell(); if (bll_tell.Add(model_tell)) { context.Response.Write(1); } } else { context.Response.Write(0); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string user = context.Request["username"]; string pattern = @"^\d*$"; if (Regex.IsMatch(user, pattern)) { int phone = 0; int userid = Convert.ToInt32(user); if (int.TryParse(context.Request["phone"], out phone)) { phone = Convert.ToInt32(context.Request["phone"]); string pwd = context.Request["pwd"]; string cpwd = context.Request["cpwd"]; if (pwd == cpwd) { Model.user model_user = new Model.user() { User_id = userid, User_pwd = pwd, User_phone = phone, User_name = userid.ToString(), User_img = "../images/m_01.jpg", User_qq = 0 }; BLL.user bll_user = new BLL.user(); if (!bll_user.Exists(userid)) { if (bll_user.Add(model_user)) { context.Session["USER"] = model_user; HttpCookie cookie_id = new HttpCookie("userid"); cookie_id.Expires = DateTime.Now.AddDays(1); cookie_id.Value = userid.ToString(); context.Response.AppendCookie(cookie_id); HttpCookie cookie_pwd = new HttpCookie("userpwd"); cookie_pwd.Expires = DateTime.Now.AddDays(1); cookie_pwd.Value = pwd.ToString(); context.Response.AppendCookie(cookie_pwd); context.Response.Write(1); } } else { context.Response.Write("用户名已存在"); } } else { context.Response.Write("密码输入有错误"); } } else { context.Response.Write("手机号输入有误"); } } }
public void AddTest() { BLL.user usrbll = new BLL.user(); Model.user usr = new Model.user(); usr.feature_data = new byte[512]; usr.face_image_path = "1.jpg"; usrbll.Add(usr); }
//删除用户信息 public void delete(Model.user my) { String sql = "delete from users where name=@name"; List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@name", my.Name)); co.ExecuteSql(sql, sqlParams); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; int userid = 0; #region 没有cookie if (int.TryParse(context.Request["username"], out userid)) { #region 账号格式正确 userid = Convert.ToInt32(context.Request["username"]); BLL.user bll_user = new BLL.user(); Model.user model_user = bll_user.GetModel(userid); if (model_user != null) { string pwd = context.Request["password"]; if (model_user.User_pwd == pwd) { #region 密码正确 context.Session["USER"] = model_user; string loginkeeping = context.Request["loginkeeping"]; if (loginkeeping != null) { #region 记住我 HttpCookie cookie_id = new HttpCookie("userid"); cookie_id.Expires = DateTime.Now.AddDays(1); cookie_id.Value = userid.ToString(); context.Response.AppendCookie(cookie_id); HttpCookie cookie_pwd = new HttpCookie("userpwd"); cookie_pwd.Expires = DateTime.Now.AddDays(1); cookie_pwd.Value = pwd.ToString(); context.Response.AppendCookie(cookie_pwd); context.Response.Write(1); #endregion } #endregion } else { context.Response.Write("密码输入错误"); } } else { if (context.Request.Cookies["userid"] != null && context.Request.Cookies["userpwd"] != null) { int id = Convert.ToInt32(context.Request.Cookies["userid"].Value); BLL.user bll_userid = new BLL.user(); Model.user model_userid = bll_userid.GetModel(userid); context.Session["USER"] = model_user; object a = context.Session["USER"].ToString(); context.Response.Write(1); } context.Response.Write("账号格式错误"); } #endregion } #endregion } }
public Main(user user) { InitializeComponent(); timer.Tick += this.ExitInWindow; User = user; timer.Interval = new TimeSpan(0, 15, 0); RepemberMeEnable(); RestartTimer(); }
//更新用户信息 public void update(Model.user my) { String sql = "update users set name=@name,pwd=@pwd where name=@name"; List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@name", my.Name)); sqlParams.Add(new SqlParameter("@pwd", my.Pwd)); co.ExecuteSql(sql, sqlParams); }
//添加用户 public void insert(Model.user my) { String sql = "insert into users(name,pwd)values(@name,@pwd)"; List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@name", my.Name)); sqlParams.Add(new SqlParameter("@pwd", my.Pwd)); co.ExecuteSql(sql, sqlParams); }
public bool ExistsUsers(Model.user users) { int n = us.ExistsUsers(users); if (n > 0) { return(true); } return(false); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.user</param> /// <returns>ID</returns> public int Add(Model.user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "user]("); strSql.Append("avatar,nickname,openid,unionid,point,img,level,parent_id,phone,email,sex,area,status,reg_time,login_time,amount"); strSql.Append(") values("); strSql.Append("@avatar,@nickname,@openid,@unionid,@point,@img,@level,@parent_id,@phone,@email,@sex,@area,@status,@reg_time,@login_time,@amount)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@avatar", SqlDbType.VarChar, 200), new SqlParameter("@nickname", SqlDbType.VarChar, 100), new SqlParameter("@openid", SqlDbType.VarChar, 50), new SqlParameter("@unionid", SqlDbType.VarChar, 50), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@img", SqlDbType.VarChar, 100), new SqlParameter("@level", SqlDbType.Int, 4), new SqlParameter("@parent_id", SqlDbType.Int, 4), new SqlParameter("@phone", SqlDbType.VarChar, 20), new SqlParameter("@email", SqlDbType.VarChar, 32), new SqlParameter("@sex", SqlDbType.Int, 4), new SqlParameter("@area", SqlDbType.VarChar, 100), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@login_time", SqlDbType.DateTime), new SqlParameter("@amount", SqlDbType.Decimal, 5) }; parameters[0].Value = model.avatar; parameters[1].Value = model.nickname; parameters[2].Value = model.openid; parameters[3].Value = model.unionid; parameters[4].Value = model.point; parameters[5].Value = model.img; parameters[6].Value = model.level; parameters[7].Value = model.parent_id; parameters[8].Value = model.phone; parameters[9].Value = model.email; parameters[10].Value = model.sex; parameters[11].Value = model.area; parameters[12].Value = model.status; parameters[13].Value = model.reg_time; parameters[14].Value = model.login_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
//判断该用户邮箱是否存在 public DataSet checkEmail(Model.user u) { StringBuilder sql = new StringBuilder(); sql.Append("select _userid from [user] where _email=@email"); SqlParameter[] par = { new SqlParameter("@email", SqlDbType.VarChar, 50) }; par[0].Value = u.email; return(Common.DbHelperSQL.Query(sql.ToString(), par)); }
//查询用户ID public object QueryAdminID(Model.user user) { string sqlTest = @"select id from users where name=@name and pwd=@pwd"; SqlParameter[] par = { new SqlParameter("@name", user.Name), new SqlParameter("@pwd", user.Pwd) }; return(DBHelper.ExecuteScalar(sqlTest, par)); }
public SqlDataReader drus(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("select * from [user] where _userid=@id"); SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4) }; par[0].Value = aa.userid; return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par)); }
public SqlDataReader dd(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("select _user_id from [user] where _email=@email"); SqlParameter[] par = { new SqlParameter("@email", SqlDbType.VarChar, 50) }; par[0].Value = aa.email; return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par)); }
//会员收藏夹 public int seleid(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("select * from collect where _user_id=@id"); SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4) }; par[0].Value = aa.userid; return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //博客类别 string session_user = null; //if (context.Session["USER"] != null){ // session_user = context.Session["USER"].ToString(); //} BLL.blog_type bll_type = new BLL.blog_type(); List <Model.blog_type> list_type = bll_type.GetModelList(""); //热门博客 BLL.blogs bll_blogs = new BLL.blogs(); List <Model.blogs> list_hotblogs = bll_blogs.GetModelList(" Blog_delete = 0 and Blog_is = 1 order by Blog_read desc"); Model.blogs moblogs = list_hotblogs[0]; //图片分享 BLL.img bll_img = new BLL.img(); List <Model.img> list_img = bll_img.GetModelList("Img_is=1"); //评论 BLL.tell bll_tell = new BLL.tell(); BLL.user bll_user = new BLL.user(); List <Model.tell> list_tell = bll_tell.GetModelList(" Tell_id>0 order by Tell_blogid LIMIT 3"); for (int i = 0; i < list_tell.Count; i++) { Model.user model_user = bll_user.GetModel((int)list_tell[i].Tell_userid); list_tell[i].Tell_img = model_user.User_img; list_tell[i].Tell_name = model_user.User_name; } //推荐博客 List <Model.blogs> list_tuiblogs = new List <Model.blogs> { list_hotblogs[1], list_hotblogs[2], list_hotblogs[3] }; Model.Main main = new Model.Main() { Main_type = list_type, Main_hotblogs = moblogs, Main_tuiblogs = list_tuiblogs, Main_tell = list_tell, Main_img = list_img, name = session_user }; System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); string json = js.Serialize(main); context.Response.Write(json); }
//查询用户是否存在 public int ExistsUsers(Model.user users) { string sqlTest = "select count(*) from users where name=@name and pwd=@pwd"; SqlParameter[] par = new SqlParameter[2] { new SqlParameter("@name", users.Name), new SqlParameter("@pwd", users.Pwd) }; object obj = DBHelper.ExecuteScalar(sqlTest, par); return(int.Parse(obj.ToString()));//返回类型的完整名称并转化为32进制整型数 }
//session public SqlDataReader lo(Model.user u) { StringBuilder sql = new StringBuilder(); sql.Append("select * from [user] where _email=@email and _pwd=@pwd"); SqlParameter[] par = { new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@pwd", SqlDbType.VarChar, 50) }; par[0].Value = u.email; par[1].Value = Common.DESEncrypt.Encrypt(u.pwd); return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par)); }
//更改密码 public int upwd(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("update [user] set _pwd=@apwd where _user_id=@id "); SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@apwd", SqlDbType.VarChar, 50) }; par[0].Value = aa.userid; par[1].Value = Common.DESEncrypt.Encrypt(aa.pwd); return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par)); }
//记住上次登入时间时间 public int update(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("update [user] set _login_time=@time where _user_id=@id"); SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime, 16) }; par[0].Value = aa.userid; par[1].Value = aa.time; return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par)); }
//判断该密码是否正确 public SqlDataReader drpw(Model.user aa) { StringBuilder sql = new StringBuilder(); sql.Append("select * from [user] where _pwd=@pwd and _user_id=@id"); SqlParameter[] par = { new SqlParameter("@pwd", SqlDbType.VarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; par[0].Value = Common.DESEncrypt.Encrypt(aa.pwd); par[1].Value = aa.userid; return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par)); }
public async Task <user> Checkinfo(string Name, string Password, string Email, string City, string Mobile) { DataService service = new DataService(); user us = new Model.user(); us.Name = Name; us.Password = Password; us.Email = Email; us.City = City; us.Mobile = Mobile; user user = await service.createuser(us); Application.Current.Properties["userid"] = user.ID; return(user); }