public int AddReport(AVGD.Rpt.Areas.Admin.Models.FormValue value)
{
rpt_categorydetail rpt = new rpt_categorydetail();
rpt.Id = value.report;
rpt.Detailedname = value.reportname;
rpt.Order = value.sorttype;
rpt.Cateoryid = value.categoryId;
rpt.Sort = value.sortcolumn;
rpt.Sqlvalue = value.sqlvalue;
rpt.Total = value.totalcolumn;
_db.rpt_categorydetail.Add(rpt);
return(_db.SaveChanges());
}
public int RemoveReport(string report)
{
if (report.IsEmpty())
{
return(0);
}
rpt_categorydetail rpt = _db.rpt_categorydetail.Where(r => r.Id == report).FirstOrDefault();
if (rpt != null)
{
_db.rpt_categorydetail.Remove(rpt);
return(_db.SaveChanges());
}
return(0);
}
public int UpdateCategoryMessage(AVGD.Rpt.Areas.Admin.Models.FormValue detail)
{
rpt_categorydetail rpt_categorydetail = _db.rpt_categorydetail.Where(category => category.Id == detail.report).FirstOrDefault();
if (rpt_categorydetail != null)
{
_db.rpt_categorydetail.Attach(rpt_categorydetail);
rpt_categorydetail.Order = detail.sorttype;
rpt_categorydetail.Sqlvalue = detail.sqlvalue;
rpt_categorydetail.Sort = detail.sortcolumn;
rpt_categorydetail.Total = detail.totalcolumn;
return(_db.SaveChanges());
}
return(0);
}
/// <summary>
/// 获取报表对应的Sql语句
/// </summary>
/// <param name="report">报表Id</param>
/// <param name="isFillter">是否筛选 是（获取保存当前的sql的session 导出数据需要） 否 （从数据库中找默认选出所有的sql语句）</param>
/// <returns>Sql语句</returns>
public string GetSqlValue(string report, bool isFillter = false /*如果是高级查询 顶部查询 应该为true*/)
{
if (SessionHelper.GetSqlValue().IsNotEmpty() && isFillter)
{
return(SessionHelper.GetSqlValue());
}
if (report.IsNotEmpty())
{
rpt_categorydetail categoryDetail = GetCategoryDetail(report);
if (categoryDetail != null && categoryDetail.Sqlvalue.IsNotEmpty())
{
return(categoryDetail.Sqlvalue);
}
}
return("");
}
//[GZipOrDeflate]
public ActionResult Category(string report, string title)
{
if (report.IsEmpty())
{
return(Redirect("/Report/Index"));
}
CommondController commond = new CommondController(_db);
rpt_categorydetail categoryDetail = commond.GetCategoryDetail(report);
string sqlValue = null;
if (HttpContext.Request.QueryString["CustomQuery"] != null)
{
sqlValue = SessionHelper.GetSqlValue().IsEmpty() ? categoryDetail.Sqlvalue : SessionHelper.GetSqlValue();
}
if (HttpContext.Request.QueryString["RestSetUp"] == null && HttpContext.Request.QueryString["CustomQuery"] == null)
{
SessionHelper.RestSqlValue();
SessionHelper.RestTotalName();
}
if (categoryDetail == null)
{
BugLog.Write("report=------" + report);
throw new ArgumentException("报表类别为空 请联系管理员;");
}
DataTable T = commond.GetDataTableOneRow(sqlValue ?? categoryDetail.Sqlvalue);
#region T 不为空的时候
if (T != null && T.Rows.Count > 0)
{
var CName = T.Columns.Cast <DataColumn>().Select(x => x.ColumnName).ToArray();
var CType = T.Columns.Cast <DataColumn>().Select(x => x.DataType.FullName).ToArray();
ViewBag.ColumnName = CName;
ViewBag.ColumnType = CType;
ViewBag.Total = categoryDetail.Total.IsEmpty() ? "" : categoryDetail.Total;
ViewBag.zdString = string.Join(",", CName);
ViewBag.lxString = string.Join(",", CType);
ViewBag.排序字段 = categoryDetail.Sort.IsEmpty() ? CName[0] : CName.Contains(categoryDetail.Sort) ? categoryDetail.Sort : CName[0];
ViewBag.排序方式 = categoryDetail.Order.IsEmpty() ? "desc" : categoryDetail.Order;
ViewBag.显示的类型 = "System.TimeSpan,System.Byte[]";
ViewBag.Title = categoryDetail.Detailedname ?? title;
ViewBag.report = categoryDetail.Id;
}
#endregion
return(View());
}
private ActionResult TotalMethod(PageList pageList, TotalType totalTypes)
{
if (pageList.report.IsEmpty())
{
return(Content("参数不能为空"));
}
CommondController commond = new CommondController(_db);
rpt_categorydetail categoryDetail = commond.GetCategoryDetail(pageList.report);
if (categoryDetail == null)
{
return(Content("参数出错"));
}
string sqlValue = string.Empty;
if (totalTypes == TotalType.PageTotal)
{
sqlValue = Session["LimitSqlValue"].ToString() ?? "";
}
else if (totalTypes == TotalType.TableTotal)
{
sqlValue = commond.GetSqlValue(pageList.report, isFillter: true); /*TODO: isFillter:true TotalMethod*/
}
else
{
return(Content("错误的请求类型"));
}
if (sqlValue.IsNotEmpty())
{
string orderCountSql = commond.GetOrderCountSqlValue(sqlValue);
pageList.total = categoryDetail.Total;
string[] totalList = categoryDetail.Total.Split(',');
ViewBag.columnname = totalList;
string sum = totalList.sumField();
sqlValue = string.Format("select {0} from ({1}) xiaoji", sum, sqlValue);
DataSet ds = commond.GetDataSet(orderCountSql + ";" + sqlValue);
return(PartialView("_PartialTotal", ds));
}
return(Content("sql语句为空"));
}
public ActionResult Index([Bind(Include = "report,title")] PageList pagelist)
{
if (!string.IsNullOrWhiteSpace(pagelist.report))
{
AdminDALController adminDAL = new AdminDALController(_db);
rpt_categorydetail categoryDetail = adminDAL.GetCategoryDetail(pagelist.report);
if (categoryDetail != null)
{
ViewBag.报表类型 = categoryDetail.Id;
ViewBag.报表名称 = categoryDetail.Detailedname;
ViewBag.报表sql语句 = categoryDetail.Sqlvalue;
ViewBag.统计字段 = categoryDetail.Total;
ViewBag.排序字段 = categoryDetail.Sort;
ViewBag.排序方式 = categoryDetail.Order;
}
}
ViewBag.report = pagelist.report;
ViewBag.Title = pagelist.title;
return(View());
}
public int EditReport(AVGD.Rpt.Areas.Admin.Models.FormValue value)
{
if (value.report.IsEmpty())
{
return(0);
}
rpt_categorydetail rpt = _db.rpt_categorydetail.Where(r => r.Id == value.report).FirstOrDefault();
if (rpt != null)
{
_db.rpt_categorydetail.Attach(rpt);
rpt.Detailedname = value.reportname;
rpt.Cateoryid = value.categoryId;
rpt.Order = value.sorttype;
rpt.Sort = value.sortcolumn;
rpt.Sqlvalue = value.sqlvalue;
rpt.Total = value.totalcolumn;
return(_db.SaveChanges());
}
return(0);
}
