/// <summary>
/// C用户 用户注册
/// </summary>
/// <param name="userInfo">用户信息</param>
/// <returns></returns>
public int AddUser(UserModel userInfo)
{
//插入账户基本信息
const string sql = @"INSERT INTO user_info(innerid, username, password, nickname, mobile, telephone, email,headportrait, realname, status, provid, cityid, countyid, sex, brithday, qq, signature, totalpoints, qrcode, createrid, createdtime, modifierid, modifiedtime)
VALUES (@innerid, @username, @password, @nickname, @mobile, @telephone, @email,@headportrait, @realname, @status, @provid, @cityid, @countyid, @sex, @brithday, @qq, @signature, @totalpoints, @qrcode, @createrid, @createdtime,@modifierid, @modifiedtime);";
using (var conn = Helper.GetConnection())
{
try
{
conn.Execute(sql, userInfo);
return 1;
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("C用户注册：", TraceEventType.Error, ex);
return 0;
}
}
}
/// <summary>
/// C用户 修改会员信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateUserInfo(UserModel model)
{
var sqlStr = new StringBuilder("update user_info set ");
sqlStr.Append(Helper.CreateField(model).Trim().TrimEnd(','));
sqlStr.Append(" where innerid = @innerid");
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
conn.Execute(sqlStr.ToString(), model, tran);
tran.Commit();
return 1;
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("C用户修改会员信息：", TraceEventType.Error, ex);
tran.Rollback();
return 0;
}
}
}
