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); }