/// <summary>
/// 查询租户的账户信息
/// </summary>
/// <param name="strTenantCode">租户编码以逗号隔开</param>
/// <param name="StartTime">开始时间</param>
/// <param name="EndTime">结束时间</param>
/// <param name="EnumConsumeType?"></param>
/// <param name="rowIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public IList<EMTenantAccountDetail> SelectTenantCountDetail(string strTenantCode, DateTime StartTime, DateTime EndTime, EnumConsumeType? consumeType, int rowIndex, int pageSize, ref int rowCount)
{
rowCount = 0;
if (string.IsNullOrEmpty(strTenantCode))
{
strTenantCode = "''";
}
string consumeTypeCondition = consumeType.HasValue ? "and ConsumeType=" + Convert.ToInt32(consumeType.Value) : "";
List<EMTenantAccountDetail> list = new List<EMTenantAccountDetail>();
string sCmdText = string.Format(@"select * from movo_tenantaccount_detail where TenantCode in ({0})
and CreateTime between '{1}' and '{2}' {5} order by CreateTime desc limit {3},{4};", strTenantCode, StartTime, EndTime, rowIndex, pageSize, consumeTypeCondition);
string sql = string.Format(@"select count(*) from movo_tenantaccount_detail where TenantCode in ({0})
and CreateTime between '{1}' and '{2}' {3} ", strTenantCode, StartTime, EndTime, consumeTypeCondition);
using (DbDataReader sdrCount = MySqlDB.GetDataReader(CommandType.Text, sql))
{
if (sdrCount != null)
{
while (sdrCount.Read())
{
rowCount = rowCount + Convert.ToInt32(sdrCount[0]);
}
}
sdrCount.Close();
}
using (DbDataReader sdr = MySqlDB.GetDataReader(CommandType.Text, sCmdText))
{
if (sdr != null)
{
while (sdr.Read())
{
EMTenantAccountDetail acc = new EMTenantAccountDetail();
acc.ConsumeMoney = sdr["ConsumeMoney"].ToDecimal();
acc.ConsumeType = (EnumConsumeType)sdr["ConsumeType"].ToInt();
acc.CreateTime = sdr["CreateTime"].ToDateTime();
acc.OperateType = (EnumOperateType)sdr["OperateType"].ToInt();
acc.OperatorTenantCode = sdr["OperatorTenantCode"].ToString();
acc.Remark = sdr["Remark"].ToString();
acc.TargetTenantCode = sdr["TargetTenantCode"].ToString();
acc.TenantCode = sdr["TenantCode"].ToString();
list.Add(acc);
}
}
sdr.Close();
}
return list;
}
public void Insert(MySql.Data.MySqlClient.MySqlConnection conn, EMTenantAccountDetail entity)
{
string sql = @"insert into movo_tenantaccount_detail
(TenantCode, ConsumeMoney, OperateType
, ConsumeType, TargetTenantCode, Remark, CreateTime,OperatorTenantCode)values
(@TenantCode, @ConsumeMoney, @OperateType
, @ConsumeType, @TargetTenantCode, @Remark, @CreateTime,@OperatorTenantCode);";
Dictionary<string, object> cmdParms = new Dictionary<string,object>();
cmdParms.Add("@TenantCode", entity.TenantCode);
cmdParms.Add("@ConsumeMoney", entity.ConsumeMoney);
cmdParms.Add("@OperateType", entity.OperateType);
cmdParms.Add("@ConsumeType", entity.ConsumeType);
cmdParms.Add("@TargetTenantCode", entity.TargetTenantCode);
cmdParms.Add("@Remark", entity.Remark == null ? "" : entity.Remark);
cmdParms.Add("@CreateTime", entity.CreateTime);
cmdParms.Add("@OperatorTenantCode", entity.OperatorTenantCode);
MySqlHelper.ExecuteNonQuery(conn,CommandType.Text, sql,cmdParms);
}
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();
}
}
UserCenterAccountDetailViewModel ConvertToAccountViewModel(EMTenantAccountDetail entity)
{
UserCenterAccountDetailViewModel mode = null;
if (entity != null)
{
mode = new UserCenterAccountDetailViewModel();
string userName = null;
string tenantName=string.Empty;
mode.OperateType = entity.OperateType;
mode.CreateTime = entity.CreateTime;
mode.ConsumeType = entity.ConsumeType;
mode.TargetTenantCode = entity.TargetTenantCode;
//if (!string.IsNullOrEmpty(entity.TargetTenantCode))
//{
IEMTenantService tenantService = new EMTenantService();
EMTenant EMTenant = tenantService.Select(entity.TargetTenantCode);
if (EMTenant != null)
{
userName = EMTenant.RegisterUserName;
tenantName = EMTenant.TenantName;
}
//}
mode.ConsumeMoney = entity.ConsumeMoney;
mode.Remark = entity.Remark;
mode.UserName = userName;
mode.TenantName = tenantName;
}
return mode;
}
private EMTenantAccountDetail ConvertInfo(DataRow row)
{
if (row == null)
{
return null;
}
EMTenantAccountDetail info = new EMTenantAccountDetail()
{
ConsumeMoney = Convert.ToDecimal(row["ConsumeMoney"]),
ConsumeType = (EnumConsumeType)Convert.ToInt32(row["ConsumeType"]),
CreateTime = DateTimeConvertHelper.Parse(row["CreateTime"].ToString()),
OperateType = (EnumOperateType)Convert.ToInt32(row["OperateType"]),
Remark = row["Remark"].ToString(),
TargetTenantCode = row["TargetTenantCode"].ToString(),
TenantCode = row["TenantCode"].ToString(),
};
return info;
}
