private void BindData() { MemberAmountQuery memberAmountQuery = new MemberAmountQuery(); memberAmountQuery.UserName = this.UserName; memberAmountQuery.PayId = this.PayId; memberAmountQuery.TradeType = this.TradeTypeValue; memberAmountQuery.TradeWays = this.TradeWaysValue; memberAmountQuery.EndTime = this.EndTime; memberAmountQuery.StartTime = this.StartTime; memberAmountQuery.PageIndex = this.pager.PageIndex; memberAmountQuery.PageSize = this.pager.PageSize; memberAmountQuery.SortOrder = SortAction.Desc; memberAmountQuery.SortBy = "Id"; Globals.EntityCoding(memberAmountQuery, true); DbQueryResult amountWithUserName = MemberAmountProcessor.GetAmountWithUserName(memberAmountQuery); this.reCommissions.DataSource = amountWithUserName.Data; this.reCommissions.DataBind(); this.pager.TotalRecords = amountWithUserName.TotalRecords; System.Collections.Generic.Dictionary <string, decimal> amountDic = MemberAmountProcessor.GetAmountDic(memberAmountQuery); this.CurrentTotal = amountDic["CurrentTotal"]; this.AvailableTotal = amountDic["AvailableTotal"]; this.UnliquidatedTotal = amountDic["UnliquidatedTotal"]; }
private void BindData() { MemberAmountQuery entity = new MemberAmountQuery { UserName = this.UserName, PayId = this.PayId, TradeType = this.TradeTypeValue, TradeWays = this.TradeWaysValue, EndTime = this.EndTime, StartTime = this.StartTime, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "Id" }; Globals.EntityCoding(entity, true); DbQueryResult amountWithUserName = MemberAmountProcessor.GetAmountWithUserName(entity); this.reCommissions.DataSource = amountWithUserName.Data; this.reCommissions.DataBind(); this.pager.TotalRecords = amountWithUserName.TotalRecords; Dictionary <string, decimal> amountDic = MemberAmountProcessor.GetAmountDic(entity); this.CurrentTotal = amountDic["CurrentTotal"]; this.AvailableTotal = amountDic["AvailableTotal"]; this.UnliquidatedTotal = amountDic["UnliquidatedTotal"]; }
public Dictionary <string, decimal> GetAmountDic(MemberAmountQuery query) { Dictionary <string, decimal> dictionary = new Dictionary <string, decimal>(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" State=1 "); if (query.UserId > 0) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat("UserId = {0}", query.UserId); } if (!string.IsNullOrEmpty(query.UserName)) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat("UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.UserName)); } if (!string.IsNullOrEmpty(query.PayId)) { stringBuilder.AppendFormat(" and PayId = '{0}'", query.PayId); } if (!string.IsNullOrEmpty(query.TradeType)) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" TradeType = {0}", query.TradeType); } if (!string.IsNullOrEmpty(query.TradeWays)) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" TradeWays = {0}", query.TradeWays); } if (!string.IsNullOrEmpty(query.StartTime.ToString())) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" datediff(dd,'{0}',TradeTime)>=0", query.StartTime); } if (!string.IsNullOrEmpty(query.EndTime.ToString())) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" datediff(dd,'{0}',TradeTime)<=0", query.EndTime); } string query2 = "select isnull(sum(a.TotalAmount),0) AS CurrentTotal,isnull(sum(a.AvailableAmount),0) AS AvailableTotal from aspnet_Members a where exists (select userid from Hishop_MemberAmountDetailed where userid=a.userid and " + stringBuilder + ") "; System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query2); System.Data.DataTable dataTable = this.database.ExecuteDataSet(sqlStringCommand).Tables[0]; dictionary.Add("CurrentTotal", decimal.Parse(dataTable.Rows[0]["CurrentTotal"].ToString())); dictionary.Add("AvailableTotal", decimal.Parse(dataTable.Rows[0]["AvailableTotal"].ToString())); string query3 = "SELECT isnull(sum(Amount),0) FROM Hishop_MemberAmountRequest a WHERE exists (select userid from Hishop_MemberAmountDetailed where userid=a.userid and " + stringBuilder + ") and State in(0,1,3)"; System.Data.Common.DbCommand sqlStringCommand2 = this.database.GetSqlStringCommand(query3); decimal value = decimal.Parse(this.database.ExecuteScalar(sqlStringCommand2).ToString()); dictionary.Add("UnliquidatedTotal", value); return(dictionary); }
public DbQueryResult GetAmountWithUserName(MemberAmountQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" State=1 "); if (query.UserId > 0) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat("UserId = {0}", query.UserId); } if (!string.IsNullOrEmpty(query.UserName)) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat("UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.UserName)); } if (!string.IsNullOrEmpty(query.PayId)) { stringBuilder.AppendFormat(" and PayId = '{0}'", query.PayId); } if (!string.IsNullOrEmpty(query.TradeType)) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" TradeType = {0}", query.TradeType); } if (!string.IsNullOrEmpty(query.TradeWays)) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" TradeWays = {0}", query.TradeWays); } if (!string.IsNullOrEmpty(query.StartTime.ToString())) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" datediff(dd,'{0}',TradeTime)>=0", query.StartTime); } if (!string.IsNullOrEmpty(query.EndTime.ToString())) { if (stringBuilder.Length > 0) { stringBuilder.Append(" AND "); } stringBuilder.AppendFormat(" datediff(dd,'{0}',TradeTime)<=0", query.EndTime); } string table = "Hishop_MemberAmountDetailed"; return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, table, "Id", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "*")); }
public static DbQueryResult GetAmountWithUserName(MemberAmountQuery query) { return(new AmountDao().GetAmountWithUserName(query)); }
public static Dictionary <string, decimal> GetAmountDic(MemberAmountQuery query) { return(new AmountDao().GetAmountDic(query)); }