📄 user.cs
字号:
parm[5] = new SqlParameter("@Postcode", SqlDbType.NVarChar, 10);
parm[5].Value = ufi.Postcode;
parm[6] = new SqlParameter("@FaTel", SqlDbType.NVarChar, 30);
parm[6].Value = ufi.FaTel;
parm[7] = new SqlParameter("@WorkTel", SqlDbType.NVarChar, 30);
parm[7].Value = ufi.WorkTel;
parm[8] = new SqlParameter("@QQ", SqlDbType.NVarChar, 30);
parm[8].Value = ufi.QQ;
parm[9] = new SqlParameter("@MSN", SqlDbType.NVarChar, 150);
parm[9].Value = ufi.MSN;
parm[10] = new SqlParameter("@Fax", SqlDbType.NVarChar, 30);
parm[10].Value = ufi.Fax;
parm[11] = new SqlParameter("@character", SqlDbType.NText);
parm[11].Value = ufi.character;
parm[12] = new SqlParameter("@UserFan", SqlDbType.NText);
parm[12].Value = ufi.UserFan;
parm[13] = new SqlParameter("@Nation", SqlDbType.NVarChar, 12);
parm[13].Value = ufi.Nation;
parm[14] = new SqlParameter("@nativeplace", SqlDbType.NVarChar, 20);
parm[14].Value = ufi.nativeplace;
parm[15] = new SqlParameter("@Job", SqlDbType.NVarChar, 30);
parm[15].Value = ufi.Job;
parm[16] = new SqlParameter("@education", SqlDbType.NVarChar, 20);
parm[16].Value = ufi.education;
parm[17] = new SqlParameter("@Lastschool", SqlDbType.NVarChar, 80);
parm[17].Value = ufi.Lastschool;
parm[18] = new SqlParameter("@orgSch", SqlDbType.NVarChar, 10);
parm[18].Value = ufi.orgSch;
return parm;
}
public string sel_setPoint(string SiteID)
{
string _str = "0|0";
string Sql = "select setPoint from " + Pre + "sys_PramUser";
DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
if (rdr != null)
{
if (rdr.Rows.Count > 0)
{
_str = rdr.Rows[0]["setPoint"].ToString();
if (_str.IndexOf('|') == -1)
{
_str = "0|0";
}
}
rdr.Clear(); rdr.Dispose();
}
return _str;
}
public DataTable sel_reg(string SiteID)
{
string Sql = "select RegContent,regItem from " + Pre + "sys_PramUser";
return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
}
/// <summary>
/// 读取会员所在组允许上传的图片类型及大小
/// </summary>
/// <param name="groupNumber"></param>
public string getuserUpFile(string groupNumber)
{
SqlParameter param = new SqlParameter("@groupNumber", groupNumber);
string _STR = "jpg,gif,jpeg,bmp,png,swf,rar,zip|500|3";
string Sql = "select upfileType,upfileSize,DayUpfilenum from " + Pre + "user_Group where GroupNumber=@groupNumber";
DataTable dt = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
_STR = dt.Rows[0]["upfileType"].ToString() + "|" + dt.Rows[0]["upfileSize"].ToString() + "|" + dt.Rows[0]["DayUpfilenum"].ToString();
}
dt.Clear(); dt.Dispose();
}
return _STR;
}
/// <summary>
/// 得到用户注册时间
/// </summary>
/// <param name="UserNum"></param>
/// <returns></returns>
public string getRegTime(string UserNum)
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
string flg = "3000-1-1";
string SQL = "select RegTime from " + Pre + "sys_user where UserNum=@UserNum";
object obj = DbHelper.ExecuteScalar(CommandType.Text, SQL, param);
if (obj != null && obj != DBNull.Value)
{
flg = obj.ToString();
}
return flg;
}
/// <summary>
/// 得到会员的文章
/// </summary>
/// <param name="UserNum"></param>
/// <returns></returns>
public DataTable getContent(string UserNum)
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
string Sql = "select top 6 id,ConID,ClassID,Title,Content,creatTime,PicURL,isCheck from " + Pre + "user_Constr where UserNum=@UserNum order by id desc";
return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
}
/// <summary>
/// 得到会员的讨论组
/// </summary>
/// <param name="UserNum"></param>
/// <returns></returns>
public DataTable getGroup(string UserName)
{
SqlParameter param = new SqlParameter("@UserName", UserName);
string Sql = "select top 6 DisID,Cname,D_Content,Creatime from " + Pre + "user_Discuss where UserName=@UserName order by id desc";
return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
}
#region 得到wap
public DataTable getWapParam()
{
string Sql = "select top 1 WapTF,WapPath,WapDomain,WapLastNum from " + Pre + "sys_Pramother";
return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
}
public IDataReader getWapContent(string SiteID)
{
SqlParameter param = new SqlParameter("@SiteID", SiteID);
string Sql = "select id,NewsID,NewsTitle,CreatTime from " + Pre + "News where substring(NewsProperty,13,1)='1' and siteID=@SiteID order by id desc";
return DbHelper.ExecuteReader(CommandType.Text, Sql, param);
}
#endregion wap结束
/// <summary>
/// 构造会员参数
/// </summary>
/// <param name="ui">会员实体类</param>
/// <returns></returns>
public SqlParameter[] getUserInfo(NetCMS.Model.User ui)
{
SqlParameter[] parm = new SqlParameter[46];
parm[0] = new SqlParameter("@Id", SqlDbType.Int, 4);
parm[0].Value = ui.Id;
parm[1] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
parm[1].Value = ui.UserNum;
parm[2] = new SqlParameter("@UserName", SqlDbType.NVarChar, 18);
parm[2].Value = ui.UserName;
parm[3] = new SqlParameter("@UserPassword", SqlDbType.NVarChar, 32);
parm[3].Value = ui.UserPassword;
parm[4] = new SqlParameter("@NickName", SqlDbType.NVarChar, 20);
parm[4].Value = ui.NickName;
parm[5] = new SqlParameter("@RealName", SqlDbType.NVarChar, 20);
parm[5].Value = ui.RealName;
parm[6] = new SqlParameter("@isAdmin", SqlDbType.Int, 4);
parm[6].Value = ui.isAdmin;
parm[7] = new SqlParameter("@UserGroupNumber", SqlDbType.NVarChar, 12);
parm[7].Value = ui.UserGroupNumber;
parm[8] = new SqlParameter("@PassQuestion", SqlDbType.NVarChar, 20);
parm[8].Value = ui.PassQuestion;
parm[9] = new SqlParameter("@PassKey", SqlDbType.NVarChar, 20);
parm[9].Value = ui.PassKey;
parm[10] = new SqlParameter("@CertType", SqlDbType.NVarChar, 15);
parm[10].Value = ui.CertType;
parm[11] = new SqlParameter("@CertNumber", SqlDbType.NVarChar, 20);
parm[11].Value = ui.CertNumber;
parm[12] = new SqlParameter("@Email", SqlDbType.NVarChar, 220);
parm[12].Value = ui.Email;
parm[13] = new SqlParameter("@mobile", SqlDbType.NVarChar, 15);
parm[13].Value = ui.mobile;
parm[14] = new SqlParameter("@Sex", SqlDbType.Int, 4);
parm[14].Value = ui.Sex;
parm[15] = new SqlParameter("@birthday", SqlDbType.DateTime, 8);
parm[15].Value = ui.birthday;
parm[16] = new SqlParameter("@Userinfo", SqlDbType.NText);
parm[16].Value = ui.Userinfo;
parm[17] = new SqlParameter("@UserFace", SqlDbType.NVarChar, 220);
parm[17].Value = ui.UserFace;
parm[18] = new SqlParameter("@userFacesize", SqlDbType.NVarChar, 8);
parm[18].Value = ui.userFacesize;
parm[19] = new SqlParameter("@marriage", SqlDbType.Int, 4);
parm[19].Value = ui.marriage;
parm[20] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
parm[20].Value = ui.iPoint;
parm[21] = new SqlParameter("@gPoint", SqlDbType.Int, 4);
parm[21].Value = ui.gPoint;
parm[22] = new SqlParameter("@cPoint", SqlDbType.Int, 4);
parm[22].Value = ui.cPoint;
parm[23] = new SqlParameter("@ePoint", SqlDbType.Int, 4);
parm[23].Value = ui.ePoint;
parm[24] = new SqlParameter("@aPoint", SqlDbType.Int, 4);
parm[24].Value = ui.aPoint;
parm[25] = new SqlParameter("@isLock", SqlDbType.Int, 4);
parm[25].Value = ui.isLock;
parm[26] = new SqlParameter("@RegTime", SqlDbType.DateTime, 8);
parm[26].Value = ui.RegTime;
parm[27] = new SqlParameter("@LastLoginTime", SqlDbType.DateTime, 8);
parm[27].Value = ui.LastLoginTime;
parm[28] = new SqlParameter("@OnlineTime", SqlDbType.Int, 4);
parm[28].Value = ui.OnlineTime;
parm[29] = new SqlParameter("@OnlineTF", SqlDbType.Int, 4);
parm[29].Value = ui.OnlineTF;
parm[30] = new SqlParameter("@LoginNumber", SqlDbType.Int, 4);
parm[30].Value = ui.LoginNumber;
parm[31] = new SqlParameter("@FriendClass", SqlDbType.NVarChar, 50);
parm[31].Value = ui.FriendClass;
parm[32] = new SqlParameter("@LoginLimtNumber", SqlDbType.Int, 4);
parm[32].Value = ui.LoginLimtNumber;
parm[33] = new SqlParameter("@LastIP", SqlDbType.NVarChar, 16);
parm[33].Value = ui.LastIP;
parm[34] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
parm[34].Value = ui.SiteID;
parm[35] = new SqlParameter("@Addfriend", SqlDbType.Int, 4);
parm[35].Value = ui.Addfriend;
parm[36] = new SqlParameter("@isOpen", SqlDbType.Int, 4);
parm[36].Value = ui.isOpen;
parm[37] = new SqlParameter("@ParmConstrNum", SqlDbType.Int, 4);
parm[37].Value = ui.ParmConstrNum;
parm[38] = new SqlParameter("@isIDcard", SqlDbType.Int, 4);
parm[38].Value = ui.isIDcard;
parm[39] = new SqlParameter("@IDcardFiles", SqlDbType.NVarChar, 220);
parm[39].Value = ui.IDcardFiles;
parm[40] = new SqlParameter("@Addfriendbs", SqlDbType.Int, 4);
parm[40].Value = ui.Addfriendbs;
parm[41] = new SqlParameter("@EmailATF", SqlDbType.Int, 4);
parm[41].Value = ui.EmailATF;
parm[42] = new SqlParameter("@EmailCode", SqlDbType.NVarChar, 32);
parm[42].Value = ui.EmailCode;
parm[43] = new SqlParameter("@isMobile", SqlDbType.Int, 4);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -