/// <summary>
/// 获取当前用户的登录状态
/// </summary>
/// <param name="type">0：Head.html，1：HongRenHui下的Head.html</param>
/// <returns></returns>
private string GetUserLoginState(int type)
{
StringBuilder head_html = new StringBuilder();
var http_url = "javascript:void(0);";
int user_id = 0;
if (type == 0)
{
user_id = GetCurUserID();
}
else if (type == 1)
{
user_id = GetCurUserID_HongRenHui();
}
if (user_id == 0)
{
if (type == 0)
{
#region 类型0
head_html.AppendFormat("<div class=\"login-box\">");
head_html.AppendFormat("<a href=\"/userlogin/login\" title=\"登录\">登录</a>");
//head_html.AppendFormat("<a href=\"javascript:void(0)\" title=\"登录\" class=\"thirdlogin\">登录</a>");
head_html.AppendFormat("<i>丨</i>");
head_html.AppendFormat("<a href=\"/userlogin/register\" title=\"注册\">注册</a>");
head_html.AppendFormat("</div>");
#endregion
}
else if (type == 1)
{
#region 类型0
//head_html.AppendFormat("<div class=\"opera-box\">");
////head_html.AppendFormat("<span><a href=\"javascript:void(0)\" title=\"QQ\" id=\"qqLoginBtn\">QQ</a></span>");
//head_html.AppendFormat("<span><a class=\"login\" href=\"/login\" title=\"登录\">登录</a></span>");
////head_html.AppendFormat("<span><a class=\"login\" href=\"javascript:;\" title=\"登录\" onclick=\"returnlogin()\">登录</a></span>");
//head_html.AppendFormat("<span>");
//head_html.AppendFormat("<a href=\"/register\" title=\"注册\">注册</a>");
//head_html.AppendFormat("</span>");
//head_html.AppendFormat("<span class=\"hrcolor\">");
//head_html.AppendFormat("<a href=\"/report\" title=\"红人求报道\">红人求报道</a>");
//head_html.AppendFormat("</span>");
//head_html.AppendFormat("<span class=\"hrcolor\">");
//head_html.AppendFormat("<a href=\"/hrip\" title=\"入驻红人爱品\">入驻红人爱品</a>");
//head_html.AppendFormat("</span>");
//head_html.AppendFormat("</div>");
head_html.AppendFormat("<div class=\"login\"><a href=\"/login\" title=\"登录\">登录</a><a href=\"/register\" title=\"注册\">注册</a></div>");
#endregion
}
}
else
{
NewXzc.Model.RED_USER user_model_head = user_bll_h.GetModel(user_id);
if (user_model_head != null)
{
if (type == 0)
{
#region 类型0
string nickname = user_model_head.USERNAME;
head_html.AppendFormat("<div class=\"login-box\">");
head_html.AppendFormat("<a class=\"user-center\" href=\"/people_c\" title=\"{0}\">", nickname);
head_html.AppendFormat("<span>");
head_html.AppendFormat("<img src=\"{0}\" height=\"28\" width=\"28\" alt=\"{1}\">", ImgHelper.Return_User_Head(user_model_head.USER_HEAD, 3), nickname);
head_html.AppendFormat("</span>");
head_html.AppendFormat("<em>{0}</em>", StringHelper.ReturnNumStr(nickname, 0, 7));
head_html.AppendFormat("</a>");
head_html.AppendFormat("<a href=\"/userlogin/logout\" title=\"退出\">退出</a>");
head_html.AppendFormat("</div>");
#endregion
}
else if (type == 1)
{
#region 类型0
string nickname = user_model_head.USERNAME;
//head_html.AppendFormat("<div class=\"opera-box login-box\">");
//head_html.AppendFormat("<a class=\"user-center\" href=\"/people_c\" title=\"{0}\">", nickname);
//head_html.AppendFormat("<span>");
//head_html.AppendFormat("<img src=\"{0}\" height=\"28\" width=\"28\" alt=\"{1}\">", ImgHelper.Return_User_Head(user_model_head.USER_HEAD, 3), nickname);
//head_html.AppendFormat("</span>");
//head_html.AppendFormat("<em>{0}</em>", StringHelper.ReturnNumStr(nickname, 0, 7));
//head_html.AppendFormat("</a>");
//head_html.AppendFormat("<a href=\"/logout\" title=\"退出\">退出</a>");
////head_html.AppendFormat("<span>");
////head_html.AppendFormat("<a href=\"/report\" title=\"红人求报道\">红人求报道</a>");
////head_html.AppendFormat("</span>");
//head_html.AppendFormat("</div>");
head_html.AppendFormat("<div class=\"out\"><a href=\"/logout\" title=\"退出\" class=\"tc\">退出</a><a href=\"/people_c\" title=\"{0}\" class=\"name\">{0}</a></div>", nickname);
#endregion
}
}
else
{
HttpContext.Current.Response.Redirect("/404");
}
}
return(head_html.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="USERID">用户USERID</param>
/// <returns></returns>
public NewXzc.Model.RED_USER GetModel(int USERID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,USERID,USERNAME,PWD,TEL,TEL_STATE,USER_HEAD,SEX,EMAIL,USER_TYPE,ISCOMPLETE,PROVINCE,CITY,AREA,PEOPLE_IDENTITY,OCCUPATION,PERSONALITY,INTRODUCE,IDENTIFICATION_STATE,SAME_HOBBY_PEOPLE,EXP,SCORE,REALM_NAME,ADDTIME,IS_RED,STATE,REMARK,Person_Desc,Person_NickName,Porder,UpdateTime,PLAT_VAL,SPECIALTY_VAL,IPURL from RED_USER ");
strSql.Append(" where USERID=@USERID order by userid asc");
SqlParameter[] parameters =
{
new SqlParameter("@USERID", SqlDbType.Int, 4)
};
parameters[0].Value = USERID;
NewXzc.Model.RED_USER model = new NewXzc.Model.RED_USER();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["USERID"] != null && ds.Tables[0].Rows[0]["USERID"].ToString() != "")
{
model.USERID = int.Parse(ds.Tables[0].Rows[0]["USERID"].ToString());
}
if (ds.Tables[0].Rows[0]["USERNAME"] != null && ds.Tables[0].Rows[0]["USERNAME"].ToString() != "")
{
model.USERNAME = ds.Tables[0].Rows[0]["USERNAME"].ToString();
}
if (ds.Tables[0].Rows[0]["PWD"] != null && ds.Tables[0].Rows[0]["PWD"].ToString() != "")
{
model.PWD = ds.Tables[0].Rows[0]["PWD"].ToString();
}
if (ds.Tables[0].Rows[0]["TEL"] != null && ds.Tables[0].Rows[0]["TEL"].ToString() != "")
{
model.TEL = ds.Tables[0].Rows[0]["TEL"].ToString();
}
if (ds.Tables[0].Rows[0]["TEL_STATE"] != null && ds.Tables[0].Rows[0]["TEL_STATE"].ToString() != "")
{
model.TEL_STATE = int.Parse(ds.Tables[0].Rows[0]["TEL_STATE"].ToString());
}
if (ds.Tables[0].Rows[0]["USER_HEAD"] != null && ds.Tables[0].Rows[0]["USER_HEAD"].ToString() != "")
{
model.USER_HEAD = ds.Tables[0].Rows[0]["USER_HEAD"].ToString();
}
if (ds.Tables[0].Rows[0]["SEX"] != null && ds.Tables[0].Rows[0]["SEX"].ToString() != "")
{
model.SEX = int.Parse(ds.Tables[0].Rows[0]["SEX"].ToString());
}
if (ds.Tables[0].Rows[0]["EMAIL"] != null && ds.Tables[0].Rows[0]["EMAIL"].ToString() != "")
{
model.EMAIL = ds.Tables[0].Rows[0]["EMAIL"].ToString();
}
if (ds.Tables[0].Rows[0]["USER_TYPE"] != null && ds.Tables[0].Rows[0]["USER_TYPE"].ToString() != "")
{
model.USER_TYPE = int.Parse(ds.Tables[0].Rows[0]["USER_TYPE"].ToString());
}
if (ds.Tables[0].Rows[0]["ISCOMPLETE"] != null && ds.Tables[0].Rows[0]["ISCOMPLETE"].ToString() != "")
{
model.ISCOMPLETE = int.Parse(ds.Tables[0].Rows[0]["ISCOMPLETE"].ToString());
}
if (ds.Tables[0].Rows[0]["PROVINCE"] != null && ds.Tables[0].Rows[0]["PROVINCE"].ToString() != "")
{
model.PROVINCE = ds.Tables[0].Rows[0]["PROVINCE"].ToString();
}
if (ds.Tables[0].Rows[0]["CITY"] != null && ds.Tables[0].Rows[0]["CITY"].ToString() != "")
{
model.CITY = ds.Tables[0].Rows[0]["CITY"].ToString();
}
if (ds.Tables[0].Rows[0]["AREA"] != null && ds.Tables[0].Rows[0]["AREA"].ToString() != "")
{
model.AREA = ds.Tables[0].Rows[0]["AREA"].ToString();
}
if (ds.Tables[0].Rows[0]["PEOPLE_IDENTITY"] != null && ds.Tables[0].Rows[0]["PEOPLE_IDENTITY"].ToString() != "")
{
model.PEOPLE_IDENTITY = ds.Tables[0].Rows[0]["PEOPLE_IDENTITY"].ToString();
}
if (ds.Tables[0].Rows[0]["OCCUPATION"] != null && ds.Tables[0].Rows[0]["OCCUPATION"].ToString() != "")
{
model.OCCUPATION = ds.Tables[0].Rows[0]["OCCUPATION"].ToString();
}
if (ds.Tables[0].Rows[0]["PERSONALITY"] != null && ds.Tables[0].Rows[0]["PERSONALITY"].ToString() != "")
{
model.PERSONALITY = ds.Tables[0].Rows[0]["PERSONALITY"].ToString();
}
if (ds.Tables[0].Rows[0]["INTRODUCE"] != null && ds.Tables[0].Rows[0]["INTRODUCE"].ToString() != "")
{
model.INTRODUCE = ds.Tables[0].Rows[0]["INTRODUCE"].ToString();
}
if (ds.Tables[0].Rows[0]["IDENTIFICATION_STATE"] != null && ds.Tables[0].Rows[0]["IDENTIFICATION_STATE"].ToString() != "")
{
model.IDENTIFICATION_STATE = int.Parse(ds.Tables[0].Rows[0]["IDENTIFICATION_STATE"].ToString());
}
if (ds.Tables[0].Rows[0]["SAME_HOBBY_PEOPLE"] != null && ds.Tables[0].Rows[0]["SAME_HOBBY_PEOPLE"].ToString() != "")
{
model.SAME_HOBBY_PEOPLE = ds.Tables[0].Rows[0]["SAME_HOBBY_PEOPLE"].ToString();
}
if (ds.Tables[0].Rows[0]["EXP"] != null && ds.Tables[0].Rows[0]["EXP"].ToString() != "")
{
model.EXP = int.Parse(ds.Tables[0].Rows[0]["EXP"].ToString());
}
if (ds.Tables[0].Rows[0]["SCORE"] != null && ds.Tables[0].Rows[0]["SCORE"].ToString() != "")
{
model.SCORE = int.Parse(ds.Tables[0].Rows[0]["SCORE"].ToString());
}
if (ds.Tables[0].Rows[0]["REALM_NAME"] != null && ds.Tables[0].Rows[0]["REALM_NAME"].ToString() != "")
{
model.REALM_NAME = ds.Tables[0].Rows[0]["REALM_NAME"].ToString();
}
if (ds.Tables[0].Rows[0]["ADDTIME"] != null && ds.Tables[0].Rows[0]["ADDTIME"].ToString() != "")
{
model.ADDTIME = DateTime.Parse(ds.Tables[0].Rows[0]["ADDTIME"].ToString());
}
if (ds.Tables[0].Rows[0]["IS_RED"] != null && ds.Tables[0].Rows[0]["IS_RED"].ToString() != "")
{
model.IS_RED = int.Parse(ds.Tables[0].Rows[0]["IS_RED"].ToString());
}
if (ds.Tables[0].Rows[0]["STATE"] != null && ds.Tables[0].Rows[0]["STATE"].ToString() != "")
{
model.STATE = int.Parse(ds.Tables[0].Rows[0]["STATE"].ToString());
}
if (ds.Tables[0].Rows[0]["REMARK"] != null && ds.Tables[0].Rows[0]["REMARK"].ToString() != "")
{
model.REMARK = ds.Tables[0].Rows[0]["REMARK"].ToString();
}
if (ds.Tables[0].Rows[0]["Person_Desc"] != null && ds.Tables[0].Rows[0]["Person_Desc"].ToString() != "")
{
model.Person_Desc = ds.Tables[0].Rows[0]["Person_Desc"].ToString();
}
if (ds.Tables[0].Rows[0]["Person_NickName"] != null && ds.Tables[0].Rows[0]["Person_NickName"].ToString() != "")
{
model.Person_NickName = ds.Tables[0].Rows[0]["Person_NickName"].ToString();
}
if (ds.Tables[0].Rows[0]["Porder"] != null && ds.Tables[0].Rows[0]["Porder"].ToString() != "")
{
model.Porder = int.Parse(ds.Tables[0].Rows[0]["Porder"].ToString());
}
if (ds.Tables[0].Rows[0]["UpdateTime"] != null && ds.Tables[0].Rows[0]["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["PLAT_VAL"] != null && ds.Tables[0].Rows[0]["PLAT_VAL"].ToString() != "")
{
model.PLAT_VAL = ds.Tables[0].Rows[0]["PLAT_VAL"].ToString();
}
if (ds.Tables[0].Rows[0]["SPECIALTY_VAL"] != null && ds.Tables[0].Rows[0]["SPECIALTY_VAL"].ToString() != "")
{
model.SPECIALTY_VAL = ds.Tables[0].Rows[0]["SPECIALTY_VAL"].ToString();
}
if (ds.Tables[0].Rows[0]["IPURL"] != null && ds.Tables[0].Rows[0]["IPURL"].ToString() != "")
{
model.IPURL = ds.Tables[0].Rows[0]["IPURL"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(NewXzc.Model.RED_USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RED_USER(");
strSql.Append("USERID,USERNAME,PWD,TEL,TEL_STATE,USER_HEAD,SEX,EMAIL,USER_TYPE,ISCOMPLETE,PROVINCE,CITY,AREA,PEOPLE_IDENTITY,OCCUPATION,PERSONALITY,INTRODUCE,IDENTIFICATION_STATE,SAME_HOBBY_PEOPLE,EXP,SCORE,REALM_NAME,ADDTIME,IS_RED,STATE,REMARK,Person_Desc,Person_NickName,Porder,UpdateTime,PLAT_VAL,SPECIALTY_VAL,IPURL)");
strSql.Append(" values (");
strSql.Append("@USERID,@USERNAME,@PWD,@TEL,@TEL_STATE,@USER_HEAD,@SEX,@EMAIL,@USER_TYPE,@ISCOMPLETE,@PROVINCE,@CITY,@AREA,@PEOPLE_IDENTITY,@OCCUPATION,@PERSONALITY,@INTRODUCE,@IDENTIFICATION_STATE,@SAME_HOBBY_PEOPLE,@EXP,@SCORE,@REALM_NAME,@ADDTIME,@IS_RED,@STATE,@REMARK,@Person_Desc,@Person_NickName,@Porder,@UpdateTime,@PLAT_VAL,@SPECIALTY_VAL,@IPURL)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@USERID", SqlDbType.Int, 4),
new SqlParameter("@USERNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@PWD", SqlDbType.NVarChar, 100),
new SqlParameter("@TEL", SqlDbType.NVarChar, 50),
new SqlParameter("@TEL_STATE", SqlDbType.Int, 4),
new SqlParameter("@USER_HEAD", SqlDbType.NVarChar, 100),
new SqlParameter("@SEX", SqlDbType.Int, 4),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 100),
new SqlParameter("@USER_TYPE", SqlDbType.Int, 4),
new SqlParameter("@ISCOMPLETE", SqlDbType.Int, 4),
new SqlParameter("@PROVINCE", SqlDbType.NVarChar, 50),
new SqlParameter("@CITY", SqlDbType.NVarChar, 50),
new SqlParameter("@AREA", SqlDbType.NVarChar, 50),
new SqlParameter("@PEOPLE_IDENTITY", SqlDbType.NVarChar, 200),
new SqlParameter("@OCCUPATION", SqlDbType.NVarChar, 200),
new SqlParameter("@PERSONALITY", SqlDbType.NVarChar, 200),
new SqlParameter("@INTRODUCE", SqlDbType.NVarChar, 1000),
new SqlParameter("@IDENTIFICATION_STATE", SqlDbType.Int, 4),
new SqlParameter("@SAME_HOBBY_PEOPLE", SqlDbType.NVarChar, 1000),
new SqlParameter("@EXP", SqlDbType.Int, 4),
new SqlParameter("@SCORE", SqlDbType.Int, 4),
new SqlParameter("@REALM_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ADDTIME", SqlDbType.DateTime),
new SqlParameter("@IS_RED", SqlDbType.Int, 4),
new SqlParameter("@STATE", SqlDbType.Int, 4),
new SqlParameter("@REMARK", SqlDbType.NVarChar, 50),
new SqlParameter("@Person_Desc", SqlDbType.NVarChar, 3000),
new SqlParameter("@Person_NickName", SqlDbType.NVarChar, 50),
new SqlParameter("@Porder", SqlDbType.Int, 4),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@PLAT_VAL", SqlDbType.NVarChar, 200),
new SqlParameter("@SPECIALTY_VAL", SqlDbType.NVarChar, 200),
new SqlParameter("@IPURL", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.USERID;
parameters[1].Value = model.USERNAME;
parameters[2].Value = model.PWD;
parameters[3].Value = model.TEL;
parameters[4].Value = model.TEL_STATE;
parameters[5].Value = model.USER_HEAD;
parameters[6].Value = model.SEX;
parameters[7].Value = model.EMAIL;
parameters[8].Value = model.USER_TYPE;
parameters[9].Value = model.ISCOMPLETE;
parameters[10].Value = model.PROVINCE;
parameters[11].Value = model.CITY;
parameters[12].Value = model.AREA;
parameters[13].Value = model.PEOPLE_IDENTITY;
parameters[14].Value = model.OCCUPATION;
parameters[15].Value = model.PERSONALITY;
parameters[16].Value = model.INTRODUCE;
parameters[17].Value = model.IDENTIFICATION_STATE;
parameters[18].Value = model.SAME_HOBBY_PEOPLE;
parameters[19].Value = model.EXP;
parameters[20].Value = model.SCORE;
parameters[21].Value = model.REALM_NAME;
parameters[22].Value = model.ADDTIME;
parameters[23].Value = model.IS_RED;
parameters[24].Value = model.STATE;
parameters[25].Value = model.REMARK;
parameters[26].Value = model.Person_Desc;
parameters[27].Value = model.Person_NickName;
parameters[28].Value = model.Porder;
parameters[29].Value = model.UpdateTime;
parameters[30].Value = model.PLAT_VAL;
parameters[31].Value = model.SPECIALTY_VAL;
parameters[32].Value = model.IPURL;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
bool f = true;
if (obj == null)
{
f = false;
}
else
{
if (Convert.ToInt32(obj.ToString()) <= 0)
{
f = false;
}
}
return(f);
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="model">用户信息Model</param>
/// <param name="type">执行操作类型，0：全部修改，1：修改用户头像和昵称，2：修改密码</param>
/// <returns></returns>
public bool Update(NewXzc.Model.RED_USER model, int type = 0)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RED_USER set ");
strSql.Append("USERID=@USERID,");
strSql.Append("USERNAME=@USERNAME,");
strSql.Append("PWD=@PWD,");
strSql.Append("TEL=@TEL,");
strSql.Append("TEL_STATE=@TEL_STATE,");
strSql.Append("USER_HEAD=@USER_HEAD,");
strSql.Append("SEX=@SEX,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("USER_TYPE=@USER_TYPE,");
strSql.Append("ISCOMPLETE=@ISCOMPLETE,");
strSql.Append("PROVINCE=@PROVINCE,");
strSql.Append("CITY=@CITY,");
strSql.Append("AREA=@AREA,");
strSql.Append("PEOPLE_IDENTITY=@PEOPLE_IDENTITY,");
strSql.Append("OCCUPATION=@OCCUPATION,");
strSql.Append("PERSONALITY=@PERSONALITY,");
strSql.Append("INTRODUCE=@INTRODUCE,");
strSql.Append("IDENTIFICATION_STATE=@IDENTIFICATION_STATE,");
strSql.Append("SAME_HOBBY_PEOPLE=@SAME_HOBBY_PEOPLE,");
strSql.Append("EXP=@EXP,");
strSql.Append("SCORE=@SCORE,");
strSql.Append("REALM_NAME=@REALM_NAME,");
strSql.Append("ADDTIME=@ADDTIME,");
strSql.Append("IS_RED=@IS_RED,");
strSql.Append("STATE=@STATE,");
strSql.Append("REMARK=@REMARK,");
strSql.Append("Person_Desc=@Person_Desc,");
strSql.Append("Person_NickName=@Person_NickName,");
strSql.Append("Porder=@Porder,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("PLAT_VAL=@PLAT_VAL,");
strSql.Append("SPECIALTY_VAL=@SPECIALTY_VAL,");
strSql.Append("IPURL=@IPURL");
strSql.Append(" where USERID=@USERID");
//strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@USERID", SqlDbType.Int, 4),
new SqlParameter("@USERNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@PWD", SqlDbType.NVarChar, 100),
new SqlParameter("@TEL", SqlDbType.NVarChar, 50),
new SqlParameter("@TEL_STATE", SqlDbType.Int, 4),
new SqlParameter("@USER_HEAD", SqlDbType.NVarChar, 100),
new SqlParameter("@SEX", SqlDbType.Int, 4),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 100),
new SqlParameter("@USER_TYPE", SqlDbType.Int, 4),
new SqlParameter("@ISCOMPLETE", SqlDbType.Int, 4),
new SqlParameter("@PROVINCE", SqlDbType.NVarChar, 50),
new SqlParameter("@CITY", SqlDbType.NVarChar, 50),
new SqlParameter("@AREA", SqlDbType.NVarChar, 50),
new SqlParameter("@PEOPLE_IDENTITY", SqlDbType.NVarChar, 200),
new SqlParameter("@OCCUPATION", SqlDbType.NVarChar, 200),
new SqlParameter("@PERSONALITY", SqlDbType.NVarChar, 200),
new SqlParameter("@INTRODUCE", SqlDbType.NVarChar, 1000),
new SqlParameter("@IDENTIFICATION_STATE", SqlDbType.Int, 4),
new SqlParameter("@SAME_HOBBY_PEOPLE", SqlDbType.NVarChar, 1000),
new SqlParameter("@EXP", SqlDbType.Int, 4),
new SqlParameter("@SCORE", SqlDbType.Int, 4),
new SqlParameter("@REALM_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ADDTIME", SqlDbType.DateTime),
new SqlParameter("@IS_RED", SqlDbType.Int, 4),
new SqlParameter("@STATE", SqlDbType.Int, 4),
new SqlParameter("@REMARK", SqlDbType.NVarChar, 50),
new SqlParameter("@Person_Desc", SqlDbType.NVarChar, 3000),
new SqlParameter("@Person_NickName", SqlDbType.NVarChar, 50),
new SqlParameter("@Porder", SqlDbType.Int, 4),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@PLAT_VAL", SqlDbType.NVarChar, 200),
new SqlParameter("@SPECIALTY_VAL", SqlDbType.NVarChar, 200),
new SqlParameter("@IPURL", SqlDbType.NVarChar, 200)
//,
//new SqlParameter("@ID", SqlDbType.Int,4)
};
parameters[0].Value = model.USERID;
parameters[1].Value = model.USERNAME;
parameters[2].Value = model.PWD;
parameters[3].Value = model.TEL;
parameters[4].Value = model.TEL_STATE;
parameters[5].Value = model.USER_HEAD;
parameters[6].Value = model.SEX;
parameters[7].Value = model.EMAIL;
parameters[8].Value = model.USER_TYPE;
parameters[9].Value = model.ISCOMPLETE;
parameters[10].Value = model.PROVINCE;
parameters[11].Value = model.CITY;
parameters[12].Value = model.AREA;
parameters[13].Value = model.PEOPLE_IDENTITY;
parameters[14].Value = model.OCCUPATION;
parameters[15].Value = model.PERSONALITY;
parameters[16].Value = model.INTRODUCE;
parameters[17].Value = model.IDENTIFICATION_STATE;
parameters[18].Value = model.SAME_HOBBY_PEOPLE;
parameters[19].Value = model.EXP;
parameters[20].Value = model.SCORE;
parameters[21].Value = model.REALM_NAME;
parameters[22].Value = model.ADDTIME;
parameters[23].Value = model.IS_RED;
parameters[24].Value = model.STATE;
parameters[25].Value = model.REMARK;
parameters[26].Value = model.Person_Desc;
parameters[27].Value = model.Person_NickName;
parameters[28].Value = model.Porder;
parameters[29].Value = model.UpdateTime;
parameters[30].Value = model.PLAT_VAL;
parameters[31].Value = model.SPECIALTY_VAL;
parameters[32].Value = model.IPURL;
//parameters[33].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
#region 修改微吧用户信息
try
{
if (GetRecordCount(" tel='" + model.TEL + "' and userid<>" + model.USERID + " ") > 0)
{
strSql = new StringBuilder();
strSql.Append("update RED_USER set ");
////1：修改用户头像和昵称
//if (type == 1)
//{
strSql.Append("USERNAME=@USERNAME,");
strSql.Append("USER_HEAD=@USER_HEAD,");
strSql.Append("PWD=@PWD");
//}//2：修改密码
//else if (type == 2)
//{
// strSql.Append("PWD=@PWD");
//}
strSql.Append(" where TEL=@TEL and USERID<>@USERID");
////1：修改用户头像和昵称
//if (type == 1)
//{
SqlParameter[] param =
{
new SqlParameter("@USERID", SqlDbType.Int, 4),
new SqlParameter("@TEL", SqlDbType.NVarChar, 50),
new SqlParameter("@USERNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@USER_HEAD", SqlDbType.NVarChar, 100),
new SqlParameter("@PWD", SqlDbType.NVarChar, 100)
};
param[0].Value = model.USERID;
param[1].Value = model.TEL;
param[2].Value = model.USERNAME;
param[3].Value = model.USER_HEAD;
param[4].Value = model.PWD;
DbHelperSQL.ExecuteSql(strSql.ToString(), param);
//}//2：修改密码
//else if (type == 2)
//{
// SqlParameter[] param = {
// new SqlParameter("@USERID", SqlDbType.Int,4),
// new SqlParameter("@TEL", SqlDbType.NVarChar,50),
// new SqlParameter("@PWD", SqlDbType.NVarChar,100)
// };
// param[0].Value = model.USERID;
// param[1].Value = model.TEL;
// param[2].Value = model.PWD;
// DbHelperSQL.ExecuteSql(strSql.ToString(), param);
//}
}
}
catch (Exception ex)
{
}
#endregion
return(true);
}
else
{
return(false);
}
}
