Example #1
0
        private Boolean saveInfo(string name, string openId, string unionId)
        {
            Boolean ret = false;
            var     ns  = name.Split('#');

            if (ns.Length == 2)
            {
                using (IDbConnection db = DapperContext.Connection())
                {
                    var sql   = $@"select `name`,`alias` from tm_reg_employee where `alias` = '{ns[1]}' and `name` = '{ns[0]}'";
                    var count = db.Query(sql).Count();
                    if (count == 1)
                    {
                        sql = $@"update  tm_reg_employee set `openId` = '{openId}', `unioId` = '{unionId}' where `alias` = '{ns[1]}' and `name` = '{ns[0]}'";
                        db.Execute(sql);
                        ret = true;
                    }
                }
            }

            return(ret);
        }