/// <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; }