/// <summary>
/// 用户修改认证信息
/// </summary>
/// <param name="model">认证信息</param>
/// <returns></returns>
public int UpdateLaudator(CustLaudator model)
{
var sqlStr = new StringBuilder("update cust_laudator set ");
sqlStr.Append(Helper.CreateField(model).Trim().TrimEnd(','));
sqlStr.Append(" where openid=@openid;");
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
conn.Execute(sqlStr.ToString(), model, tran);
tran.Commit();
return 1;
}
catch (Exception ex)
{
tran.Rollback();
return 0;
}
}
}
/// <summary>
/// 保存点赞人信息
/// </summary>
/// <param name="model">点赞人信息</param>
/// <returns></returns>
public int AddLaudator(CustLaudator model)
{
const string sql = @"INSERT INTO cust_laudator
(innerid, accountid, nickname, photo, openid, remarkname, area, sex, subscribe_time, subscribe, country, province, city, createdtime)
VALUES (@innerid, @accountid, @nickname, @photo, @openid, @remarkname, @area, @sex, @subscribe_time, @subscribe, @country, @province, @city, @createdtime);";
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
conn.Execute(sql, model, tran);
tran.Commit();
return 1;
}
catch (Exception ex)
{
tran.Rollback();
return 0;
}
}
}