private ReturnsApplyQuery GetReturnsQuery()
{
ReturnsApplyQuery returnsApplyQuery = new ReturnsApplyQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OrderId"]))
{
returnsApplyQuery.OrderId = Globals.UrlDecode(this.Page.Request.QueryString["OrderId"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["HandleStatus"]))
{
int num = 0;
if (int.TryParse(this.Page.Request.QueryString["HandleStatus"], out num) && num > -1)
{
returnsApplyQuery.HandleStatus = new int?(num);
}
}
returnsApplyQuery.PageIndex = this.pager.PageIndex;
returnsApplyQuery.PageSize = this.pager.PageSize;
returnsApplyQuery.SortBy = "ApplyForTime";
returnsApplyQuery.SortOrder = SortAction.Desc;
return(returnsApplyQuery);
}
private ReturnsApplyQuery GetDataQuery(HttpContext context)
{
ReturnsApplyQuery returnsApplyQuery = new ReturnsApplyQuery();
returnsApplyQuery.OrderId = base.GetParameter(context, "OrderId", true);
returnsApplyQuery.HandleStatus = base.GetIntParam(context, "HandleStatus", true);
int?intParam = base.GetIntParam(context, "SupplierId", true);
if (intParam.HasValue)
{
returnsApplyQuery.SupplierId = intParam.Value;
}
else
{
returnsApplyQuery.SupplierId = -1;
}
returnsApplyQuery.PageIndex = base.CurrentPageIndex;
returnsApplyQuery.PageSize = base.CurrentPageSize;
returnsApplyQuery.SortBy = "ApplyForTime";
returnsApplyQuery.SortOrder = SortAction.Desc;
return(returnsApplyQuery);
}
public DbQueryResult GetReturnsApplysMoney(ReturnsApplyQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1");
if (!string.IsNullOrEmpty(query.OrderId))
{
stringBuilder.AppendFormat(" and OrderId = '{0}'", query.OrderId);
}
if (query.HandleStatus.HasValue)
{
stringBuilder.AppendFormat(" AND HandleStatus = {0}", query.HandleStatus);
}
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (!string.IsNullOrEmpty(query.StratTime))
{
stringBuilder.AppendFormat(" and ApplyForTime>='{0}'", query.StratTime);
}
if (!string.IsNullOrEmpty(query.EndTime))
{
stringBuilder.AppendFormat(" and ApplyForTime<='{0} 23:59:59'", query.EndTime.Trim());
}
if (!string.IsNullOrEmpty(query.Operator))
{
stringBuilder.AppendFormat(" AND Operator LIKE '%{0}%'", DataHelper.CleanSearchString(query.Operator));
}
if (query.SupplierId.HasValue && query.SupplierId.Value > 0)
{
stringBuilder.AppendFormat(" AND OrderId IN (SELECT OrderId FROM Ecshop_OrderItems WHERE SupplierId ={0})", query.SupplierId.Value);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Ecshop_OrderReturns", "ReturnsId", stringBuilder.ToString(), "*"));
}
private void BindReturns()
{
ReturnsApplyQuery returnsQuery = this.GetReturnsQuery();
DbQueryResult returnsApplys = OrderHelper.GetReturnsApplysMoney(returnsQuery);
this.dlstReturns.DataSource = returnsApplys.Data;
this.dlstReturns.DataBind();
this.pager.TotalRecords = returnsApplys.TotalRecords;
this.pager1.TotalRecords = returnsApplys.TotalRecords;
this.txtOrderId.Text = returnsQuery.OrderId;
this.txtHandler.Text = returnsQuery.Operator;
this.calendarEndDate.Text = returnsQuery.EndTime;
this.calendarStartDate.Text = returnsQuery.StratTime;
this.ddlHandleStatus.SelectedIndex = 0;
if (returnsQuery.HandleStatus.HasValue && returnsQuery.HandleStatus.Value > -1)
{
this.ddlHandleStatus.SelectedValue = returnsQuery.HandleStatus.Value.ToString();
}
if (returnsQuery.SupplierId.HasValue && returnsQuery.SupplierId.Value > 0)
{
this.ddlSupplier.SelectedValue = returnsQuery.SupplierId;
}
}
public static DbQueryResult GetReturnsApplys(ReturnsApplyQuery query)
{
return(SalesProvider.Instance().GetReturnsApplys(query));
}
public static DbQueryResult GetReturnOrderAll(ReturnsApplyQuery returnsapplyquery)
{
return(new RefundDao().GetReturnOrderAll(returnsapplyquery));
}
public abstract DbQueryResult GetReturnsApplys(ReturnsApplyQuery query, int userId);
public abstract DbQueryResult GetReturnsApplys(ReturnsApplyQuery query);
public void ExportToExcel(HttpContext context)
{
ReturnsApplyQuery dataQuery = this.GetDataQuery(context);
dataQuery.ReturnIds = context.Request["Ids"].ToNullString();
IList <ReturnInfo> returnApplysNoPage = OrderHelper.GetReturnApplysNoPage(dataQuery);
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("<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 (ReturnInfo item in returnApplysNoPage)
{
DateTime?handleTime = this.GetHandleTime(item);
stringBuilder2.Append("<tr>");
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ReturnId, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.UserName, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.OrderId, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ApplyForTime, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD((item.SupplierId > 0) ? SupplierHelper.GetSupplierName(item.SupplierId) : "平台店", true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(EnumDescription.GetEnumDescription((Enum)(object)item.HandleStatus, 0), true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ReturnReason, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ShopName + "(" + item.Quantity + ")", true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.RefundAmount, false));
StringBuilder stringBuilder3 = stringBuilder2;
object argFields;
if (!handleTime.HasValue)
{
dateTime = handleTime.Value;
argFields = dateTime.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
argFields = "";
}
stringBuilder3.Append(ExcelHelper.GetXLSFieldsTD(argFields, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(EnumDescription.GetEnumDescription((Enum)(object)item.RefundType, 0), 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, "ReturnApplys" + dateTime.ToString("yyyyMMddhhmmss") + ".xls");
stringWriter.Close();
context.Response.End();
}
public static DbQueryResult GetReturnsApplys(ReturnsApplyQuery query, int userId)
{
return(TradeProvider.Instance().GetReturnsApplys(query, userId));
}
public PageModel <ReturnInfo> GetReturnsApplys(ReturnsApplyQuery query)
{
query.OrderId = base.GetTrueOrderId(query.OrderId);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1");
if (!string.IsNullOrEmpty(query.OrderId))
{
stringBuilder.AppendFormat(" AND OrderId = '{0}'", query.OrderId);
}
if (query.SupplierId.HasValue)
{
if (query.SupplierId == -1)
{
stringBuilder.Append(" AND SupplierId > 0 ");
}
else
{
stringBuilder.AppendFormat(" AND SupplierId = {0} ", query.SupplierId.Value);
}
}
else if (query.UserId.ToInt(0) <= 0)
{
stringBuilder.Append(" and ISNULL(SupplierId,0)=0 ");
}
if (query.HandleStatus.HasValue)
{
if (query.HandleStatus.Value != 6)
{
stringBuilder.AppendFormat(" AND HandleStatus = {0}", query.HandleStatus);
}
else
{
stringBuilder.AppendFormat(" AND (HandleStatus = {0} OR HandleStatus = {1} OR (HandleStatus = {2} AND AfterSaleType = {3})) AND ExceptionInfo IS NOT NULL AND ExceptionInfo <>''", 4, 5, 0, 3);
}
}
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (query.StoreId.HasValue && query.StoreId > 0)
{
stringBuilder.AppendFormat(" AND StoreId = {0}", query.StoreId.Value);
}
if (query.IsNoCompleted.HasValue && query.IsNoCompleted.Value)
{
stringBuilder.AppendFormat(" AND HandleStatus <> {0} AND HandleStatus <> {1}", 2, 1);
}
if (query.SupplierNoCompleted.HasValue && query.SupplierNoCompleted.Value)
{
stringBuilder.AppendFormat(" AND (HandleStatus = {0} OR HandleStatus = {1})", 0, 5);
}
if (query.ReturnId.HasValue)
{
stringBuilder.AppendFormat(" AND ReturnId = {0}", query.ReturnId.Value);
}
if (!string.IsNullOrEmpty(query.ProductName))
{
stringBuilder.AppendFormat(" AND ShopName LIKE '%{0}%'", query.ProductName);
}
return(DataHelper.PagingByRownumber <ReturnInfo>(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_OrderReturns", "ReturnId", stringBuilder.ToString(), "*"));
}
public IList <ReturnInfo> GetReturnApplysNoPage(ReturnsApplyQuery query)
{
query.OrderId = base.GetTrueOrderId(query.OrderId);
IList <ReturnInfo> result = new List <ReturnInfo>();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" 1=1");
if (!string.IsNullOrEmpty(query.OrderId))
{
stringBuilder.AppendFormat(" AND OrderId = '{0}'", query.OrderId);
}
if (query.SupplierId.HasValue)
{
if (query.SupplierId == -1)
{
stringBuilder.Append(" AND SupplierId > 0 ");
}
else
{
stringBuilder.AppendFormat(" AND SupplierId = {0} ", query.SupplierId.Value);
}
}
else if (query.UserId.ToInt(0) <= 0)
{
stringBuilder.Append(" and ISNULL(SupplierId,0)=0 ");
}
if (query.HandleStatus.HasValue)
{
stringBuilder.AppendFormat(" AND HandleStatus = {0}", query.HandleStatus);
}
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (query.StoreId.HasValue && query.StoreId > 0)
{
stringBuilder.AppendFormat(" AND StoreId = {0}", query.StoreId.Value);
}
if (query.IsNoCompleted.HasValue && query.IsNoCompleted.Value)
{
stringBuilder.AppendFormat(" AND HandleStatus <> {0} AND HandleStatus <> {1}", 2, 1);
}
if (query.SupplierNoCompleted.HasValue && query.SupplierNoCompleted.Value)
{
stringBuilder.AppendFormat(" AND (HandleStatus = {0} OR HandleStatus = {1})", 0, 5);
}
if (query.ReturnId.HasValue)
{
stringBuilder.AppendFormat(" AND ReturnId = {0}", query.ReturnId.Value);
}
if (!string.IsNullOrEmpty(query.ProductName))
{
stringBuilder.AppendFormat(" AND ShopName LIKE '%{0}%'", query.ProductName);
}
if (!string.IsNullOrEmpty(query.ReturnIds))
{
stringBuilder.Append($" AND ReturnId IN({query.ReturnIds}) ");
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand("SELECT * FROM vw_Hishop_OrderReturns WHERE " + stringBuilder.ToString());
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
result = DataHelper.ReaderToList <ReturnInfo>(objReader);
}
return(result);
}
private void btnCreateReport_Click(object sender, System.EventArgs e)
{
ManagerHelper.CheckPrivilege(Privilege.ReturnOrderExcel);
ReturnsApplyQuery returnsApplyQuery = new ReturnsApplyQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OrderId"]))
{
returnsApplyQuery.OrderId = Globals.UrlDecode(this.Page.Request.QueryString["OrderId"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StartDate"]))
{
returnsApplyQuery.StratTime = Globals.UrlDecode(this.Page.Request.QueryString["StartDate"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["EndDate"]))
{
returnsApplyQuery.EndTime = Globals.UrlDecode(this.Page.Request.QueryString["EndDate"]);
}
returnsApplyQuery.HandleStatus = new int?(1);
returnsApplyQuery.SortBy = "HandleTime";
returnsApplyQuery.SortOrder = SortAction.Desc;
DataSet returnsApplys = OrderHelper.ExportReturnsApplys(returnsApplyQuery);
StringBuilder sbstr = new StringBuilder();
string text = string.Empty;
sbstr.Append("退货单号");
sbstr.Append(",订单号");
sbstr.Append(",会员");
sbstr.Append(",退货备注");
sbstr.Append(",退款金额(元)");
sbstr.Append(",退货时间");
sbstr.Append(",操作人");
sbstr.Append(",管理员备注\r\n");
foreach (System.Data.DataRow dataRow in returnsApplys.Tables[0].Rows)
{
sbstr.Append("`" + dataRow["ReturnsId"]);
sbstr.Append(",`" + dataRow["OrderId"]);
sbstr.Append(",`" + dataRow["Username"]);
sbstr.Append(",`" + (StringExtension.ClearForJson(dataRow["Comments"].ToString().Replace(",", "，"))));
sbstr.Append(",`" + dataRow["RefundMoney"]);
sbstr.Append(",`" + dataRow["HandleTime"]);
sbstr.Append(",`" + (StringExtension.ClearForJson(dataRow["Operator"].ToString().Replace(",", "，"))));
sbstr.Append(",`" + (StringExtension.ClearForJson(dataRow["AdminRemark"].ToString().Replace(",", "，"))) + "\r\n");
}
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
if (this.calendarStartDate.SelectedDate.HasValue && this.calendarEndDate.SelectedDate.HasValue)
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=退货单_" + this.calendarStartDate.SelectedDate.Value.ToString("yyyyMMdd") + "-" + this.calendarEndDate.SelectedDate.Value.ToString("yyyyMMdd") + ".csv");
}
else
{
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=退货单.csv");
}
//this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=ManageReturnNote.csv");
this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/octet-stream";
this.Page.EnableViewState = false;
this.Page.Response.Write(sbstr.ToString());
this.Page.Response.End();
}
