private void BindData()
{
BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery
{
RequestTime = "",
CheckTime = "",
StoreName = this.StoreName,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "Id",
RequestEndTime = this.RequestEndTime,
RequestStartTime = this.RequestStartTime,
IsCheck = "",
UserId = ""
};
string[] extendChecks = new string[] { 0.ToString(), 1.ToString(), 3.ToString() };
Globals.EntityCoding(entity, true);
DbQueryResult memberAmountRequest = MemberAmountProcessor.GetMemberAmountRequest(entity, extendChecks);
this.reCommissions.DataSource = memberAmountRequest.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = memberAmountRequest.TotalRecords;
}
public override DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query)
{
if (null == query)
{
return(new DbQueryResult());
}
DbQueryResult result = new DbQueryResult();
StringBuilder builder = new StringBuilder();
string str = BuildBalanceDrawRequestQuery(query);
builder.Append("select *");
builder.Append(" from Hishop_BalanceDrawRequest B where 0=0 ");
builder.AppendFormat("{0} ORDER BY RequestTime DESC", str);
if (query.IsCount)
{
builder.AppendFormat(";select count(*) as Total from Hishop_BalanceDrawRequest where 0=0 {0}", str);
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
result.Data = DataHelper.ConverDataReaderToDataTable(reader);
if (query.IsCount && reader.NextResult())
{
reader.Read();
result.TotalRecords = reader.GetInt32(0);
}
}
return(result);
}
protected override void AttachChildControls()
{
DistributorsInfo currentDistributors = DistributorsBrower.GetCurrentDistributors();
if (currentDistributors.ReferralStatus != 0)
{
HttpContext.Current.Response.Redirect("MemberCenter.aspx");
}
else
{
this.vshopbalancedraw = (VshopTemplatedRepeater)this.FindControl("vshopbalancedraw");
BalanceDrawRequestQuery query = new BalanceDrawRequestQuery {
PageIndex = 1,
PageSize = 0x186a0,
UserId = currentDistributors.UserId.ToString(),
SortBy = "SerialID",
RequestTime = "",
RequestStartTime = "",
RequestEndTime = "",
CheckTime = "",
IsCheck = "",
SortOrder = SortAction.Desc
};
DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(query, null);
if (balanceDrawRequest.TotalRecords > 0)
{
this.vshopbalancedraw.DataSource = balanceDrawRequest.Data;
this.vshopbalancedraw.DataBind();
}
}
}
private void BindDrawRecords()
{
int pageIndex = default(int);
if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex))
{
pageIndex = 1;
}
int pageSize = default(int);
if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize))
{
pageSize = 10;
}
BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery();
balanceDrawRequestQuery.PageIndex = pageIndex;
balanceDrawRequestQuery.PageSize = pageSize;
balanceDrawRequestQuery.UserId = HiContext.Current.UserId;
DbQueryResult mySplittinDraws = MemberProcessor.GetMySplittinDraws(balanceDrawRequestQuery, null);
this.rptDrawRecodes.DataSource = mySplittinDraws.Data;
this.rptDrawRecodes.DataBind();
int totalRecords = mySplittinDraws.TotalRecords;
this.txtTotalPages.SetWhenIsNotNull(totalRecords.ToString());
}
private void Exporttoexcel(HttpContext context)
{
BalanceDrawRequestQuery balanceDrawRequestQuery = this.GetBalanceDrawRequestQuery(context);
balanceDrawRequestQuery.PageIndex = 1;
balanceDrawRequestQuery.PageSize = 2147483647;
DbQueryResult splittinDraws = MemberHelper.GetSplittinDraws(balanceDrawRequestQuery, 1);
DataTable data = splittinDraws.Data;
string empty = string.Empty;
empty += "用户名";
empty += ",申请时间";
empty += ",提现金额";
empty += ",支付宝帐号";
empty += ",真实姓名";
empty += ",备注\r\n";
foreach (DataRow row in data.Rows)
{
empty += row["UserName"].ToString();
empty = empty + "," + row["RequestDate"].ToString();
empty = empty + "," + row["Amount"].ToString();
empty = empty + "," + row["AlipayCode"].ToString();
empty = empty + "," + row["AlipayRealName"].ToString();
empty = empty + "," + row["Remark"].ToString() + "\r\n";
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=SplittinAlipayDrawRequest.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/ms-excel";
context.Response.Write(empty);
context.Response.End();
}
public void ExportExcel(HttpContext context)
{
BalanceDrawRequestQuery dataQuery = this.GetDataQuery(context);
dataQuery.PageIndex = 1;
dataQuery.PageSize = 2147483647;
DbQueryResult balanceDrawRequests = MemberHelper.GetBalanceDrawRequests(dataQuery, true);
DataTable data = balanceDrawRequests.Data;
string empty = string.Empty;
empty += "用户名";
empty += ",申请时间";
empty += ",提现金额";
empty += ",备注\r\n";
foreach (DataRow row in data.Rows)
{
empty += row["UserName"].ToString();
empty = empty + "," + row["RequestTime"].ToString();
empty = empty + "," + row["Amount"].ToString();
empty = empty + "," + row["Remark"].ToString() + "\r\n";
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceWeiXinDrawRequest.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/octet-stream";
context.Response.Write(empty);
context.Response.End();
}
public DbQueryResult GetSplittinDraws(BalanceDrawRequestQuery query, int?auditStatus)
{
StringBuilder stringBuilder = new StringBuilder("1=1");
if (auditStatus.HasValue)
{
stringBuilder.AppendFormat(" AND AuditStatus = {0}", auditStatus);
}
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" AND UserId = {0}", query.UserId);
}
if (!string.IsNullOrEmpty(query.UserName))
{
stringBuilder.AppendFormat(" AND UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.UserName));
}
if (query.FromDate.HasValue)
{
stringBuilder.AppendFormat(" AND RequestDate >= '{0}'", query.FromDate);
}
if (query.ToDate.HasValue)
{
stringBuilder.AppendFormat(" AND RequestDate <= '{0}'", query.ToDate);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Ecshop_SplittinDraws s", "JournalNumber", stringBuilder.ToString(), "*, (SELECT TOP 1 Balance FROM Ecshop_SplittinDetails WHERE UserId = s.UserId AND IsUse = 'true' ORDER BY JournalNumber DESC) AS Balance"));
}
public DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query)
{
DbQueryResult result;
if (null == query)
{
result = new DbQueryResult();
}
else
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string arg = this.BuildBalanceDrawRequestQuery(query);
stringBuilder.Append("select *");
stringBuilder.Append(" from Ecshop_BalanceDrawRequest B where 0=0 ");
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", arg);
if (query.IsCount)
{
stringBuilder.AppendFormat(";select count(*) as Total from Ecshop_BalanceDrawRequest where 0=0 {0}", arg);
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
result = dbQueryResult;
}
return(result);
}
public DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query)
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string text = this.BuildBalanceDrawRequestQuery(query);
stringBuilder.AppendFormat("select top {0} *", query.PageSize);
stringBuilder.Append(" from Ecshop_BalanceDrawRequest B where 0=0 ");
if (query.PageIndex == 1)
{
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text);
}
else
{
stringBuilder.AppendFormat(" and RequestTime < (select min(RequestTime) from (select top {0} RequestTime from Ecshop_BalanceDrawRequest where 0=0 {1} ORDER BY RequestTime DESC ) as tbltemp) {1} ORDER BY RequestTime DESC", (query.PageIndex - 1) * query.PageSize, text);
}
if (query.IsCount)
{
stringBuilder.AppendFormat(";select count(*) as Total from Ecshop_BalanceDrawRequest where 0=0 {0}", text);
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
return(dbQueryResult);
}
private void BindData()
{
BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery {
RequestTime = "",
CheckTime = "",
StoreName = this.StoreName,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "SerialID",
RequestEndTime = this.RequestEndTime,
RequestStartTime = this.RequestStartTime,
IsCheck = "",
UserId = ""
};
string[] extendChecks = new string[] { "0", "1" };
Globals.EntityCoding(entity, true);
DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(entity, extendChecks);
this.reCommissions.DataSource = balanceDrawRequest.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = balanceDrawRequest.TotalRecords;
DataTable drawRequestNum = DistributorsBrower.GetDrawRequestNum(new int[] { 3 });
this.Frist.Text = "待发放(" + this.pager.TotalRecords + ")";
if (drawRequestNum.Rows.Count > 0)
{
this.Second.Text = "发放异常(" + drawRequestNum.Rows[0]["num"].ToString() + ")";
}
}
private void GetList(HttpContext context)
{
BalanceDrawRequestQuery dataQuery = this.GetDataQuery(context);
DataGridViewModel <Dictionary <string, object> > listSplittinDraws = this.GetListSplittinDraws(dataQuery);
string s = base.SerializeObjectToJson(listSplittinDraws);
context.Response.Write(s);
context.Response.End();
}
private BalanceDrawRequestQuery GetDataQuery(HttpContext context)
{
BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery();
balanceDrawRequestQuery.FromDate = base.GetDateTimeParam(context, "FromDate");
balanceDrawRequestQuery.ToDate = base.GetDateTimeParam(context, "ToDate");
balanceDrawRequestQuery.UserName = base.GetParameter(context, "UserName", true);
balanceDrawRequestQuery.PageIndex = base.CurrentPageIndex;
balanceDrawRequestQuery.PageSize = base.CurrentPageSize;
balanceDrawRequestQuery.DrawRequestType = 1;
return(balanceDrawRequestQuery);
}
private void BindSplittinDraw()
{
BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery();
balanceDrawRequestQuery.PageIndex = this.pager.PageIndex;
balanceDrawRequestQuery.PageSize = this.pager.PageSize;
balanceDrawRequestQuery.UserId = HiContext.Current.UserId;
DbQueryResult mySplittinDraws = MemberProcessor.GetMySplittinDraws(balanceDrawRequestQuery, null);
this.rptSplittinDraw.DataSource = mySplittinDraws.Data;
this.rptSplittinDraw.DataBind();
this.pager.TotalRecords = mySplittinDraws.TotalRecords;
}
public void GetBalanceDrawRequest()
{
BalanceDrawRequestQuery query = new BalanceDrawRequestQuery();
query.FromDate = dataStart;
query.ToDate = dataEnd;
query.UserName = txtUserName.Text;
query.UserId = userId;
query.PageIndex = pager.PageIndex;
DbQueryResult distributorBalanceDrawRequests = DistributorHelper.GetDistributorBalanceDrawRequests(query);
grdBalanceDrawRequest.DataSource = distributorBalanceDrawRequests.Data;
grdBalanceDrawRequest.DataBind();
pager.TotalRecords = distributorBalanceDrawRequests.TotalRecords;
}
public void BindBalanceDrawRequest()
{
BalanceDrawRequestQuery query = new BalanceDrawRequestQuery();
query.FromDate = dataStart;
query.ToDate = dataEnd;
query.UserName = txtUserName.Text;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
DbQueryResult balanceDrawRequests = MemberHelper.GetBalanceDrawRequests(query);
grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data;
grdBalanceDrawRequest.DataBind();
pager1.TotalRecords = pager.TotalRecords = balanceDrawRequests.TotalRecords;
pager.TotalRecords = pager.TotalRecords = balanceDrawRequests.TotalRecords;
}
public DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query, bool IsAdmin = true)
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string text = this.BuildBalanceDrawRequestQuery(query);
stringBuilder.AppendFormat("select top {0} *", query.PageSize);
stringBuilder.Append(" from Hishop_BalanceDrawRequest B where 0=0 ");
if (IsAdmin)
{
text += " AND IsPass IS NULL ";
}
switch (query.DrawRequestType)
{
case 1:
text += " AND IsWeixin <> 1 AND IsAlipay <> 1";
break;
case 2:
text += " AND IsWeixin = 1 ";
break;
case 3:
text += " AND IsAlipay = 1";
break;
}
if (query.PageIndex == 1)
{
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text);
}
else
{
stringBuilder.AppendFormat(" and RequestTime < (select min(RequestTime) from (select top {0} RequestTime from Hishop_BalanceDrawRequest where 0=0 {1} ORDER BY RequestTime DESC ) as tbltemp) {1} ORDER BY RequestTime DESC", (query.PageIndex - 1) * query.PageSize, text);
}
if (query.IsCount)
{
stringBuilder.AppendFormat(";select count(*) as Total from Hishop_BalanceDrawRequest where 0=0 {0}", text);
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = base.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
return dbQueryResult;
}
public void BindBalanceDrawRequest()
{
BalanceDrawRequestQuery query = new BalanceDrawRequestQuery
{
FromDate = this.dataStart,
ToDate = this.dataEnd,
UserName = this.txtUserName.Text,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize
};
DbQueryResult balanceDrawRequests = MemberHelper.GetBalanceDrawRequests(query);
this.grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data;
this.grdBalanceDrawRequest.DataBind();
this.pager1.TotalRecords = this.pager.TotalRecords = balanceDrawRequests.TotalRecords;
this.pager.TotalRecords = this.pager.TotalRecords = balanceDrawRequests.TotalRecords;
}
public void HistoryExportToExcel(HttpContext context)
{
int value = base.GetIntParam(context, "UserId", false).Value;
BalanceDrawRequestQuery balanceDrawRequestQuery = this.GetBalanceDrawRequestQuery(context);
IList <CommissionRequestModel> splittinDrawsExportData = MemberHelper.GetSplittinDrawsExportData(balanceDrawRequestQuery, balanceDrawRequestQuery.AuditStatus);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<table border='1'>");
stringBuilder.Append("<thead><tr>");
stringBuilder.Append("<th>分销员</th>");
stringBuilder.Append("<th>申请时间</th>");
stringBuilder.Append("<th>提现金额</th>");
stringBuilder.Append("<th>操作人</th>");
stringBuilder.Append("<th>备注</th>");
stringBuilder.Append("<th>提现账号信息</th>");
stringBuilder.Append("</tr></thead>");
StringBuilder stringBuilder2 = new StringBuilder();
DateTime dateTime;
foreach (CommissionRequestModel item in splittinDrawsExportData)
{
stringBuilder2.Append("<tr>");
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ReferralUserName, true));
StringBuilder stringBuilder3 = stringBuilder2;
dateTime = item.RequestDate;
stringBuilder3.Append(ExcelHelper.GetXLSFieldsTD(dateTime.ToString("yyyy-MM-dd HH:mm:ss"), false));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.Amount.F2ToString("f2"), false));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ManagerUserName, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.Remark, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.AccountInfo, true));
stringBuilder2.Append("</tr>");
}
stringBuilder.AppendFormat("<tbody>{0}</tbody></table>", stringBuilder2.ToString());
StringWriter stringWriter = new StringWriter();
stringWriter.Write(stringBuilder);
HttpResponse response = context.Response;
StringBuilder stringBuilder4 = stringWriter.GetStringBuilder();
dateTime = DateTime.Now;
DownloadHelper.DownloadFile(response, stringBuilder4, "SplittinDraws" + dateTime.ToString("yyyyMMddhhmmss") + ".xls");
stringWriter.Close();
context.Response.End();
}
public DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query, bool IsAdmin = true)
{
if (query == null)
{
return new DbQueryResult();
}
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string text = this.BuildBalanceDrawRequestQuery(query);
stringBuilder.Append("SELECT *");
stringBuilder.Append(" FROM Hishop_BalanceDrawRequest B WHERE 0=0 ");
if (IsAdmin)
{
text += " AND IsPass IS NULL ";
}
switch (query.DrawRequestType)
{
case 1:
text += " AND IsWeixin <> 1 AND IsAlipay <> 1";
break;
case 2:
text += " AND IsWeixin = 1 ";
break;
case 3:
text += " AND IsAlipay = 1";
break;
}
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text);
if (query.IsCount)
{
stringBuilder.AppendFormat(";SELECT COUNT(*) AS TOTAL FROM Hishop_BalanceDrawRequest WHERE 0=0 {0}", text);
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = base.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
return dbQueryResult;
}
private void BindData()
{
BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery();
balanceDrawRequestQuery.RequestTime = "";
balanceDrawRequestQuery.CheckTime = "";
balanceDrawRequestQuery.StoreName = this.StoreName;
balanceDrawRequestQuery.PageIndex = this.pager.PageIndex;
balanceDrawRequestQuery.PageSize = this.pager.PageSize;
balanceDrawRequestQuery.SortOrder = SortAction.Desc;
balanceDrawRequestQuery.SortBy = "SerialID";
balanceDrawRequestQuery.RequestEndTime = this.RequestEndTime;
balanceDrawRequestQuery.RequestStartTime = this.RequestStartTime;
balanceDrawRequestQuery.IsCheck = "";
balanceDrawRequestQuery.UserId = "";
string[] extendChecks = new string[]
{
"3"
};
Globals.EntityCoding(balanceDrawRequestQuery, true);
DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(balanceDrawRequestQuery, extendChecks);
this.reCommissions.DataSource = balanceDrawRequest.Data;
this.reCommissions.DataBind();
this.pager.TotalRecords = balanceDrawRequest.TotalRecords;
System.Data.DataTable drawRequestNum = DistributorsBrower.GetDrawRequestNum(new int[]
{
0,
1
});
int num = 0;
if (drawRequestNum.Rows.Count > 0)
{
for (int i = 0; i < drawRequestNum.Rows.Count; i++)
{
num += Globals.ToNum(drawRequestNum.Rows[i]["num"]);
}
this.Frist.Text = "待发放(" + num.ToString() + ")";
}
this.Second.Text = "发放异常(" + this.pager.TotalRecords + ")";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(this.Page.Request.QueryString["JournalNumber"], out this.journalNumber))
{
base.GotoResourceNotFound();
}
else if (!this.Page.IsPostBack)
{
this.lblUserName.Text = this.Page.Request.QueryString["Name"].ToNullString();
BalanceDrawRequestQuery query = new BalanceDrawRequestQuery
{
JournalNumber = this.journalNumber,
PageSize = 1,
PageIndex = 1,
IsCount = false
};
DbQueryResult splittinDraws = MemberHelper.GetSplittinDraws(query, null);
if (splittinDraws != null && splittinDraws.Data.Rows.Count > 0)
{
DataRow dataRow = splittinDraws.Data.Rows[0];
this.lblAlipayCode.Text = dataRow["AlipayCode"].ToNullString();
this.lblAlipayRealName.Text = dataRow["AlipayRealName"].ToNullString();
this.lblAccountName.Text = dataRow["AccountName"].ToNullString();
this.lblBankName.Text = dataRow["BankName"].ToNullString();
this.lblMerchantCode.Text = dataRow["MerchantCode"].ToNullString();
this.lblMoney.Text = dataRow["Amount"].ToDecimal(0).ToString("0.00");
this.LabRemark.Text = dataRow["ManagerRemark"].ToNullString();
if (dataRow["IsAlipay"].ToBool())
{
this.isAlipay = true;
}
if (dataRow["IsWeixin"].ToBool())
{
this.isWeixin = true;
}
if (dataRow["IsWithdrawToAccount"].ToBool())
{
this.isWithdrawToAccount = true;
}
}
}
}
public void BindBalanceDrawRequest()
{
BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery();
if (this.userId > 0)
{
balanceDrawRequestQuery.UserId = new int?(this.userId);
}
balanceDrawRequestQuery.UserName = this.userName;
balanceDrawRequestQuery.FromDate = this.dateStart;
balanceDrawRequestQuery.ToDate = this.dateEnd;
balanceDrawRequestQuery.PageIndex = this.pager.PageIndex;
balanceDrawRequestQuery.PageSize = this.pager.PageSize;
DbQueryResult balanceDrawRequests = UnderlingHelper.GetBalanceDrawRequests(balanceDrawRequestQuery);
this.grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data;
this.grdBalanceDrawRequest.DataBind();
this.pager.TotalRecords = balanceDrawRequests.TotalRecords;
this.pager1.TotalRecords = balanceDrawRequests.TotalRecords;
}
public void BindBalanceDrawRequest()
{
BalanceDrawRequestQuery query = new BalanceDrawRequestQuery();
if (userId > 0)
{
query.UserId = new int?(userId);
}
query.UserName = userName;
query.FromDate = dateStart;
query.ToDate = dateEnd;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
DbQueryResult balanceDrawRequests = UnderlingHelper.GetBalanceDrawRequests(query);
grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data;
grdBalanceDrawRequest.DataBind();
pager.TotalRecords = balanceDrawRequests.TotalRecords;
pager1.TotalRecords = balanceDrawRequests.TotalRecords;
}
private void BindData()
{
BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery();
balanceDrawRequestQuery.RequestTime = "";
balanceDrawRequestQuery.CheckTime = "CheckTime";
balanceDrawRequestQuery.RequestStartTime = this.RequestStartTime;
balanceDrawRequestQuery.RequestEndTime = this.RequestEndTime;
balanceDrawRequestQuery.StoreName = this.StoreName;
balanceDrawRequestQuery.PageIndex = this.pager.PageIndex;
balanceDrawRequestQuery.PageSize = this.pager.PageSize;
balanceDrawRequestQuery.SortOrder = SortAction.Desc;
balanceDrawRequestQuery.SortBy = "RequestTime";
balanceDrawRequestQuery.IsCheck = "2";
Globals.EntityCoding(balanceDrawRequestQuery, true);
DbQueryResult balanceDrawRequest = VShopHelper.GetBalanceDrawRequest(balanceDrawRequestQuery);
this.reBalanceDrawRequest.DataSource = balanceDrawRequest.Data;
this.reBalanceDrawRequest.DataBind();
this.pager.TotalRecords = balanceDrawRequest.TotalRecords;
}
public override DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query)
{
DbQueryResult result;
if (null == query)
{
result = null;
}
else
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string text = UnderlingData.BuildBalanceDrawRequestQuery(query);
stringBuilder.AppendFormat("SELECT Top {0} * FROM distro_BalanceDrawRequest B WHERE 0=0", query.PageSize);
if (query.PageIndex == 1)
{
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC;", text);
}
else
{
stringBuilder.AppendFormat(" AND RequestTime < (SELECT MIN(RequestTime) FROM (SELECT TOP {0} RequestTime FROM distro_BalanceDrawRequest WHERE 0=0 {1} ORDER BY RequestTime DESC ) as T) {1} ORDER BY RequestTime DESC;", (query.PageIndex - 1) * query.PageSize, text);
}
if (query.IsCount)
{
stringBuilder.AppendFormat("SELECT COUNT(*) AS Total from distro_BalanceDrawRequest WHERE 0=0 {0}", text);
}
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
result = dbQueryResult;
}
return(result);
}
static string BuildBalanceDrawRequestQuery(BalanceDrawRequestQuery query)
{
StringBuilder builder = new StringBuilder();
if (query.UserId.HasValue)
{
builder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (!string.IsNullOrEmpty(query.UserName))
{
builder.AppendFormat(" AND UserName='******'", DataHelper.CleanSearchString(query.UserName));
}
if (query.FromDate.HasValue)
{
builder.AppendFormat(" AND RequestTime >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
builder.AppendFormat(" AND RequestTime <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value));
}
return(builder.ToString());
}
private void BindData()
{
BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery {
CheckTime = this.CheckTime,
RequestTime = this.RequestTime,
StoreName = this.StoreName,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "UserId",
RequestEndTime = "",
RequestStartTime = "",
IsCheck = ""
};
Globals.EntityCoding(entity, true);
DbQueryResult balanceDrawRequest = VShopHelper.GetBalanceDrawRequest(entity);
this.reBalanceDrawRequest.DataSource = balanceDrawRequest.Data;
this.reBalanceDrawRequest.DataBind();
this.pager.TotalRecords = balanceDrawRequest.TotalRecords;
}
private static string BuildBalanceDrawRequestQuery(BalanceDrawRequestQuery query)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(" AND DistributorUserId = {0}", HiContext.Current.User.UserId);
if (query.UserId.HasValue)
{
builder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (!string.IsNullOrEmpty(query.UserName))
{
builder.AppendFormat(" AND UserId IN (SELECT UserId FROM vw_distro_Members WHERE UserName='******')", DataHelper.CleanSearchString(query.UserName));
}
if (query.FromDate.HasValue)
{
builder.AppendFormat(" AND RequestTime >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
builder.AppendFormat(" AND RequestTime <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value));
}
return(builder.ToString());
}
protected override void AttachChildControls()
{
this.vshopbalancedraw = (VshopTemplatedRepeater)this.FindControl("vshopbalancedraw");
BalanceDrawRequestQuery query = new BalanceDrawRequestQuery {
PageIndex = 1,
PageSize = 0x186a0,
UserId = DistributorsBrower.GetCurrentDistributors().UserId.ToString(),
SortBy = "SerialID",
RequestTime = "",
RequestStartTime = "",
RequestEndTime = "",
CheckTime = "",
IsCheck = "",
SortOrder = SortAction.Desc
};
DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(query);
if (balanceDrawRequest.TotalRecords > 0)
{
this.vshopbalancedraw.DataSource = balanceDrawRequest.Data;
this.vshopbalancedraw.DataBind();
}
}
private void BindData()
{
BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery {
RequestTime = "",
CheckTime = "",
StoreName = this.StoreName,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "SerialID",
RequestEndTime = this.RequestEndTime,
RequestStartTime = this.RequestStartTime,
IsCheck = "0",
UserId = ""
};
Globals.EntityCoding(entity, true);
DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(entity, null);
this.reBalanceDrawRequest.DataSource = balanceDrawRequest.Data;
this.reBalanceDrawRequest.DataBind();
this.pager.TotalRecords = balanceDrawRequest.TotalRecords;
}
public DbQueryResult GetBalanceDrawRequest(BalanceDrawRequestQuery query)
{
StringBuilder builder = new StringBuilder();
if (!string.IsNullOrEmpty(query.StoreName))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" StoreName LIKE '%{0}%'", DataHelper.CleanSearchString(query.StoreName));
}
if (!string.IsNullOrEmpty(query.UserId))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" UserId = {0}", DataHelper.CleanSearchString(query.UserId));
}
if (!string.IsNullOrEmpty(query.RequestTime.ToString()))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" convert(varchar(10),RequestTime,120)='{0}'", query.RequestTime);
}
if (!string.IsNullOrEmpty(query.IsCheck.ToString()))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" IsCheck={0}", query.IsCheck);
}
if (!string.IsNullOrEmpty(query.CheckTime.ToString()))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" convert(varchar(10),CheckTime,120)='{0}'", query.CheckTime);
}
if (!string.IsNullOrEmpty(query.RequestStartTime.ToString()))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" datediff(dd,'{0}',RequestTime)>=0", query.RequestStartTime);
}
if (!string.IsNullOrEmpty(query.RequestEndTime.ToString()))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" datediff(dd,'{0}',RequestTime)<=0", query.RequestEndTime);
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_BalanceDrawRequesDistributors ", "SerialID", (builder.Length > 0) ? builder.ToString() : null, "*");
}
public static DbQueryResult GetBalanceDrawRequest(BalanceDrawRequestQuery query)
{
return new DistributorsDao().GetBalanceDrawRequest(query);
}
