/// <summary> /// 修改报表格式 /// </summary> /// <param name="entity"></param> /// <param name="list"></param> /// <returns></returns> public int Update(ReportsEntity entity, List <ReportParamsEntity> list) { int line = 0; using (TransactionScope ts = new TransactionScope()) { ReportParamsEntity param = new ReportParamsEntity(); param.Where(a => a.ReportNum == entity.ReportNum); line += this.ReportParams.Delete(param); entity.Include(a => new { a.ReportName, a.ReportType, a.Remark, a.DataSource, a.DsType, a.FileName }); entity.Where(a => a.ReportNum == entity.ReportNum); line += this.Reports.Update(entity); if (!list.IsNullOrEmpty()) { foreach (ReportParamsEntity item in list) { item.ParamNum = item.ParamNum.IsEmpty() ? SequenceProvider.GetSequence(typeof(ReportParamsEntity)) : item.ParamNum; item.ReportNum = entity.ReportNum; item.IncludeAll(); } this.ReportParams.Add(list); } ts.Complete(); } return(line); }
public ActionResult EditMetadata() { List <ReportParamsEntity> list = WebUtil.GetFormObject <List <ReportParamsEntity> >("list", null); list = list.IsNull() ? new List <ReportParamsEntity>() : list; List <ReportParamsEntity> listSource = Session[CacheKey.JOOSHOW_REPORTPARAM_CACHE] as List <ReportParamsEntity>; listSource = listSource.IsNull() ? new List <ReportParamsEntity>() : listSource; foreach (ReportParamsEntity item in list) { if (listSource.Exists(a => a.ParamNum == item.ParamNum)) { ReportParamsEntity entity = listSource.First(a => a.ParamNum == item.ParamNum); entity.ParamData = item.ParamData; entity.DefaultValue = item.DefaultValue; entity.ParamElement = item.ParamElement; entity.ShowName = item.ShowName; } } Session[CacheKey.JOOSHOW_REPORTPARAM_CACHE] = listSource; this.ReturnJson.AddProperty("Key", "1000"); this.ReturnJson.AddProperty("Value", "编辑成功"); return(Content(this.ReturnJson.ToString())); }
/// <summary> /// 根据报表格式编号查询参数信息 /// </summary> /// <param name="reportNum"></param> /// <returns></returns> public List <ReportParamsEntity> GetParams(string reportNum) { ReportParamsEntity entity = new ReportParamsEntity(); entity.IncludeAll(); entity.Where(a => a.ReportNum == reportNum); List <ReportParamsEntity> list = this.ReportParams.GetList(entity); return(list); }
public ActionResult AddParam() { string SnNum = WebUtil.GetFormValue <string>("SnNum"); string ParamName = WebUtil.GetFormValue <string>("ParamName"); string ShowName = WebUtil.GetFormValue <string>("ShowName"); string ParamType = WebUtil.GetFormValue <string>("ParamType"); string ParamData = WebUtil.GetFormValue <string>("ParamData"); string DefaultValue = WebUtil.GetFormValue <string>("DefaultValue"); string ParamElement = WebUtil.GetFormValue <string>("ParamElement"); string Remark = WebUtil.GetFormValue <string>("Remark"); List <ReportParamsEntity> listSource = Session[SessionKey.SESSION_REPORT_DETAIL] as List <ReportParamsEntity>; listSource = listSource.IsNull() ? new List <ReportParamsEntity>() : listSource; if (SnNum.IsNotEmpty() && listSource.Exists(a => a.SnNum == SnNum)) { ReportParamsEntity entity = listSource.First(a => a.SnNum == SnNum); entity.ParamName = ParamName; entity.ShowName = ShowName; entity.ParamType = ParamType; entity.ParamData = ParamData; entity.DefaultValue = DefaultValue; entity.ParamElement = ParamElement; entity.Remark = Remark; entity.CompanyID = this.CompanyID; } else { ReportParamsEntity entity = new ReportParamsEntity(); entity.SnNum = ConvertHelper.NewGuid(); entity.ParamName = ParamName; entity.ShowName = ShowName; entity.ParamType = ParamType; entity.ParamData = ParamData; entity.DefaultValue = DefaultValue; entity.ParamElement = ParamElement; entity.Remark = Remark; entity.CompanyID = this.CompanyID; listSource.Add(entity); } Session[SessionKey.SESSION_REPORT_DETAIL] = listSource; DataResult dataResult = new DataResult() { Code = (int)EResponseCode.Success, Message = "新增成功" }; return(Content(JsonHelper.SerializeObject(dataResult))); }
public ActionResult AddParam() { List <ReportParamsEntity> list = Session[CacheKey.JOOSHOW_REPORTPARAM_CACHE] as List <ReportParamsEntity>; list = list.IsNull() ? new List <ReportParamsEntity>() : list; ReportParamsEntity entity = WebUtil.GetFormObject <ReportParamsEntity>("entity", null); if (entity != null) { if (!list.Exists(a => a.ParamName == entity.ParamName)) { entity.ParamNum = SequenceProvider.GetSequence(typeof(ReportParamsEntity)); list.Add(entity); } Session[CacheKey.JOOSHOW_REPORTPARAM_CACHE] = list; } return(Content(this.ReturnJson.ToString())); }
public ActionResult AddParam() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty); List <ReportParamsEntity> listSource = Session[SessionKey.SESSION_REPORT_DETAIL] as List <ReportParamsEntity>; ReportParamsEntity entity = null; if (!listSource.IsNullOrEmpty()) { entity = listSource.FirstOrDefault(a => a.SnNum == SnNum); } if (entity == null) { entity = new ReportParamsEntity(); } ViewBag.ParamType = DropDownHelper.GetDataType(entity.ParamType); entity.ParamElement = entity.ParamElement.IsEmpty() ? ((int)EElementType.TextBox).ToString() : entity.ParamElement; ViewBag.ParamElement = EnumHelper.GetOptions <EElementType>(entity.ParamElement); ViewBag.Entity = entity; return(View()); }
/// <summary> /// 根据存储过程名称查询元数据信息 /// </summary> /// <param name="argProceName"></param> /// <returns></returns> public List <ReportParamsEntity> GetProceMetadata(string argProceName) { List <ProceMetadata> list = this.Reports.GetMetadataList(argProceName); if (!list.IsNullOrEmpty()) { List <ReportParamsEntity> listResult = new List <ReportParamsEntity>(); foreach (ProceMetadata item in list) { ReportParamsEntity entity = new ReportParamsEntity(); entity.ReportNum = string.Empty; entity.ParamNum = SequenceProvider.GetSequence(typeof(ReportParamsEntity)); entity.InputNo = item.ORDINAL_POSITION.ToString(); entity.ParamName = item.PARAMETER_NAME; entity.ShowName = string.Empty; entity.ParamType = item.DATA_TYPE; entity.ParamData = ""; entity.DefaultValue = ""; listResult.Add(entity); } return(listResult); } return(null); }