public void TopUpCustomer(string fromTenantCode, string toTenantCode, decimal money)
{
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString))
{
conn.Open();
var tran = conn.BeginTransaction();
string sql = string.Format(@"update movo_tenant_account set Balance = Balance - {0} where TenantCode = '{1}';",
money, fromTenantCode);
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 = EnumConsumeType.RechargeToCustomer,
OperateType = EnumOperateType.Outlay,
CreateTime = DateTime.Now,
TargetTenantCode = toTenantCode,
TenantCode = fromTenantCode,
OperatorTenantCode = fromTenantCode,
};
IEMTenantAccountDetailService serv = new EMTenantAccountDetailService();
serv.Insert(conn,fromTenantDetail);
EMTenantAccountDetail toTenantDetail = new EMTenantAccountDetail()
{
ConsumeMoney = money,
ConsumeType = EnumConsumeType.AccountIncome,
OperateType = EnumOperateType.Income,
CreateTime = DateTime.Now,
TenantCode = toTenantCode,
OperatorTenantCode = fromTenantCode,
};
serv.Insert(conn,toTenantDetail);
tran.Commit();
}
}
public void DecuntMoney(string tenantCode, string opratorTenantCode, EnumConsumeType type, decimal money, string remark)
{
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString))
{
conn.Open();
var tran = conn.BeginTransaction();
string sql = string.Format(@"update movo_tenant_account set Balance = Balance - {0} where TenantCode = '{1}';",
money, tenantCode);
MySqlHelper.ExecuteNonQuery(conn, sql);
EMTenantAccountDetail detail = new EMTenantAccountDetail()
{
ConsumeMoney = money,
ConsumeType = type,
OperateType = EnumOperateType.Outlay,
CreateTime = DateTime.Now,
TenantCode = tenantCode,
Remark = remark,
OperatorTenantCode = opratorTenantCode,
};
IEMTenantAccountDetailService serv = new EMTenantAccountDetailService();
serv.Insert(conn, detail);
tran.Commit();
}
}
