/// <summary>
/// 修改基本资料
/// </summary>
/// <param name="realname">真实姓名</param>
/// <param name="shangquan">商圈</param>
/// <param name="photoname">头像照片</param>
/// <param name=""></param>
/// <returns></returns>
public string BasicData(string realname, string company, string photoname, string shangquan = "")
{
string sql = string.Empty;
if (!string.IsNullOrEmpty(shangquan))
{
sql = " delete from user_search_countyid_wuxi where userid = " + User.userid;
for (int i = 1; i < CharString.Intercept(',', shangquan); i++)
{
sql += string.Format(" if not exists(select 1 from user_search_countyid_wuxi where userid = {0} and countyshangquan = {1}) insert into user_search_countyid_wuxi (userid, countyshangquan)values({0}, {1})",
User.userid, CharString.Intercept(',', shangquan, i));
}
}
else
{
sql = " delete from user_search_countyid_wuxi where userid = " + User.userid;
}
sql = sql + " update user_details set photoname=@photoname where userid = @userid ";
using (shhouseEntities db = new shhouseEntities())
{
try
{
var edituser = db.Database.ExecuteSqlCommand(sql,
new SqlParameter[] {
new SqlParameter("@userid", User.userid),
new SqlParameter("@mobile", User.user_details.mobile.ToString()),
new SqlParameter("@photoname", photoname),
});
return(JsonConvert.SerializeObject(new repmsg {
state = 1, msg = "修改成功"
}));
}
catch (Exception e)
{
return(JsonConvert.SerializeObject(new repmsg {
state = 2, msg = "修改失败，请稍后再试！"
}));
}
}
}
