コード例 #1
0
        // 平台商操作运营商
        public void FutuoOperator(string fromTenantCode, string toTenantCode, decimal money,int operatorType,EnumConsumeType consumeType,string remark)
        {
            // 0为充值,1为扣款

            //decimal balance = QueryBalance(toTenantCode);

            //using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString))
            //{
            //    conn.Open();
            //    var tran = conn.BeginTransaction();
            //    string sql = "";

            //    EMTenantAccountDetailService serv = new EMTenantAccountDetailService();

            //    if (operatorType == 0)
            //    {
            //        sql = string.Format(@"update movo_tenant_account set Balance = Balance + {0}  where TenantCode = '{1}';",
            //        money, toTenantCode);
            //        MySqlHelper.ExecuteNonQuery(conn, sql);

            //        EMTenantAccountDetail fromTenantDetail = new EMTenantAccountDetail()
            //        {
            //            ConsumeMoney = money,
            //            ConsumeType = consumeType,
            //            OperateType = EnumOperateType.Income,
            //            CreateTime = DateTime.Now,
            //            TargetTenantCode = null,
            //            TenantCode = toTenantCode,
            //            Remark = remark,
            //            OperatorTenantCode = fromTenantCode,
            //        };
                    
            //        serv.Insert(conn, fromTenantDetail);

            //    }
            //    else
            //    {
            //        if (balance < money)
            //            throw new Exception("对不起,余额不足,扣款失败!");

            //        sql = string.Format(@"update movo_tenant_account set Balance = Balance - {0}  where TenantCode = '{1}';",
            //            money, toTenantCode);
            //        MySqlHelper.ExecuteNonQuery(conn, sql);

            //        EMTenantAccountDetail toTenantDetail = new EMTenantAccountDetail()
            //        {
            //            ConsumeMoney = money,
            //            ConsumeType = consumeType,
            //            OperateType = EnumOperateType.Outlay,
            //            TargetTenantCode = null,
            //            CreateTime = DateTime.Now,
            //            TenantCode = toTenantCode,
            //            Remark = remark,
            //            OperatorTenantCode = fromTenantCode,                         
            //        };
            //        serv.Insert(conn, toTenantDetail);
            //    }               
                
            //    tran.Commit();
            //}
            TenantCountDetailDAL dal = new TenantCountDetailDAL();
            dal.FutuoOperator(fromTenantCode, toTenantCode, money, operatorType, consumeType, remark);
        }