Example #1
0
 public int EditWxMemeberBasic(Model.WxMemberBasic memberbasic)
 {
     using (var helper = new SqlHelper())
     {
         var result = new InternalWxMemberBasic(helper).EditWxMemberBasic(memberbasic);
         return(result);
     }
 }
Example #2
0
        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);
        }