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