public int EditWxMemeberBasic(Model.WxMemberBasic memberbasic)
{
using (var helper = new SqlHelper())
{
var result = new InternalWxMemberBasic(helper).EditWxMemberBasic(memberbasic);
return(result);
}
}
internal int EditWxMemberBasic(Model.WxMemberBasic model)
{
var cmd = sqlHelper.PrepareStoredSqlCommand("usp_InsertOrUpdateWxMemberBasic");
cmd.AddParam("@Id", model.Id);
cmd.AddParam("@subscribe", model.Subscribe);
cmd.AddParam("@openid", model.Openid);
cmd.AddParam("@nickname", model.Nickname);
cmd.AddParam("@sex", model.Sex);
cmd.AddParam("@language", model.Language);
cmd.AddParam("@city", model.City);
cmd.AddParam("@province", model.Province);
cmd.AddParam("@country", model.Country);
cmd.AddParam("@headimgurl", model.Headimgurl);
cmd.AddParam("@subscribe_time", model.Subscribe_time);
cmd.AddParam("@comid", model.Comid);
cmd.AddParam("@renewtime", model.renewtime);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
return((int)parm.Value);
}