📄 user.cs
字号:
#endregion
/// <summary>
/// 查询用户密码是否正确
/// </summary>
/// <param name="UserNum"></param>
/// <returns></returns>
public string sel_pwd(string UserNum)
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
string Sql = "Select UserPassword From " + Pre + "sys_User where UserNum=@UserNum";
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
}
/// <summary>
/// 登陆会员所在的会员组的过期时间
/// </summary>
/// <param name="GroupName"></param>
/// <returns></returns>
public int sel_Rtime(string GroupName)
{
SqlParameter param = new SqlParameter("@GroupName", GroupName);
string Sql = "select Rtime from " + Pre + "user_Group where GroupNumber=@GroupName";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
}
/// <summary>
/// 得到用户所在的会员组编号
/// </summary>
/// <param name="UserNum"></param>
/// <returns></returns>
public string sel_UserGroupNumber(string UserNum)
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
string Sql = "select UserGroupNumber from " + Pre + "sys_user where UserNum=@UserNum";
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
}
/// <summary>
/// 前台会员注册
/// </summary>
public int sel_ChannelID(string SiteID)
{
SqlParameter param = new SqlParameter("@SiteID", SiteID);
string Sql = "select count(*) from " + Pre + "news_site where ChannelID=@SiteID";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
}
int IUser.GetUncheckFriendsCount(string UserName)
{
SqlParameter param = new SqlParameter("@bUsername", UserName);
string Sql = "select count(*) from " + Pre + "User_Requestinformation where bUsername=@bUsername and ischick=1";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
}
/// <summary>
/// 注册会员协议
/// </summary>
/// <param name="SiteID"></param>
/// <returns></returns>
public DataTable sel_RegContent(string SiteID)
{
string Sql = "select RegContent,regItem,returnemail,returnmobile,RegTF from " + Pre + "sys_PramUser";
return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
}
/// <summary>
/// 得到用户名是否被占用
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public int sel_username(string ID)
{
SqlParameter param = new SqlParameter("@UserName", ID);
string Sql = "select Id from " + Pre + "sys_User where UserName=@UserName";
return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
}
/// <summary>
/// 得到会员编号是否重复
/// </summary>
/// <returns></returns>
public string sel_um()
{
string Sql = "select UserNum from " + Pre + "sys_User";
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, null));
}
public string sel_UserGroupNumbers(string SiteID)
{
string Sql = "select RegGroupNumber from " + Pre + "sys_PramUser";
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, null));
}
public int sel_getUserMobileBindTF(string Moblie)
{
SqlParameter param = new SqlParameter("@Moblie", Moblie);
int intflg = 0;
string Sql = "select ID from " + Pre + "sys_User where BindTF=1 and mobile=@Moblie";
object obj = DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
if (obj != null && obj != DBNull.Value)
{
intflg = 1;
}
return intflg;
}
/// <summary>
/// 捆绑手机
/// </summary>
/// <param name="UserName"></param>
public void sel_updateMobileBindTF(string UserName)
{
SqlParameter param = new SqlParameter("@UserName", UserName);
string Sql = "Update " + Pre + "sys_User set BindTF=1 where UserName=@UserName";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
/// <summary>
/// 得到手机验证码
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public bool sel_getUserMobileCode(string UserName, out string mobile, out string mobilecode)
{
mobile = string.Empty;
mobilecode = string.Empty;
bool flag = false;
SqlParameter param = new SqlParameter("@UserName", UserName);
string Sql = "select isMobile,mobile,MobileCode from " + Pre + "sys_User where UserName=@UserName";
IDataReader rd = DbHelper.ExecuteReader(CommandType.Text, Sql, param);
if (rd.Read())
{
if (!rd.IsDBNull(0) && rd.GetByte(0) != 0X00)
flag = true;
if (!rd.IsDBNull(1))
mobile = rd.GetString(1);
if (!rd.IsDBNull(2))
mobilecode = rd.GetString(2);
}
rd.Close();
return flag;
}
/// <summary>
/// 更新手机状态
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public int sel_updateUserMobileStat(string UserName)
{
SqlParameter param = new SqlParameter("@UserName", UserName);
string Sql = "update " + Pre + "sys_User Set isMobile=1 where UserName=@UserName";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
/// <summary>
/// 创建用户到数据库中
/// </summary>
/// <param name="su"></param>
/// <returns></returns>
public int Add_User(NetCMS.Model.User ui)
{
SqlParameter[] param = getUserInfo(ui);
string Sql = "Insert Into " + Pre + "sys_User (UserNum,UserName,UserPassword,NickName,RealName,isAdmin," +
"UserGroupNumber,PassQuestion,PassKey,CertType,CertNumber,Email,mobile,Sex,birthday,Userinfo," +
"UserFace,userFacesize,marriage,iPoint,gPoint,cPoint,ePoint,aPoint,isLock,RegTime,LastLoginTime," +
"OnlineTime,OnlineTF,LoginNumber,FriendClass,LoginLimtNumber,LastIP,SiteID,Addfriend,isOpen," +
"ParmConstrNum,isIDcard,IDcardFiles,Addfriendbs,EmailATF,EmailCode,isMobile,BindTF,MobileCode) " +
"Values" +
"(@UserNum,@UserName,@UserPassword,@NickName,@RealName,@isAdmin,@UserGroupNumber,@PassQuestion," +
"@PassKey,@CertType,@CertNumber,@Email,@mobile,@Sex,@birthday,@Userinfo,@UserFace,@userFacesize," +
"@marriage,@iPoint,@gPoint,@cPoint,@ePoint,@aPoint,@isLock,@RegTime,@LastLoginTime,@OnlineTime," +
"@OnlineTF,@LoginNumber,@FriendClass,@LoginLimtNumber,@LastIP,@SiteID,@Addfriend,@isOpen," +
"@ParmConstrNum,@isIDcard,@IDcardFiles,@Addfriendbs,@EmailATF,@EmailCode,@isMobile,@BindTF,@MobileCode)";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
/// <summary>
/// 创建用户附表
/// </summary>
/// <param name="suf"></param>
/// <param name="UserNum"></param>
/// <returns></returns>
public int Add_userfields(NetCMS.Model.UserFields ufi)
{
SqlParameter[] param = getUuserfields(ufi);
string Sql = "insert into " + Pre + "sys_userfields (UserNum,province,City,Address,Postcode,FaTel,WorkTel," +
"QQ,MSN,Fax,character,UserFan,Nation,nativeplace,Job,education,Lastschool,orgSch) " +
"values" +
"(@userNum,@province,@City,@Address,@Postcode,@FaTel,@WorkTel,@QQ,@MSN,@Fax,@character,@UserFan," +
"@Nation,@nativeplace,@Job,@education,@Lastschool,@orgSch)";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
/// <summary>
/// 插入收入支出历史
/// </summary>
/// <param name="ugi"></param>
/// <returns></returns>
public int Add_Ghistory(NetCMS.Model.UserGhistory ugi)
{
SqlParameter[] param = getUserGhistory(ugi);
string Sql = "insert into " + Pre + "User_Ghistory(GhID,ghtype,Gpoint,iPoint,Money,CreatTime,UserNUM,gtype," +
"content,SiteID) values(@GhID,@ghtype,@Gpoint,@iPoint,@Money,@CreatTime,@userNum,@gtype,@content,@SiteID)";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
private SqlParameter[] getUserGhistory(NetCMS.Model.UserGhistory ugi)
{
SqlParameter[] parm = new SqlParameter[11];
parm[0] = new SqlParameter("@id", SqlDbType.Int, 4);
parm[0].Value = ugi.Id;
parm[1] = new SqlParameter("@GhID", SqlDbType.NVarChar, 12);
parm[1].Value = ugi.GhID;
parm[2] = new SqlParameter("@ghtype", SqlDbType.Int, 4);
parm[2].Value = ugi.ghtype;
parm[3] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
parm[3].Value = ugi.Gpoint;
parm[4] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
parm[4].Value = ugi.iPoint;
parm[5] = new SqlParameter("@Money", SqlDbType.Money, 8);
parm[5].Value = ugi.Money;
parm[6] = new SqlParameter("@CreatTime", SqlDbType.DateTime, 8);
parm[6].Value = ugi.CreatTime;
parm[7] = new SqlParameter("@userNum", SqlDbType.NVarChar, 12);
parm[7].Value = ugi.userNum;
parm[8] = new SqlParameter("@gtype", SqlDbType.Int, 4);
parm[8].Value = ugi.gtype;
parm[9] = new SqlParameter("@content", SqlDbType.NText);
parm[9].Value = ugi.content;
parm[10] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
parm[10].Value = ugi.SiteID;
return parm;
}
private SqlParameter[] getUuserfields(NetCMS.Model.UserFields ufi)
{
SqlParameter[] parm = new SqlParameter[19];
parm[0] = new SqlParameter("@id", SqlDbType.Int, 4);
parm[0].Value = ufi.ID;
parm[1] = new SqlParameter("@userNum", SqlDbType.NVarChar, 15);
parm[1].Value = ufi.userNum;
parm[2] = new SqlParameter("@province", SqlDbType.NVarChar, 20);
parm[2].Value = ufi.province;
parm[3] = new SqlParameter("@City", SqlDbType.NVarChar, 20);
parm[3].Value = ufi.City;
parm[4] = new SqlParameter("@Address", SqlDbType.NVarChar, 50);
parm[4].Value = ufi.Address;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -