public static string GetCallbackScript(PublishmentSystemInfo publishmentSystemInfo, bool isSuccess, GovInteractContentInfo contentInfo, string failureMessage) { var jsonAttributes = new NameValueCollection(); jsonAttributes.Add("isSuccess", isSuccess.ToString().ToLower()); if (isSuccess && contentInfo != null) { foreach (string attributeName in contentInfo.Attributes.Keys) { jsonAttributes.Add(attributeName, contentInfo.GetExtendedAttribute(attributeName)); } jsonAttributes.Add("replystate", EGovInteractStateUtils.GetFrontText(contentInfo.State)); if (contentInfo.State == EGovInteractState.Checked || contentInfo.State == EGovInteractState.Denied) { var replyInfo = DataProvider.GovInteractReplyDao.GetReplyInfoByContentId(publishmentSystemInfo.PublishmentSystemId, contentInfo.Id); if (replyInfo != null) { jsonAttributes.Add("replycontent", replyInfo.Reply); jsonAttributes.Add("replyfileurl", replyInfo.FileUrl); jsonAttributes.Add("replydepartmentname", DepartmentManager.GetDepartmentName(replyInfo.DepartmentID)); jsonAttributes.Add("replyusername", replyInfo.UserName); jsonAttributes.Add("replyadddate", DateUtils.GetDateAndTimeString(replyInfo.AddDate)); } } } jsonAttributes.Add("failureMessage", failureMessage); var jsonString = TranslateUtils.NameValueCollectionToJsonString(jsonAttributes); jsonString = StringUtils.ToJsString(jsonString); return($"<script>window.parent.stlQueryCallback('{jsonString}');</script>"); }
public string GetSelectStringByState(PublishmentSystemInfo publishmentSystemInfo, int nodeId, params EGovInteractState[] states) { var whereBuilder = new StringBuilder(); whereBuilder.Append( $"WHERE PublishmentSystemID = {publishmentSystemInfo.PublishmentSystemId} AND NodeID = {nodeId} AND ("); foreach (var state in states) { whereBuilder.Append($" State = '{EGovInteractStateUtils.GetValue(state)}' OR"); } whereBuilder.Length -= 2; whereBuilder.Append(")"); return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(publishmentSystemInfo.AuxiliaryTableForGovInteract, SqlUtils.Asterisk, whereBuilder.ToString())); }
public void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BreadCrumb(AppManager.Wcm.LeftMenu.IdGovInteract, "所有办件", AppManager.Wcm.Permission.WebSite.GovInteract); EBooleanUtils.AddListItems(ddlTaxis, "倒序", "正序"); if (Body.IsQueryExists("isTaxisDESC")) { var isTaxisDesc = TranslateUtils.ToBool(Request.QueryString["isTaxisDESC"]); ControlUtils.SelectListItemsIgnoreCase(ddlTaxis, isTaxisDesc.ToString()); } var listItem = new ListItem("全部", string.Empty); ddlState.Items.Add(listItem); EGovInteractStateUtils.AddListItems(ddlState); if (Body.IsQueryExists("state")) { ControlUtils.SelectListItemsIgnoreCase(ddlState, Request.QueryString["state"]); } tbDateFrom.Text = Request.QueryString["dateFrom"]; tbDateTo.Text = Request.QueryString["dateTo"]; tbKeyword.Text = Request.QueryString["keyword"]; } }
public string GetSelectSqlStringWithChecked(PublishmentSystemInfo publishmentSystemInfo, int nodeId, bool isReplyExists, bool isReply, int startNum, int totalNum, string whereString, string orderByString, NameValueCollection otherAttributes) { if (!string.IsNullOrEmpty(whereString) && !StringUtils.StartsWithIgnoreCase(whereString.Trim(), "AND ")) { whereString = "AND " + whereString.Trim(); } string sqlWhereString = $"WHERE NodeID = {nodeId} AND IsPublic = '{true.ToString()}' {whereString}"; if (isReplyExists) { if (isReply) { sqlWhereString += $" AND State = '{EGovInteractStateUtils.GetValue(EGovInteractState.Checked)}'"; } else { sqlWhereString += $" AND State <> '{EGovInteractStateUtils.GetValue(EGovInteractState.Checked)}' AND State <> '{EGovInteractStateUtils.GetValue(EGovInteractState.Denied)}'"; } } if (otherAttributes != null && otherAttributes.Count > 0) { var relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(publishmentSystemInfo.PublishmentSystemId, nodeId); var styleInfoList = TableStyleManager.GetTableStyleInfoList(ETableStyle.GovInteractContent, publishmentSystemInfo.AuxiliaryTableForGovInteract, relatedIdentities); foreach (var tableStyleInfo in styleInfoList) { if (!string.IsNullOrEmpty(otherAttributes[tableStyleInfo.AttributeName.ToLower()])) { sqlWhereString += $" AND ({ContentAttribute.SettingsXml} like '%{tableStyleInfo.AttributeName}={otherAttributes[tableStyleInfo.AttributeName.ToLower()]}%')"; } } } return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(publishmentSystemInfo.AuxiliaryTableForGovInteract, startNum, totalNum, SqlUtils.Asterisk, sqlWhereString, orderByString)); }
private static string ParseImpl(XmlNode node, PageInfo pageInfo, ContextInfo contextInfo, string leftText, string rightText, string formatString, string no, string separator, int startIndex, int length, int wordNum, string ellipsis, string replace, string to, bool isClearTags, string isReturnToBrStr, bool isLower, bool isUpper, bool isOriginal, string type, StringDictionary attributes, string imageType) { var parsedContent = string.Empty; var isReturnToBr = false; if (string.IsNullOrEmpty(isReturnToBrStr)) { if (BackgroundContentAttribute.Summary.ToLower().Equals(type)) { isReturnToBr = true; } } else { isReturnToBr = TranslateUtils.ToBool(isReturnToBrStr, true); } var contentId = contextInfo.ContentID; var contentInfo = contextInfo.ContentInfo; if (contentInfo == null) { return(string.Empty); } if (isOriginal) { if (contentInfo.ReferenceId > 0 && contentInfo.SourceId > 0 && contentInfo.GetExtendedAttribute(ContentAttribute.TranslateContentType) == ETranslateContentType.Reference.ToString()) { var targetNodeId = contentInfo.SourceId; var targetPublishmentSystemId = DataProvider.NodeDao.GetPublishmentSystemId(targetNodeId); var targetPublishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfo(targetPublishmentSystemId); var targetNodeInfo = NodeManager.GetNodeInfo(targetPublishmentSystemId, targetNodeId); var tableStyle = NodeManager.GetTableStyle(targetPublishmentSystemInfo, targetNodeInfo); var tableName = NodeManager.GetTableName(targetPublishmentSystemInfo, targetNodeInfo); var targetContentInfo = DataProvider.ContentDao.GetContentInfo(tableStyle, tableName, contentInfo.ReferenceId); if (targetContentInfo != null && targetContentInfo.NodeId > 0) { //标题可以使用自己的 targetContentInfo.Title = contentInfo.Title; contentInfo = targetContentInfo; } } } if (!string.IsNullOrEmpty(formatString)) { formatString = formatString.Trim(); if (!formatString.StartsWith("{0")) { formatString = "{0:" + formatString; } if (!formatString.EndsWith("}")) { formatString = formatString + "}"; } } if (contentId != 0) { if (ContentAttribute.Title.ToLower().Equals(type)) { var relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(pageInfo.PublishmentSystemId, contentInfo.NodeId); var nodeInfo = NodeManager.GetNodeInfo(pageInfo.PublishmentSystemId, contentInfo.NodeId); var tableStyle = NodeManager.GetTableStyle(pageInfo.PublishmentSystemInfo, nodeInfo); var tableName = NodeManager.GetTableName(pageInfo.PublishmentSystemInfo, nodeInfo); var styleInfo = TableStyleManager.GetTableStyleInfo(tableStyle, tableName, type, relatedIdentities); if (wordNum == 0) { wordNum = contextInfo.TitleWordNum; } parsedContent = InputParserUtility.GetContentByTableStyle(contentInfo.Title, separator, pageInfo.PublishmentSystemInfo, tableStyle, styleInfo, formatString, attributes, node.InnerXml, false); parsedContent = StringUtils.ParseString(EInputTypeUtils.GetEnumType(styleInfo.InputType), parsedContent, replace, to, startIndex, length, wordNum, ellipsis, isClearTags, isReturnToBr, isLower, isUpper, formatString); if (!isClearTags && !string.IsNullOrEmpty(contentInfo.Attributes[BackgroundContentAttribute.TitleFormatString])) { parsedContent = ContentUtility.FormatTitle(contentInfo.Attributes[BackgroundContentAttribute.TitleFormatString], parsedContent); } if (!contextInfo.IsInnerElement) { parsedContent = parsedContent.Replace("&", "&"); } if (pageInfo.PublishmentSystemInfo.Additional.IsContentTitleBreakLine) { parsedContent = parsedContent.Replace(" ", !contextInfo.IsInnerElement ? "<br />" : string.Empty); } } else if (BackgroundContentAttribute.Summary.ToLower().Equals(type)) { parsedContent = StringUtils.ParseString(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.Summary), replace, to, startIndex, length, wordNum, ellipsis, isClearTags, isReturnToBr, isLower, isUpper, formatString); if (!contextInfo.IsInnerElement) { parsedContent = parsedContent.Replace("&", "&"); } } else if (BackgroundContentAttribute.Content.ToLower().Equals(type)) { parsedContent = StringUtility.TextEditorContentDecode(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.Content), pageInfo.PublishmentSystemInfo); if (pageInfo.PublishmentSystemInfo.Additional.IsInnerLink) { var innerLinkInfoList = pageInfo.CacheOfInnerLinkInfoList; if (innerLinkInfoList != null && innerLinkInfoList.Count > 0) { InnerLinkInfo newInnerLinkInfo; for (var i = 0; i < innerLinkInfoList.Count - 1; i++) { for (var j = i + 1; j < innerLinkInfoList.Count; j++) { if (innerLinkInfoList[i].InnerLinkName.Length < innerLinkInfoList[j].InnerLinkName.Length) { newInnerLinkInfo = innerLinkInfoList[i]; innerLinkInfoList[i] = innerLinkInfoList[j]; innerLinkInfoList[j] = newInnerLinkInfo; } } } var arrayLinkName = new List <string>(); var arrayInnerLink = new List <string>(); for (var i = 0; i < innerLinkInfoList.Count; i++) { newInnerLinkInfo = innerLinkInfoList[i]; arrayLinkName.Add(newInnerLinkInfo.InnerLinkName); arrayInnerLink.Add(newInnerLinkInfo.InnerString); } for (var m = 0; m < arrayLinkName.Count; m++) { var innerLinkName = arrayLinkName[m]; arrayLinkName[m] = Guid.NewGuid().ToString(); parsedContent = RegexUtils.Replace( $"({innerLinkName.Replace(" ", "\\s")})(?!</a>)(?![^><]*>)", parsedContent, arrayLinkName[m], pageInfo.PublishmentSystemInfo.Additional.InnerLinkMaxNum); } for (var n = 0; n < arrayLinkName.Count; n++) { parsedContent = RegexUtils.Replace( $"({arrayLinkName[n].Replace(" ", "\\s")})(?!</a>)(?![^><]*>)", parsedContent, arrayInnerLink[n], pageInfo.PublishmentSystemInfo.Additional.InnerLinkMaxNum); } } } if (isClearTags) { parsedContent = StringUtils.StripTags(parsedContent); } if (!string.IsNullOrEmpty(replace)) { parsedContent = StringUtils.Replace(replace, parsedContent, to); } if (wordNum > 0 && !string.IsNullOrEmpty(parsedContent)) { parsedContent = StringUtils.MaxLengthText(parsedContent, wordNum, ellipsis); } if (!string.IsNullOrEmpty(formatString)) { parsedContent = string.Format(formatString, parsedContent); } if (!contextInfo.IsInnerElement) { parsedContent = parsedContent.Replace("&", "&"); } } else if (BackgroundContentAttribute.PageContent.ToLower().Equals(type)) { //if (contextInfo.IsInnerElement) // { parsedContent = StringUtility.TextEditorContentDecode(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.Content), pageInfo.PublishmentSystemInfo); if (pageInfo.PublishmentSystemInfo.Additional.IsInnerLink) { var innerLinkInfoList = pageInfo.CacheOfInnerLinkInfoList; if (innerLinkInfoList != null && innerLinkInfoList.Count > 0) { InnerLinkInfo newInnerLinkInfo; for (var i = 0; i < innerLinkInfoList.Count - 1; i++) { for (var j = i + 1; j < innerLinkInfoList.Count; j++) { if (innerLinkInfoList[i].InnerLinkName.Length < innerLinkInfoList[j].InnerLinkName.Length) { newInnerLinkInfo = innerLinkInfoList[i]; innerLinkInfoList[i] = innerLinkInfoList[j]; innerLinkInfoList[j] = newInnerLinkInfo; } } } for (var i = 0; i < innerLinkInfoList.Count; i++) { newInnerLinkInfo = innerLinkInfoList[i]; for (var j = i + 1; j < innerLinkInfoList.Count; j++) { var lastInnerLinkInfo = innerLinkInfoList[j]; if (newInnerLinkInfo.InnerLinkName.Contains(lastInnerLinkInfo.InnerLinkName)) { innerLinkInfoList.Remove(lastInnerLinkInfo); } } parsedContent = RegexUtils.Replace( $"({newInnerLinkInfo.InnerLinkName.Replace(" ", "\\s")})(?!</a>)(?![^><]*>)", parsedContent, newInnerLinkInfo.InnerString, pageInfo.PublishmentSystemInfo.Additional.InnerLinkMaxNum); } } } if (isClearTags) { parsedContent = StringUtils.StripTags(parsedContent); } if (!string.IsNullOrEmpty(replace)) { parsedContent = StringUtils.Replace(replace, parsedContent, to); } if (wordNum > 0 && !string.IsNullOrEmpty(parsedContent)) { parsedContent = StringUtils.MaxLengthText(parsedContent, wordNum, ellipsis); } if (!string.IsNullOrEmpty(formatString)) { parsedContent = string.Format(formatString, parsedContent); } } else if (ContentAttribute.AddDate.ToLower().Equals(type)) { parsedContent = DateUtils.Format(contentInfo.AddDate, formatString); } else if (ContentAttribute.LastEditDate.ToLower().Equals(type)) { parsedContent = DateUtils.Format(contentInfo.LastEditDate, formatString); } else if (BackgroundContentAttribute.ImageUrl.ToLower().Equals(type)) { if (no == "all") { var sbParsedContent = new StringBuilder(); //第一条 if (contextInfo.IsCurlyBrace) { sbParsedContent.Append(PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, GetImageUrlByType(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.ImageUrl), imageType))); } else { sbParsedContent.Append(InputParserUtility.GetImageOrFlashHtml(pageInfo.PublishmentSystemInfo, GetImageUrlByType(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.ImageUrl), imageType), attributes, false)); } //第n条 var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.ImageUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { var newExtendValue = GetImageUrlByType(extendValue, imageType); if (contextInfo.IsCurlyBrace) { sbParsedContent.Append(PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, newExtendValue)); } else { sbParsedContent.Append(InputParserUtility.GetImageOrFlashHtml(pageInfo.PublishmentSystemInfo, newExtendValue, attributes, false)); } } } parsedContent = sbParsedContent.ToString(); } else { var num = TranslateUtils.ToInt(no, 0); if (num <= 1) { if (contextInfo.IsCurlyBrace) { parsedContent = PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, GetImageUrlByType(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.ImageUrl), imageType)); } else { parsedContent = InputParserUtility.GetImageOrFlashHtml(pageInfo.PublishmentSystemInfo, GetImageUrlByType(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.ImageUrl), imageType), attributes, false); } } else { var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.ImageUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { var index = 2; foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { var newExtendValue = GetImageUrlByType(extendValue, imageType); if (index == num) { if (contextInfo.IsCurlyBrace) { parsedContent = PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, newExtendValue); } else { parsedContent = InputParserUtility.GetImageOrFlashHtml(pageInfo.PublishmentSystemInfo, newExtendValue, attributes, false); } break; } index++; } } } } } else if (BackgroundContentAttribute.VideoUrl.ToLower().Equals(type)) { if (no == "all") { var sbParsedContent = new StringBuilder(); //第一条 sbParsedContent.Append(InputParserUtility.GetVideoHtml(pageInfo.PublishmentSystemInfo, contentInfo.GetExtendedAttribute(BackgroundContentAttribute.VideoUrl), attributes, false)); //第n条 var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.VideoUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { sbParsedContent.Append(InputParserUtility.GetVideoHtml(pageInfo.PublishmentSystemInfo, extendValue, attributes, false)); } } parsedContent = sbParsedContent.ToString(); } else { var num = TranslateUtils.ToInt(no, 0); if (num <= 1) { parsedContent = InputParserUtility.GetVideoHtml(pageInfo.PublishmentSystemInfo, contentInfo.GetExtendedAttribute(BackgroundContentAttribute.VideoUrl), attributes, false); } else { var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.VideoUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { var index = 2; foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { if (index == num) { parsedContent = InputParserUtility.GetVideoHtml(pageInfo.PublishmentSystemInfo, extendValue, attributes, false); break; } index++; } } } } } else if (BackgroundContentAttribute.FileUrl.ToLower().Equals(type)) { if (no == "all") { var sbParsedContent = new StringBuilder(); if (contextInfo.IsCurlyBrace) { //第一条 sbParsedContent.Append(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.FileUrl)); //第n条 var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.FileUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { sbParsedContent.Append(extendValue); } } } else { //第一条 sbParsedContent.Append(InputParserUtility.GetFileHtmlWithCount(pageInfo.PublishmentSystemInfo, contentInfo.NodeId, contentInfo.Id, contentInfo.GetExtendedAttribute(BackgroundContentAttribute.FileUrl), attributes, node.InnerXml, false)); //第n条 var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.FileUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { sbParsedContent.Append(InputParserUtility.GetFileHtmlWithCount(pageInfo.PublishmentSystemInfo, contentInfo.NodeId, contentInfo.Id, extendValue, attributes, node.InnerXml, false)); } } } parsedContent = sbParsedContent.ToString(); } else { var num = TranslateUtils.ToInt(no, 0); if (contextInfo.IsCurlyBrace) { if (num <= 1) { parsedContent = contentInfo.GetExtendedAttribute(BackgroundContentAttribute.FileUrl); } else { var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.FileUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { var index = 2; foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { if (index == num) { parsedContent = extendValue; break; } index++; } } } } else { if (num <= 1) { parsedContent = InputParserUtility.GetFileHtmlWithCount(pageInfo.PublishmentSystemInfo, contentInfo.NodeId, contentInfo.Id, contentInfo.GetExtendedAttribute(BackgroundContentAttribute.FileUrl), attributes, node.InnerXml, false); } else { var extendAttributeName = ContentAttribute.GetExtendAttributeName(BackgroundContentAttribute.FileUrl); var extendValues = contentInfo.GetExtendedAttribute(extendAttributeName); if (!string.IsNullOrEmpty(extendValues)) { var index = 2; foreach (string extendValue in TranslateUtils.StringCollectionToStringList(extendValues)) { if (index == num) { parsedContent = InputParserUtility.GetFileHtmlWithCount(pageInfo.PublishmentSystemInfo, contentInfo.NodeId, contentInfo.Id, extendValue, attributes, node.InnerXml, false); break; } index++; } } } } } } else if (BackgroundContentAttribute.NavigationUrl.ToLower().Equals(type)) { parsedContent = PageUtility.GetContentUrl(pageInfo.PublishmentSystemInfo, contentInfo); } else if (ContentAttribute.Tags.ToLower().Equals(type)) { parsedContent = contentInfo.Tags; } else if (StringUtils.StartsWithIgnoreCase(type, StlParserUtility.ItemIndex) && contextInfo.ItemContainer?.ContentItem != null) { var itemIndex = StlParserUtility.ParseItemIndex(contextInfo.ItemContainer.ContentItem.ItemIndex, type, contextInfo); parsedContent = !string.IsNullOrEmpty(formatString) ? string.Format(formatString, itemIndex) : itemIndex.ToString(); } else if (ContentAttribute.AddUserName.ToLower().Equals(type)) { if (!string.IsNullOrEmpty(contentInfo.AddUserName)) { var displayName = BaiRongDataProvider.AdministratorDao.GetDisplayName(contentInfo.AddUserName); parsedContent = string.IsNullOrEmpty(displayName) ? contentInfo.AddUserName : displayName; } } else { var isSelected = false; var nodeInfo = NodeManager.GetNodeInfo(pageInfo.PublishmentSystemId, contentInfo.NodeId); var tableStyle = NodeManager.GetTableStyle(pageInfo.PublishmentSystemInfo, nodeInfo); //WCM SPECIFIC if (tableStyle == ETableStyle.GovInteractContent) { isSelected = true; if (GovInteractContentAttribute.State.ToLower().Equals(type)) { parsedContent = EGovInteractStateUtils.GetText(EGovInteractStateUtils.GetEnumType(contentInfo.GetExtendedAttribute(GovInteractContentAttribute.State))); } else if (StringUtils.EqualsIgnoreCase(type, GovInteractContentAttribute.Reply)) { var replyInfo = DataProvider.GovInteractReplyDao.GetReplyInfoByContentId(pageInfo.PublishmentSystemId, contentInfo.Id); if (replyInfo != null) { parsedContent = replyInfo.Reply; if (!string.IsNullOrEmpty(parsedContent)) { parsedContent = StringUtils.ParseString(EInputType.TextEditor, parsedContent, replace, to, startIndex, length, wordNum, ellipsis, isClearTags, isReturnToBr, isLower, isUpper, formatString); } } } else if (StringUtils.EqualsIgnoreCase(type, GovInteractContentAttribute.ReplyDepartment)) { var replyInfo = DataProvider.GovInteractReplyDao.GetReplyInfoByContentId(pageInfo.PublishmentSystemId, contentInfo.Id); if (replyInfo != null) { parsedContent = DepartmentManager.GetDepartmentName(replyInfo.DepartmentID); } } else if (StringUtils.EqualsIgnoreCase(type, GovInteractContentAttribute.ReplyUserName)) { var replyInfo = DataProvider.GovInteractReplyDao.GetReplyInfoByContentId(pageInfo.PublishmentSystemId, contentInfo.Id); if (replyInfo != null) { parsedContent = replyInfo.UserName; } } else if (StringUtils.EqualsIgnoreCase(type, GovInteractContentAttribute.ReplyDate)) { var replyInfo = DataProvider.GovInteractReplyDao.GetReplyInfoByContentId(pageInfo.PublishmentSystemId, contentInfo.Id); if (replyInfo != null) { var addDate = replyInfo.AddDate; parsedContent = DateUtils.Format(addDate, formatString); } } else if (StringUtils.EqualsIgnoreCase(type, GovInteractContentAttribute.ReplyFileUrl)) { var replyInfo = DataProvider.GovInteractReplyDao.GetReplyInfoByContentId(pageInfo.PublishmentSystemId, contentInfo.Id); if (replyInfo != null) { parsedContent = PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, replyInfo.FileUrl); } } else { isSelected = false; } } //WCM SPECIFIC if (!isSelected && contentInfo.ContainsKey(type)) { if (!ContentAttribute.HiddenAttributes.Contains(type.ToLower())) { var relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(pageInfo.PublishmentSystemId, contentInfo.NodeId); var tableName = NodeManager.GetTableName(pageInfo.PublishmentSystemInfo, nodeInfo); var styleInfo = TableStyleManager.GetTableStyleInfo(tableStyle, tableName, type, relatedIdentities); var num = TranslateUtils.ToInt(no); parsedContent = InputParserUtility.GetContentByTableStyle(contentInfo, separator, pageInfo.PublishmentSystemInfo, tableStyle, styleInfo, formatString, num, attributes, node.InnerXml, false); parsedContent = StringUtils.ParseString(EInputTypeUtils.GetEnumType(styleInfo.InputType), parsedContent, replace, to, startIndex, length, wordNum, ellipsis, isClearTags, isReturnToBr, isLower, isUpper, formatString); } else { parsedContent = contentInfo.GetExtendedAttribute(type); parsedContent = StringUtils.ParseString(parsedContent, replace, to, startIndex, length, wordNum, ellipsis, isClearTags, isReturnToBr, isLower, isUpper, formatString); } } if (!contextInfo.IsInnerElement) { parsedContent = parsedContent.Replace("&", "&"); } } if (!string.IsNullOrEmpty(parsedContent)) { parsedContent = leftText + parsedContent + rightText; } } else { if (!string.IsNullOrEmpty(type) && contextInfo.ItemContainer != null && contextInfo.ItemContainer.ContentItem != null) { parsedContent = DataBinder.Eval(contextInfo.ItemContainer.ContentItem.DataItem, type, "{0}"); parsedContent = StringUtils.ParseString(parsedContent, replace, to, startIndex, length, wordNum, ellipsis, isClearTags, isReturnToBr, isLower, isUpper, formatString); if (!string.IsNullOrEmpty(parsedContent)) { parsedContent = leftText + parsedContent + rightText; } } } return(parsedContent); }
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var contentInfo = new GovInteractContentInfo(e.Item.DataItem); var ltlTr = e.Item.FindControl("ltlTr") as Literal; var ltlID = e.Item.FindControl("ltlID") as Literal; var ltlTitle = e.Item.FindControl("ltlTitle") as Literal; var ltlAddDate = e.Item.FindControl("ltlAddDate") as Literal; var ltlRemark = e.Item.FindControl("ltlRemark") as Literal; var ltlDepartment = e.Item.FindControl("ltlDepartment") as Literal; var ltlLimit = e.Item.FindControl("ltlLimit") as Literal; var ltlState = e.Item.FindControl("ltlState") as Literal; var ltlFlowUrl = e.Item.FindControl("ltlFlowUrl") as Literal; var ltlViewUrl = e.Item.FindControl("ltlViewUrl") as Literal; var ltlReplyUrl = e.Item.FindControl("ltlReplyUrl") as Literal; var ltlEditUrl = e.Item.FindControl("ltlEditUrl") as Literal; var limitType = EGovInteractLimitType.Normal; ltlTr.Text = @"<tr>"; if (contentInfo.State == EGovInteractState.Denied || contentInfo.State == EGovInteractState.Checked) { ltlTr.Text = @"<tr class=""success"">"; } else { limitType = GovInteractApplyManager.GetLimitType(PublishmentSystemInfo, contentInfo); if (limitType == EGovInteractLimitType.Alert) { ltlTr.Text = @"<tr class=""info"">"; } else if (limitType == EGovInteractLimitType.Yellow) { ltlTr.Text = @"<tr class=""warning"">"; } else if (limitType == EGovInteractLimitType.Red) { ltlTr.Text = @"<tr class=""error"">"; } } ltlID.Text = contentInfo.Id.ToString(); var title = contentInfo.Title; if (string.IsNullOrEmpty(title)) { title = StringUtils.MaxLengthText(contentInfo.Content, 30); } if (string.IsNullOrEmpty(title)) { title = contentInfo.QueryCode; } var target = PublishmentSystemInfo.Additional.GovInteractApplyIsOpenWindow ? @"target=""_blank""" : string.Empty; if (contentInfo.State == EGovInteractState.Accepted || contentInfo.State == EGovInteractState.Redo) { ltlTitle.Text = $@"<a href=""{PageGovInteractPageReply.GetRedirectUrl(PublishmentSystemId, contentInfo.NodeId, contentInfo.Id, PageUrl)}"" {target}>{title}</a>"; } else if (contentInfo.State == EGovInteractState.Checked || contentInfo.State == EGovInteractState.Replied) { ltlTitle.Text = $@"<a href=""{PageGovInteractPageCheck.GetRedirectUrl(PublishmentSystemId, contentInfo.NodeId, contentInfo.Id, PageUrl)}"" {target}>{title}</a>"; } else if (contentInfo.State == EGovInteractState.Denied || contentInfo.State == EGovInteractState.New) { ltlTitle.Text = $@"<a href=""{PageGovInteractPageAccept.GetRedirectUrl(PublishmentSystemId, contentInfo.NodeId, contentInfo.Id, PageUrl)}"" {target}>{title}</a>"; } var departmentName = DepartmentManager.GetDepartmentName(contentInfo.DepartmentId); if (contentInfo.DepartmentId > 0 && departmentName != contentInfo.DepartmentName) { ltlTitle.Text += "<span style='color:red'>【转办】</span>"; } else if (TranslateUtils.ToInt(contentInfo.GetExtendedAttribute(GovInteractContentAttribute.TranslateFromNodeId)) > 0) { ltlTitle.Text += "<span style='color:red'>【转移】</span>"; } ltlAddDate.Text = DateUtils.GetDateAndTimeString(contentInfo.AddDate); ltlRemark.Text = GovInteractApplyManager.GetApplyRemark(PublishmentSystemId, contentInfo.Id); ltlDepartment.Text = departmentName; ltlLimit.Text = EGovInteractLimitTypeUtils.GetText(limitType); ltlState.Text = EGovInteractStateUtils.GetText(contentInfo.State); if (contentInfo.State == EGovInteractState.New) { ltlState.Text = $"<span style='color:red'>{ltlState.Text}</span>"; } else if (contentInfo.State == EGovInteractState.Redo) { ltlState.Text = $"<span style='color:red'>{ltlState.Text}</span>"; } ltlFlowUrl.Text = $@"<a href=""javascript:;"" onclick=""{ModalGovInteractApplyFlow.GetOpenWindowString( PublishmentSystemId, contentInfo.NodeId, contentInfo.Id)}"">轨迹</a>"; ltlViewUrl.Text = $@"<a href=""javascript:;"" onclick=""{ModalGovInteractApplyView.GetOpenWindowString( PublishmentSystemId, contentInfo.NodeId, contentInfo.Id)}"">查看</a>"; if (isPermissionReply) { ltlReplyUrl.Text = $@"<a href=""javascript:;"" onclick=""{ModalGovInteractApplyReply.GetOpenWindowString( PublishmentSystemId, contentInfo.NodeId, contentInfo.Id)}"">办理</a>"; } if (isPermissionEdit) { var nodeInfo = NodeManager.GetNodeInfo(PublishmentSystemId, contentInfo.NodeId); ltlEditUrl.Text = $@"<a href=""{WebUtils.GetContentAddEditUrl(PublishmentSystemId, nodeInfo, contentInfo.Id, PageUrl)}"">编辑</a>"; } } }
public int GetCountByDepartmentIdAndState(PublishmentSystemInfo publishmentSystemInfo, int departmentId, int nodeId, EGovInteractState state, DateTime begin, DateTime end) { string sqlString; if (nodeId == 0) { sqlString = $"SELECT COUNT(*) AS TotalNum FROM {publishmentSystemInfo.AuxiliaryTableForGovInteract} WHERE PublishmentSystemID = {publishmentSystemInfo.PublishmentSystemId} AND DepartmentID = {departmentId} AND State = '{EGovInteractStateUtils.GetValue(state)}' AND (AddDate BETWEEN '{begin.ToShortDateString()}' AND '{end.AddDays(1).ToShortDateString()}')"; } else { sqlString = $"SELECT COUNT(*) AS TotalNum FROM {publishmentSystemInfo.AuxiliaryTableForGovInteract} WHERE PublishmentSystemID = {publishmentSystemInfo.PublishmentSystemId} AND DepartmentID = {departmentId} AND NodeID = {nodeId} AND State = '{EGovInteractStateUtils.GetValue(state)}' AND (AddDate BETWEEN '{begin.ToShortDateString()}' AND '{end.AddDays(1).ToShortDateString()}')"; } return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString)); }
public int GetCountByDepartmentIdAndState(PublishmentSystemInfo publishmentSystemInfo, int departmentId, EGovInteractState state) { string sqlString = $"SELECT COUNT(*) AS TotalNum FROM {publishmentSystemInfo.AuxiliaryTableForGovInteract} WHERE PublishmentSystemID = {publishmentSystemInfo.PublishmentSystemId} AND DepartmentID = {departmentId} AND State = '{EGovInteractStateUtils.GetValue(state)}'"; return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString)); }
public void UpdateState(PublishmentSystemInfo publishmentSystemInfo, int contentId, EGovInteractState state) { string sqlString; if (state == EGovInteractState.Checked) { sqlString = $"UPDATE {publishmentSystemInfo.AuxiliaryTableForGovInteract} SET State = '{EGovInteractStateUtils.GetValue(state)}', IsChecked='{true}', CheckedLevel = 0 WHERE ID = {contentId}"; } else { sqlString = $"UPDATE {publishmentSystemInfo.AuxiliaryTableForGovInteract} SET State = '{EGovInteractStateUtils.GetValue(state)}', IsChecked='{false}', CheckedLevel = 0 WHERE ID = {contentId}"; } ExecuteNonQuery(sqlString); }
protected override void OnInit(EventArgs e) { base.OnInit(e); PageUtils.CheckRequestParameter("ContentID", "ReturnUrl"); contentInfo = DataProvider.GovInteractContentDao.GetContentInfo(PublishmentSystemInfo, TranslateUtils.ToInt(Request.QueryString["ContentID"])); returnUrl = StringUtils.ValueFromUrl(Request.QueryString["ReturnUrl"]); if (!IsPostBack) { if (phBtnAccept != null) { phBtnAccept.Visible = GovInteractManager.IsPermission(PublishmentSystemId, contentInfo.NodeId, AppManager.Wcm.Permission.GovInteract.GovInteractAccept); } if (phBtnSwitchToTranslate != null) { phBtnSwitchToTranslate.Visible = GovInteractManager.IsPermission(PublishmentSystemId, contentInfo.NodeId, AppManager.Wcm.Permission.GovInteract.GovInteractSwitchToTranslate); } if (phBtnReply != null) { phBtnReply.Visible = GovInteractManager.IsPermission(PublishmentSystemId, contentInfo.NodeId, AppManager.Wcm.Permission.GovInteract.GovInteractReply); } if (phBtnCheck != null) { if (contentInfo.State == EGovInteractState.Checked) { phBtnCheck.Visible = false; } else { phBtnCheck.Visible = GovInteractManager.IsPermission(PublishmentSystemId, contentInfo.NodeId, AppManager.Wcm.Permission.GovInteract.GovInteractCheck); } } if (phBtnComment != null) { if (contentInfo.State == EGovInteractState.Checked) { phBtnComment.Visible = false; } else { phBtnComment.Visible = GovInteractManager.IsPermission(PublishmentSystemId, contentInfo.NodeId, AppManager.Wcm.Permission.GovInteract.GovInteractComment); } } if (phBtnReturn != null) { phBtnReturn.Visible = !PublishmentSystemInfo.Additional.GovInteractApplyIsOpenWindow; } var builder = new StringBuilder(); var styleInfoList = TableStyleManager.GetTableStyleInfoList(ETableStyle.GovInteractContent, PublishmentSystemInfo.AuxiliaryTableForGovInteract, RelatedIdentities.GetChannelRelatedIdentities(PublishmentSystemId, contentInfo.NodeId)); var isPreviousSingleLine = true; var isPreviousLeftColumn = false; foreach (var styleInfo in styleInfoList) { if (styleInfo.IsVisible && !StringUtils.EqualsIgnoreCase(styleInfo.AttributeName, GovInteractContentAttribute.DepartmentId)) { var value = contentInfo.GetExtendedAttribute(styleInfo.AttributeName); if (StringUtils.EqualsIgnoreCase(styleInfo.AttributeName, GovInteractContentAttribute.TypeId)) { value = GovInteractManager.GetTypeName(TranslateUtils.ToInt(value)); } else if (StringUtils.EqualsIgnoreCase(styleInfo.AttributeName, GovInteractContentAttribute.IsPublic)) { value = TranslateUtils.ToBool(value) ? "公开" : "不公开"; } else if (StringUtils.EqualsIgnoreCase(styleInfo.AttributeName, GovInteractContentAttribute.FileUrl)) { if (!string.IsNullOrEmpty(value)) { value = $@"<a href=""{PageUtility.ParseNavigationUrl(PublishmentSystemInfo, value)}"" target=""_blank"">{value}</a>"; } } if (builder.Length > 0) { if (isPreviousSingleLine) { builder.Append("</tr>"); } else { if (!isPreviousLeftColumn) { builder.Append("</tr>"); } else if (styleInfo.IsSingleLine) { builder.Append(@"<td bgcolor=""#f0f6fc"" class=""attribute""></td><td></td></tr>"); } } } //this line if (styleInfo.IsSingleLine || isPreviousSingleLine || !isPreviousLeftColumn) { builder.Append("<tr>"); } builder.Append( $@"<td bgcolor=""#f0f6fc"" class=""attribute"">{styleInfo.DisplayName}</td><td {(styleInfo .IsSingleLine ? @"colspan=""3""" : string.Empty)} class=""tdBorder"">{value}</td>"); if (styleInfo.IsSingleLine) { isPreviousSingleLine = true; isPreviousLeftColumn = false; } else { isPreviousSingleLine = false; isPreviousLeftColumn = !isPreviousLeftColumn; } } } if (builder.Length > 0) { if (isPreviousSingleLine || !isPreviousLeftColumn) { builder.Append("</tr>"); } else { builder.Append(@"<td bgcolor=""#f0f6fc"" class=""attribute""></td><td></td></tr>"); } } ltlTitle.Text = contentInfo.Title; ltlApplyAttributes.Text = builder.ToString(); ltlAddDate.Text = DateUtils.GetDateAndTimeString(contentInfo.AddDate); ltlQueryCode.Text = contentInfo.QueryCode; ltlState.Text = EGovInteractStateUtils.GetText(contentInfo.State); ltlDepartmentName.Text = contentInfo.DepartmentName; if (phReply != null) { if (contentInfo.State == EGovInteractState.Denied || contentInfo.State == EGovInteractState.Replied || contentInfo.State == EGovInteractState.Redo || contentInfo.State == EGovInteractState.Checked) { var replyInfo = DataProvider.GovInteractReplyDao.GetReplyInfoByContentId(PublishmentSystemId, contentInfo.Id); if (replyInfo != null) { phReply.Visible = true; ltlDepartmentAndUserName.Text = $"{DepartmentManager.GetDepartmentName(replyInfo.DepartmentID)}({replyInfo.UserName})"; ltlReplyAddDate.Text = DateUtils.GetDateAndTimeString(replyInfo.AddDate); ltlReply.Text = replyInfo.Reply; if (!string.IsNullOrEmpty(replyInfo.FileUrl)) { ltlReplyFileUrl.Text = $@"<a href=""{PageUtility.ParseNavigationUrl(PublishmentSystemInfo, replyInfo.FileUrl)}"" target=""_blank"">{replyInfo.FileUrl}</a>"; } } } } if (divAddDepartment != null) { divAddDepartment.Attributes.Add("onclick", ModalGovInteractDepartmentSelect.GetOpenWindowString(PublishmentSystemId, contentInfo.NodeId)); var scriptBuilder = new StringBuilder(); if (contentInfo.DepartmentId > 0) { var departmentName = DepartmentManager.GetDepartmentName(contentInfo.DepartmentId); scriptBuilder.Append( $@"<script>showCategoryDepartment('{departmentName}', '{contentInfo.DepartmentId}');</script>"); } ltlScript.Text = scriptBuilder.ToString(); } if (ddlTranslateNodeID != null) { var nodeInfoList = GovInteractManager.GetNodeInfoList(PublishmentSystemInfo); foreach (var nodeInfo in nodeInfoList) { if (nodeInfo.NodeId != contentInfo.NodeId) { var listItem = new ListItem(nodeInfo.NodeName, nodeInfo.NodeId.ToString()); ddlTranslateNodeID.Items.Add(listItem); } } } rptRemarks.DataSource = DataProvider.GovInteractRemarkDao.GetDataSourceByContentId(PublishmentSystemId, contentInfo.Id); rptRemarks.ItemDataBound += rptRemarks_ItemDataBound; rptRemarks.DataBind(); if (rptLogs != null) { rptLogs.DataSource = DataProvider.GovInteractLogDao.GetDataSourceByContentId(PublishmentSystemId, contentInfo.Id); rptLogs.ItemDataBound += rptLogs_ItemDataBound; rptLogs.DataBind(); } } }