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);
}
