/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Show(int id) { if (id < 1) { return(ShowAlert("请选择正确的报表")); } try { BF_CHART_REPORT.Entity entity = BF_CHART_REPORT.Instance.GetEntityByKey <BF_CHART_REPORT.Entity>(id); if (entity == null) { return(ShowAlert("报表不存在")); } if (entity.IS_ENABLE != 1) { return(ShowAlert("报表已被禁用")); } ViewBag.DB_ID = entity.DB_ID; ViewBag.SQL_CODE = Base.Encrypt.BAES.Encrypt(entity.SQL_CODE); ViewBag.CHART_CODE = Base.Encrypt.BAES.Encrypt(entity.CHART_CODE); ViewBag.TOP_CODE = entity.TOP_CODE; ViewBag.BOTTOM_CODE = entity.BOTTOM_CODE; return(View()); } catch (Exception ex) { BLog.Write(BLog.LogLevel.WARN, "查询报表[" + id + "]出现未知错误:" + ex.Message); return(ShowAlert("查询报表出现未知错误:" + ex.Message)); } }
/// <summary> /// 以json串返回sql查询结果集(含内置参数的替换) /// </summary> /// <param name="sqlE"></param> /// <returns></returns> public ActionResult GetDataBySql(Models.FW.SqlExcute sqlE) { BF_CHART_REPORT.Entity entity = new BF_CHART_REPORT.Entity(); entity.ID = 0; entity.DB_ID = sqlE.DB_ID; entity.SQL_CODE = sqlE.SQL_CODE; List <object> paraList = new List <object>(); string sql = BF_CHART_REPORT.GenerateSQL(entity, null, out paraList); DataTable dt = BF_CHART_REPORT.QueryTable(entity, sql, null, 0, 1); return(Content(JSON.DecodeToStr(dt))); }
/// <summary> /// 新增或编辑图表 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Edit(int id = 0) { ViewBag.Result = false; ViewBag.Message = string.Empty; ViewBag.DIC_DBS = BF_DATABASE.Instance.GetDictionary(); BF_CHART_REPORT.Entity entity = new BF_CHART_REPORT.Entity(); entity.IS_SHOW_EXPORT = 1; entity.IS_SHOW_DEBUG = 1; if (id > 0) { entity = BF_CHART_REPORT.Instance.GetEntityByKey <BF_CHART_REPORT.Entity>(id); if (entity == null) { ViewBag.Message = "报表不存在"; entity = new BF_CHART_REPORT.Entity(); entity.ID = -1; } } ModelState.Clear(); return(View(entity)); }
/// <summary> /// 验证输入 /// </summary> /// <param name="entity"></param> private void CheckInput(BF_CHART_REPORT.Entity entity) { if (entity == null) { throw new Exception("对象为空"); } if (string.IsNullOrWhiteSpace(entity.NAME)) { throw new Exception("图表名称不可为空"); } if (string.IsNullOrWhiteSpace(entity.SQL_CODE)) { throw new Exception("SQL语句不可为空"); } if (string.IsNullOrWhiteSpace(entity.CHART_CODE)) { throw new Exception("CHART代码不可为空"); } if (BF_CHART_REPORT.Instance.IsDuplicate(entity.ID, "NAME", entity.NAME)) { throw new Exception("图表名称 " + entity.NAME + " 已经存在"); } }
public ActionResult Edit(BF_CHART_REPORT.Entity entity) { if (!string.IsNullOrEmpty(entity.CHART_CODE)) { string chartCode = Base.Encrypt.BAES.Decrypt(entity.CHART_CODE); entity.CHART_CODE = string.IsNullOrEmpty(chartCode) ? " " : chartCode; } if (!string.IsNullOrEmpty(entity.TOP_CODE)) { string topCode = Base.Encrypt.BAES.Decrypt(entity.TOP_CODE); entity.TOP_CODE = string.IsNullOrEmpty(topCode) ? " " : topCode; } if (!string.IsNullOrEmpty(entity.BOTTOM_CODE)) { string bottomCode = Base.Encrypt.BAES.Decrypt(entity.BOTTOM_CODE); entity.BOTTOM_CODE = string.IsNullOrEmpty(bottomCode) ? " " : bottomCode; } JsonResultData result = new JsonResultData(); int i = 0; try { CheckInput(entity); if (entity.ID < 0) { result.Message = "图表不存在,不可编辑"; return(Json(result, JsonRequestBehavior.AllowGet)); } if (entity.ID == 0) { entity.IS_ENABLE = 1; entity.CREATE_UID = SystemSession.UserID; entity.CREATE_TIME = DateTime.Now; entity.UPDATE_UID = SystemSession.UserID; entity.UPDATE_TIME = DateTime.Now; i = BF_CHART_REPORT.Instance.Add(entity); } else { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("NAME", entity.NAME.Trim()); dic.Add("DB_ID", entity.DB_ID); dic.Add("IS_SHOW_EXPORT", entity.IS_SHOW_EXPORT); dic.Add("IS_SHOW_DEBUG", entity.IS_SHOW_DEBUG); //dic.Add("IS_SHOW_CHECKBOX", entity.IS_SHOW_CHECKBOX); dic.Add("SQL_CODE", entity.SQL_CODE); dic.Add("REMARK", entity.REMARK); dic.Add("TOP_CODE", entity.TOP_CODE); dic.Add("BOTTOM_CODE", entity.BOTTOM_CODE); dic.Add("UPDATE_UID", SystemSession.UserID); dic.Add("UPDATE_TIME", DateTime.Now); dic.Add("CHART_CODE", entity.CHART_CODE);//CHART代码体 i = BF_CHART_REPORT.Instance.UpdateByKey(dic, entity.ID); } if (i < 1) { result.Message = "提交失败!出现了未知错误"; } else { result.IsSuccess = true; result.Message = "提交成功!"; } } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; BLog.Write(BLog.LogLevel.WARN, "编辑图表出错:" + ex.ToString()); } ViewBag.Result = result.IsSuccess; ViewBag.Message = result.Message; ViewBag.DIC_DBS = BF_DATABASE.Instance.GetDictionary(); ModelState.Clear(); return(View(entity)); }