public ActionResult SaveForm(string keyValue, SalePlanEntity entity)
{
try
{
if (keyValue != "")
{
entity.SalePlanId = keyValue;
SalePlanBLL.Instance.Update(entity);
}
else
{
entity.SalePlanId = Util.Util.NewUpperGuid();
entity.PlanStatus = (int)Trade.Model.Enums.PlanStatus.已生效;
SalePlanBLL.Instance.Add(entity);
}
return(Success("保存成功"));
}
catch (Exception ex)
{
ex.Data["Method"] = "SalePlanController>>SaveForm";
new ExceptionHelper().LogException(ex);
return(Error("保存失败"));
}
}
public ActionResult GetPageListJson(Pagination pagination, string queryJson)
{
var watch = CommonHelper.TimerStart();
var queryParam = queryJson.ToJObject();
var para = new SalePlanEntity();
if (!queryParam["keyword"].IsEmpty())
{
para.PlanTitle = queryParam["keyword"].ToString();
}
if (!queryParam["StartTime"].IsEmpty())
{
para.StartTime = queryParam["StartTime"].ToString();
}
if (!queryParam["EndTime"].IsEmpty())
{
para.EndTime = queryParam["EndTime"].ToString();
}
var pageList = new List <SalePlanEntity>();
try
{
//数据对象
pageList = SalePlanBLL.Instance.GetPageList(para, ref pagination);
}
catch (Exception ex)
{
}
var JsonData = new
{
rows = pageList,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(Content(JsonData.ToJson()));
}
/// <summary>
/// 导出EXCEL
/// </summary>
public void ExportExcel(string queryJson)
{
string cacheKey = Request["cacheid"] as string;
HttpRuntime.Cache[cacheKey + "-state"] = "processing";
HttpRuntime.Cache[cacheKey + "-row"] = "0";
try
{
//这里要url解码
var queryParam = Server.UrlDecode(queryJson).ToJObject();
var para = new SalePlanEntity();
if (!queryParam["keyword"].IsEmpty())
{
para.PlanTitle = queryParam["keyword"].ToString();
}
if (!queryParam["StartTime"].IsEmpty())
{
para.StartTime = queryParam["StartTime"].ToString();
}
if (!queryParam["EndTime"].IsEmpty())
{
para.EndTime = queryParam["EndTime"].ToString();
}
List <SalePlanExportEntity> listnew = new List <SalePlanExportEntity>();
var list = SalePlanBLL.Instance.GetList(para);
if (list != null)
{
foreach (var o in list)
{
//明细
var detailList = SalePlanDetaiBLL.Instance.GetList(new SalePlanDetaiEntity()
{
SalePlanId = o.SalePlanId
});
foreach (var detailitem in detailList)
{
SalePlanExportEntity entity = new SalePlanExportEntity();
entity.PlanTitle = o.PlanTitle.ToString();
entity.StartTime = o.SaleStartTime.ToString();
entity.EndTime = o.SaleEndTime.ToString();
entity.Remark = o.Remark;
entity.ProductPrice = detailitem.Price.ToString();
var product = ProductBLL.Instance.GetEntity(detailitem.ProductId);
if (product != null)
{
entity.ProductNO = product.ProductNO;
entity.ProductName = product.ProductName;
entity.ProductPrice = product.ProductPrice.ToString();
}
listnew.Add(entity);
}
}
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.Title = "销售计划列表";
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 10;
excelconfig.FileName = "销售计划列表.xls";
excelconfig.IsAllSizeColumn = true;
//每一列的设置,没有设置的列信息，系统将按datatable中的列名导出
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "PlanTitle", ExcelColumn = "计划名称", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "StartTime", ExcelColumn = "开始时间", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "EndTime", ExcelColumn = "结束时间", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Remark", ExcelColumn = "备注", Width = 10
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "ProductNO", ExcelColumn = "产品编号", Width = 10
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "ProductName", ExcelColumn = "产品名称", Width = 10
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "ProductPrice", ExcelColumn = "产品价格", Width = 10
});
//需合并索引
excelconfig.MergeRangeIndexArr = new int[] { 0, 1, 2, 3 };
//调用导出方法
ExcelHelper <SalePlanExportEntity> .ExcelDownload(listnew, excelconfig);
HttpRuntime.Cache[cacheKey + "-state"] = "done";
}
}
catch (Exception ex)
{
HttpRuntime.Cache[cacheKey + "-state"] = "error";
}
}
