예제 #1
0
        /// <summary>
        /// 用户添加认证信息
        /// </summary>
        /// <param name="model">认证信息</param>
        /// <returns></returns>
        public int AddAuthentication(CustAuthenticationModel model)
        {
            //添加认证 自动升级成车商
            const string sqlU = "update cust_info set authstatus=1 where innerid=@innerid;";
            const string sqlI = @"INSERT INTO `cust_authentication`
                                (innerid, custid, realname, idcard, enterprisename, licencecode, licencearea, organizationcode, taxcode, relevantpicture, createdtime)
                                VALUES
                                (uuid(), @custid, @realname, @idcard, @enterprisename, @licencecode, @licencearea, @organizationcode, @taxcode, @relevantpicture, @createdtime);";

            using (var conn = Helper.GetConnection())
            {
                var tran = conn.BeginTransaction();
                try
                {
                    conn.Execute(sqlU, new { innerid = model.Custid }, tran);
                    conn.Execute(sqlI, model, tran);
                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    LoggerFactories.CreateLogger().Write("AddAuthentication Ex:" + ex.Message, TraceEventType.Error);
                    tran.Rollback();
                    return 0;
                }
            }
        }
예제 #2
0
        /// <summary>
        /// 用户修改认证信息
        /// </summary>
        /// <param name="model">认证信息</param>
        /// <returns></returns>
        public int UpdateAuthentication(CustAuthenticationModel model)
        {
            var sqlStr = new StringBuilder("update `cust_authentication` set ");
            sqlStr.Append(Helper.CreateField(model).Trim().TrimEnd(','));
            sqlStr.Append(" where innerid = @innerid");

            const string sqlU = "update cust_info set authstatus=4 where innerid=@innerid;";
            using (var conn = Helper.GetConnection())
            {
                var tran = conn.BeginTransaction();
                try
                {
                    conn.Execute(sqlU, new { innerid = model.Custid }, tran);
                    conn.Execute(sqlStr.ToString(), model, tran);
                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    LoggerFactories.CreateLogger().Write("UpdateAuthentication Ex:" + ex.Message, TraceEventType.Error);
                    tran.Rollback();
                    return 0;
                }
            }
        }
예제 #3
0
 /// <summary>
 /// 审核认证信息
 /// </summary>
 /// <param name="model">会员相关信息</param>
 /// <returns></returns>
 public int AuditAuthentication(CustAuthenticationModel model)
 {
     const string sql = "update cust_info set authstatus=@authstatus,type=1 where innerid=@innerid;";
     const string sqlau = "update cust_authentication set auditper=@auditper,auditdesc=@auditdesc,audittime=@audittime where custid=@custid;";
     //修改会员的车辆类型成为  1车商车源
     const string sqlUCar = "update car_info set seller_type=1 where custid=@custid;";
     using (var conn = Helper.GetConnection())
     {
         var tran = conn.BeginTransaction();
         try
         {
             conn.Execute(sql, new
             {
                 authstatus = model.AuditResult == 1 ? 2 : 3,
                 innerid = model.Custid
             }, tran);
             conn.Execute(sqlau, new
             {
                 auditper = model.AuditPer,
                 auditdesc = model.AuditDesc,
                 audittime = model.AuditTime,
                 custid = model.Custid
             }, tran);
             conn.Execute(sqlUCar, new { custid = model.Custid }, tran);
             tran.Commit();
             return 1;
         }
         catch (Exception ex)
         {
             LoggerFactories.CreateLogger().Write("AuditAuthentication Ex:" + ex.Message, TraceEventType.Error);
             tran.Rollback();
             return 0;
         }
     }
 }
예제 #4
0
        /// <summary>
        /// 审核认证信息
        /// </summary>
        /// <param name="model">会员相关信息</param>
        /// <returns></returns>
        public int AuditAuthentication(CustAuthenticationModel model)
        {
            const string sql = "update cust_info set authstatus=@authstatus where innerid=@innerid;";
            const string sqlau = "update cust_authentication set auditper=@auditper,auditdesc=@auditdesc,audittime=@audittime where custid=@custid;";

            using (var conn = Helper.GetConnection())
            {
                var tran = conn.BeginTransaction();
                try
                {
                    conn.Execute(sql, new { authstatus = model.AuditResult, innerid = model.Custid });
                    conn.Execute(sqlau, new {
                        auditper = model.AuditPer,
                        auditdesc = model.AuditDesc,
                        audittime = model.AuditTime,
                        custid = model.Custid
                    });

                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    return 0;
                }
            }
        }