public Boolean userIsImg_D(UserInfoE ue) { if (userIsExit_D(ue) == 1) { using (OleDbConnection olconn = new OleDbConnection(connStr)) { olconn.Open(); string sql = string.Format("select * from UserInfo where User_Name='{0}'", ue.UserName); OleDbCommand olcmd = new OleDbCommand(sql, olconn); OleDbDataReader oldr = olcmd.ExecuteReader(); oldr.Read(); if (Convert.ToInt32(oldr["User_IsImg"]) == 1) { return(true); } else { return(false); } } } else { return(false); } }
//注册用户 public Boolean addUserorUpdateUser_D(UserInfoE ue, string imgpath) { using (OleDbConnection olconn = new OleDbConnection(connStr)) { #region //string fullpath = imgpath;//文件路径 //FileStream fs = new FileStream(fullpath, FileMode.Open); //byte[] imagebytes = new byte[fs.Length]; //BinaryReader br = new BinaryReader(fs); //imagebytes = br.ReadBytes(Convert.ToInt32(fs.Length)); #endregion byte[] imagebytes = null; int count = 0; olconn.Open(); //如果用户未选择头像,则: if (imgpath == null) { string sql = string.Format("insert into UserInfo(User_Name,User_Pwd,User_Group,User_IsImg) values('{0}','{1}','0','0')", ue.UserName, ue.UserPwd); OleDbCommand olcmd = new OleDbCommand(sql, olconn); count = olcmd.ExecuteNonQuery(); } else//如果用户选择了头像,则: { //将图片转换成字节数组 Image photo = new Bitmap(ue.UserImg1); MemoryStream ms = new MemoryStream(); photo.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp); imagebytes = ms.GetBuffer(); string sql = string.Format("insert into UserInfo(User_Name,User_Pwd,User_Img,User_Group,User_IsImg) values(@User_Name,@User_Pwd,@User_Img,@User_Group,'1')"); OleDbCommand olcmd = new OleDbCommand(sql, olconn); olcmd.Parameters.Add("User_Name", SqlDbType.Text); olcmd.Parameters["User_Name"].Value = ue.UserName; olcmd.Parameters.Add("User_Pwd", SqlDbType.Text); olcmd.Parameters["User_Pwd"].Value = ue.UserPwd; olcmd.Parameters.Add("User_Img", SqlDbType.Image); olcmd.Parameters["User_Img"].Value = imagebytes; olcmd.Parameters.Add("User_Group", SqlDbType.Image); olcmd.Parameters["User_Group"].Value = "0"; count = olcmd.ExecuteNonQuery(); } if (count == 1) { return(true); } else { return(false); } } }
//在注册的时候验证用户是否已经存在 public int userIsExit_D(UserInfoE ue) { using (OleDbConnection olconn = new OleDbConnection(connStr)) { olconn.Open(); string sql = string.Format("select count(*) from UserInfo where User_Name='{0}'", ue.UserName); OleDbCommand olcmd = new OleDbCommand(sql, olconn); int count = Convert.ToInt32(olcmd.ExecuteScalar()); return(count); } }
/// <summary> /// 添加用户 /// </summary> /// <param name="ue">UserInfoE对象</param> /// <param name="imgpath">用户选择的头像路径</param> /// <returns></returns> public Boolean addUser(UserInfoE ue, string imgpath) { if (scd.addUserorUpdateUser_D(ue, imgpath)) { return(true); } else { return(false); } }
public Boolean userIsExit_B(UserInfoE ue) { if (scd.userIsExit_D(ue) == 1)//存在该用户返回真 { return(true); } else { return(false); } }
public Boolean userExit(UserInfoE ue) { if (scd.login(ue) == 1) { return(true); } else { return(false); } }
public Boolean UserIsImg_B(UserInfoE ue) { StuContact_D scd = new StuContact_D(); if (scd.userIsImg_D(ue)) { return(true); } else { return(false); } }