public IWsModel <ReqAccount, ResAccount> AccountSimple([FromBody] WsModel <ReqAccount, ResAccount> model) { if (model == null) { return(new WsModel <ReqAccount, ResAccount>().Fail(ErrorCode.PARAM_NULL, "参数为空")); } if (model.Request == null) { return(model.Fail(ErrorCode.PARAM_NULL, "参数为空")); } if (string.IsNullOrWhiteSpace(model.Request.OpenId)) { return(model.Fail(ErrorCode.PARAM_NULL, "参数OpenId为空")); } // var wxlog= WxLogFactory.GetWxLogger(typeof(QueryAccountService)); //Account account = new DbsAccount().ById(model.Request.AccountId); Account account = new DbsAccount().ByOpenId(model.Request.OpenId, ValidityState.Enabled); if (account == null) { return(model.Fail(ErrorCode.DB_NOTEXISTED, "用户不存在")); } LogDebug($"找到用户{account.Name}"); LogInfo($"找到用户{account.Name}"); LogError($"找到用户{account.Name}"); var res = new ResAccount(account); return(model.Ok(res)); }
public IWsModel <ReqAddAccount, ResAccount> UpdateAccount([FromBody] WsModel <ReqAddAccount, ResAccount> model) { if (model == null) { return(new WsModel <ReqAddAccount, ResAccount>().Fail(ErrorCode.PARAM_NULL, "参数为空")); } if (model.Request == null) { return(model.Fail(ErrorCode.PARAM_NULL, "参数为空")); } if (string.IsNullOrWhiteSpace(model.Request.OpenId)) { return(model.Fail(ErrorCode.PARAM_NULL, "参数为空")); } var retAccount = new DbsAccount().GetAccount(model.Request.OpenId); if (retAccount == null) { return(model.Fail(ErrorCode.DB_NOTEXISTED, "数据不存在")); } if (AlterModel(ref retAccount, model.Request)) { var result = new DbaAccount().UpdateAccount(retAccount); if (result == 0) { return(model.Fail(ErrorCode.DB_SAVE_FAILED, "修改失败")); } } var ret = new ResAccount(retAccount); return(model.Ok(ret)); }
/// <summary> /// 获取用户信息包含公司信息 /// </summary> /// <param name="openid"></param> /// <returns></returns> public ResAccount GetAccountInfo(string openid, ValidityState state) { using (var dbs = WxDbFactory.GetDbContext("hch_dbs").MyDB) { ResAccount ret = dbs.Single <ResAccount>("SELECT acc.*,c.`Name`as CorporationName FROM ( SELECT * FROM Account WHERE OpenId=@openid and State=@state) AS acc INNER JOIN Corporation as c ON c.Id= acc.corporation where c.State=@state ", new { openid = openid, state = state }); //var q = dbs.From<Account>().LeftJoin<Corporation>((a, c) => a.Corporation == c.Id).Where<Account>(a => a.Id == openid).Select<Account, Corporation>((x, c) => new { x,CorporationName=c.Name }); //var ret = dbs.Single<dynamic>(q); //foreach (dynamic item in accret) //{ // string id = item.Id; //} return(ret); } }
public IWsModel <ReqAddAccount, ResAccount> AddAccount([FromBody] WsModel <ReqAddAccount, ResAccount> model) { if (model == null) { return(new WsModel <ReqAddAccount, ResAccount>().Fail(ErrorCode.PARAM_NULL, "参数为空")); } if (model.Request == null) { return(model.Fail(ErrorCode.PARAM_NULL, "参数为空")); } if (!model.Request.Valid4AddAccount()) { return(model.Fail(ErrorCode.PARAM_NULL, "参数为空")); } var dbs = new DbsAccount(); if (dbs.GetAccount(model.Request.OpenId) != null) { return(model.Fail(ErrorCode.DB_EXISTED, "数据已存在")); } //验证公司是否存在 if (dbs.GetCorporationInfo(model.Request.Corporation, ValidityState.Enabled) == null) { return(model.Fail(ErrorCode.DB_NOTEXISTED, "公司不存在")); } var account = new Account(model.Request.Wechat, model.Request.WechatName, model.Request.OpenId, model.Request.Corporation, model.Request.Sex, model.Request.Email, model.Request.Phone, model.Request.Name, ValidityState.Disabled, Identity.Staff, model.Request.Logo, DateTime.Now); var result = new DbaAccount().AddAccount(account); if (result == 0) { return(model.Fail(ErrorCode.DB_SAVE_FAILED, "添加失败")); } var ret = new ResAccount(account); return(model.Ok(ret)); }