// 平台商操作运营商 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); }