public ActionResult Editreport()
{
var data = new AVGD.Rpt.Areas.Admin.Models.FormValue
{
reportname = Request.Form["报表名称"],
sqlvalue = Request.Form["报表sql值"],
categoryId = Convert.ToInt32(Request.Form["报表类别"]),
totalcolumn = Request.Form["统计字段"],
sortcolumn = Request.Form["排序字段"],
sorttype = Request.Form["排序方式"],
report = Request.Form["report"]
};
#region 检验输入的sql语句是否安全
if (!checkSql(data.sqlvalue))
{
return(Content("错误!"));
}
#endregion
int rowEf = new AdminDALController(_db).EditReport(data);
if (1 == rowEf)
{
return(Content("ok"));
}
return(Content("no"));
}
//[BackMangerMYSQLInject]
public ActionResult UpdateMessage()
{
var data = new AVGD.Rpt.Areas.Admin.Models.FormValue
{
sqlvalue = Request.Form["报表sql语句"],
totalcolumn = Request.Form["统计字段"],
sortcolumn = Request.Form["排序字段"],
sorttype = Request.Form["排序方式"],
report = Request.Form["report"]
};
#region 检验输入的sql语句是否安全
if (!checkSql(data.sqlvalue))
{
return(Content("错误!"));
}
#endregion
AdminDALController adminDAL = new AdminDALController(_db);
int rowEf = adminDAL.UpdateCategoryMessage(data);
if (1 == rowEf)
{
return(Content("ok"));
}
//LogHelper.WriteLog(typeof(rptedsmallController), "admin home updatemessage" + data);
return(Content("错误!"));
}
public ActionResult getonerowjson(string report)
{
List <rpt_categorydetail> list = new List <rpt_categorydetail>();
AdminDALController adminDAL = new AdminDALController(_db);
list.Add(adminDAL.GetCategoryDetail(report));
return(Json(new { rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetReportColumn(string report)
{
List <rpt_column> list = null;
AdminDALController adminDAL = new AdminDALController(_db);
list = adminDAL.GetReportColumn(report);
return(Json(new { rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult Removereport()
{
var report = Request.Form["report"];
int rowEf = new AdminDALController(_db).RemoveReport(report);
if (1 == rowEf)
{
return(Content("ok"));
}
return(Content("no"));
}
public ActionResult SetUpEditWinDelete()
{
var data = new SetupFormValue
{
Id = Request.Form["Id"]
};
AdminDALController adminDAL = new AdminDALController(_db);
int rowEf = adminDAL.SetUpEditWinDelete(data);
if (1 == rowEf)
{
return(Content("ok"));
}
return(Content("删除出错,请联系管理员!"));
}
public ActionResult RemoveCategory()
{
int id = -1;
int.TryParse(Request.Form["主键"], out id);
AdminDALController adminDal = new AdminDALController(_db);
int rowEf = adminDal.DeleteCategory(new Category {
Id = id
});
if (1 == rowEf)
{
return(Content("ok"));
}
return(Content("no"));
}
public ActionResult EditCategory()
{
var data = new Category
{
Id = Convert.ToInt32(Request.Form["主键"]),
CategoryName = Request.Form["类别名"]
};
AdminDALController adminDal = new AdminDALController(_db);
int rowEf = adminDal.UpdateCategory(data);
if (1 == rowEf)
{
return(Content("ok"));
}
return(Content("no"));
}
public ActionResult NewCategory()
{
var data = new Category
{
CategoryName = Request.Form["类别名"]
};
AdminDALController adminDal = new AdminDALController(_db);
int rowEf = adminDal.AddCategory(data);
if (1 == rowEf)
{
return(Content("ok"));
}
return(Content("no"));
}
public ActionResult SetUpEditWinAdd()
{
var data = new SetupFormValue
{
reportcolumn = Request.Form["报表列名"],
reportvalue = Request.Form["列名的值"],
report = Request.Form["report"]
};
AdminDALController adminDAL = new AdminDALController(_db);
int rowEf = adminDAL.SetUpEditWinAdd(data);
if (1 == rowEf)
{
return(Content("ok"));
}
return(Content("新增出错,请联系管理员!"));
}
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 ActionResult GetAllReportJson()
{
AdminDALController adminDAL = new AdminDALController(_db);
return(Json(new { rows = adminDAL.GetAllReport() }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetAllCategoryJson()
{
AdminDALController adminDAL = new AdminDALController(_db);
return(Json(new { rows = adminDAL.GetAllCategoryDetail() }, JsonRequestBehavior.AllowGet));
}
