/// <summary>
/// 修改会员信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateCustInfo(CustModel model)
{
var sqlStr = new StringBuilder("update cust_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)
{
tran.Rollback();
return 0;
}
}
}
/// <summary>
/// 用户注册
/// </summary>
/// <param name="userInfo">用户信息</param>
/// <returns></returns>
public int CustRegister(CustModel userInfo)
{
//插入账户基本信息
const string sql = @"INSERT INTO cust_info(innerid, custname, password, mobile, telephone, email, headportrait, status, authstatus, provid, cityid, area, sex, brithday, qq, signature, totalpoints, level, type, recommendedid, createdtime)
VALUES (@innerid, @custname, @password, @mobile, @telephone, @email, @headportrait, @status, @authstatus, @provid, @cityid, @area, @sex, @brithday, @qq, @signature, @totalpoints, @level, @type, @recommendedid, @createdtime);";
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
//获取销售编号
if (userInfo.Wechat != null)
{
userInfo.RecommendedId = conn.Query<string>("select scenestr from wechat_friend where openid=@openid;", new { openid = userInfo.Wechat.Openid }).FirstOrDefault();
}
//插入会员信息
conn.Execute(sql, userInfo, tran);
//插入会员的总数信息
const string sqlTotal = "insert into cust_total_info (innerid, custid) values (uuid(),@custid);";
conn.Execute(sqlTotal, new { custid = userInfo.Innerid }, tran);
//插入关联
if (userInfo.Wechat != null)
{
const string sqlwechat =
@"INSERT INTO cust_wechat(innerid,custid,openid,createdtime) VALUES(uuid(),@custid,@openid,@createdtime);";
conn.Execute(sqlwechat, new
{
custid = userInfo.Innerid,
openid = userInfo.Wechat.Openid,
createdtime = userInfo.Createdtime
}, tran);
}
tran.Commit();
return 1;
}
catch (Exception ex)
{
tran.Rollback();
return 0;
}
}
}
public ActionResult CheckBusinessLogin(CustModel customerinfo)
{
Session.Timeout = 120;
Session["CustModel"] = customerinfo;
return Json(new { code = 1, message = "登录成功" });
}