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