public static string GetCallbackScript(PublishmentSystemInfo publishmentSystemInfo, bool isSuccess, GovPublicApplyInfo applyInfo, string failureMessage)
{
var jsonAttributes = new NameValueCollection();
jsonAttributes.Add("isSuccess", isSuccess.ToString().ToLower());
if (isSuccess && applyInfo != null)
{
jsonAttributes.Add("isOrg", applyInfo.IsOrganization.ToString().ToLower());
foreach (string attributeName in applyInfo.Attributes.Keys)
{
jsonAttributes.Add(attributeName, applyInfo.GetExtendedAttribute(attributeName));
}
jsonAttributes.Add("replystate", EGovPublicApplyStateUtils.GetFrontText(applyInfo.State));
if (applyInfo.State == EGovPublicApplyState.Checked || applyInfo.State == EGovPublicApplyState.Denied)
{
var replyInfo = DataProvider.GovPublicApplyReplyDao.GetReplyInfoByApplyId(applyInfo.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 void UpdateState(int applyId, EGovPublicApplyState state)
{
string sqlString =
$"UPDATE {TableName} SET State = '{EGovPublicApplyStateUtils.GetValue(state)}' WHERE ID = {applyId}";
ExecuteNonQuery(sqlString);
}
public string GetSelectStringByState(int publishmentSystemId, params EGovPublicApplyState[] states)
{
var whereBuilder = new StringBuilder();
whereBuilder.Append($"WHERE PublishmentSystemID = {publishmentSystemId} AND (");
foreach (var state in states)
{
whereBuilder.Append($" State = '{EGovPublicApplyStateUtils.GetValue(state)}' OR");
}
whereBuilder.Length -= 2;
whereBuilder.Append(") ORDER BY ID DESC");
return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(TableName, SqlUtils.Asterisk, whereBuilder.ToString()));
}
public EGovPublicApplyState GetState(int applyId)
{
var state = EGovPublicApplyState.New;
string sqlString = $"SELECT State FROM {TableName} WHERE ID = {applyId}";
using (var rdr = ExecuteReader(sqlString))
{
if (rdr.Read())
{
state = EGovPublicApplyStateUtils.GetEnumType(GetString(rdr, 0));
}
rdr.Close();
}
return(state);
}
public void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BreadCrumb(AppManager.Wcm.LeftMenu.IdGovPublic, AppManager.Wcm.LeftMenu.GovPublic.IdGovPublicApply, "所有申请", AppManager.Wcm.Permission.WebSite.GovPublicApply);
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);
EGovPublicApplyStateUtils.AddListItems(ddlState);
if (Body.IsQueryExists("state"))
{
ControlUtils.SelectListItemsIgnoreCase(ddlState, Request.QueryString["state"]);
}
tbKeyword.Text = Request.QueryString["keyword"];
}
}
public int GetCountByDepartmentIdAndState(int publishmentSystemId, int departmentId, EGovPublicApplyState state, DateTime begin, DateTime end)
{
string sqlString =
$"SELECT COUNT(*) AS TotalNum FROM {TableName} WHERE PublishmentSystemID = {publishmentSystemId} AND DepartmentID = {departmentId} AND State = '{EGovPublicApplyStateUtils.GetValue(state)}' AND (AddDate BETWEEN '{begin.ToShortDateString()}' AND '{end.AddDays(1).ToShortDateString()}')";
return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString));
}
public int GetCountByDepartmentIdAndState(int publishmentSystemId, int departmentId, EGovPublicApplyState state)
{
string sqlString =
$"SELECT COUNT(*) AS TotalNum FROM {TableName} WHERE PublishmentSystemID = {publishmentSystemId} AND DepartmentID = {departmentId} AND State = '{EGovPublicApplyStateUtils.GetValue(state)}'";
return(BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString));
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var applyInfo = new GovPublicApplyInfo(e.Item.DataItem);
var ltlTr = e.Item.FindControl("ltlTr") 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;
ltlTr.Text = @"<tr class=""tdbg"" style=""height:25px"">";
var limitType = GovPublicApplyManager.GetLimitType(PublishmentSystemInfo, applyInfo);
if (limitType == EGovPublicApplyLimitType.Alert)
{
ltlTr.Text = @"<tr class=""tdbg"" style=""height:25px;background-color:#AAAAD5"">";
}
else if (limitType == EGovPublicApplyLimitType.Yellow)
{
ltlTr.Text = @"<tr class=""tdbg"" style=""height:25px;background-color:#FF9"">";
}
else if (limitType == EGovPublicApplyLimitType.Red)
{
ltlTr.Text = @"<tr class=""tdbg"" style=""height:25px;background-color:#FE5461"">";
}
if (applyInfo.State == EGovPublicApplyState.Accepted || applyInfo.State == EGovPublicApplyState.Redo)
{
ltlTitle.Text =
$@"<a href=""{PageGovPublicApplyToReplyDetail.GetRedirectUrl(PublishmentSystemId,
applyInfo.Id, PageUrl)}"">{applyInfo.Title}</a>";
}
else if (applyInfo.State == EGovPublicApplyState.Checked || applyInfo.State == EGovPublicApplyState.Replied)
{
ltlTitle.Text =
$@"<a href=""{PageGovPublicApplyToCheckDetail.GetRedirectUrl(PublishmentSystemId,
applyInfo.Id, PageUrl)}"">{applyInfo.Title}</a>";
}
else if (applyInfo.State == EGovPublicApplyState.Denied || applyInfo.State == EGovPublicApplyState.New)
{
ltlTitle.Text =
$@"<a href=""{PageGovPublicApplyToAcceptDetail.GetRedirectUrl(PublishmentSystemId,
applyInfo.Id, PageUrl)}"">{applyInfo.Title}</a>";
}
var departmentName = DepartmentManager.GetDepartmentName(applyInfo.DepartmentId);
if (applyInfo.DepartmentId > 0 && departmentName != applyInfo.DepartmentName)
{
ltlTitle.Text += "<span style='color:red'>【转】</span>";
}
ltlAddDate.Text = DateUtils.GetDateAndTimeString(applyInfo.AddDate);
ltlRemark.Text = GovPublicApplyManager.GetApplyRemark(applyInfo.Id);
ltlDepartment.Text = departmentName;
ltlLimit.Text = EGovPublicApplyLimitTypeUtils.GetText(limitType);
ltlState.Text = EGovPublicApplyStateUtils.GetText(applyInfo.State);
if (applyInfo.State == EGovPublicApplyState.New)
{
ltlState.Text = $"<span style='color:red'>{ltlState.Text}</span>";
}
else if (applyInfo.State == EGovPublicApplyState.Redo)
{
ltlState.Text = $"<span style='color:red'>{ltlState.Text}</span>";
}
ltlFlowUrl.Text =
$@"<a href=""javascript:;"" onclick=""{ModalGovPublicApplyFlow.GetOpenWindowString(
PublishmentSystemId, applyInfo.Id)}"">轨迹</a>";
ltlViewUrl.Text =
$@"<a href=""javascript:;"" onclick=""{ModalGovPublicApplyView.GetOpenWindowString(
PublishmentSystemId, applyInfo.Id)}"">查看</a>";
}
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
PageUtils.CheckRequestParameter("PublishmentSystemID", "ApplyID", "ReturnUrl");
applyInfo = DataProvider.GovPublicApplyDao.GetApplyInfo(TranslateUtils.ToInt(Request.QueryString["ApplyID"]));
returnUrl = StringUtils.ValueFromUrl(Request.QueryString["ReturnUrl"]);
if (!IsPostBack)
{
if (!applyInfo.IsOrganization)
{
ltlType.Text = "公民";
phCivic.Visible = true;
phOrg.Visible = false;
ltlCivicName.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicName);
ltlCivicOrganization.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicOrganization);
ltlCivicCardType.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicCardType);
ltlCivicCardNo.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicCardNo);
ltlCivicPhone.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicPhone);
ltlCivicPostCode.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicPostCode);
ltlCivicAddress.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicAddress);
ltlCivicEmail.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicEmail);
ltlCivicFax.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.CivicFax);
ltlName.Text = ltlCivicName.Text;
}
else
{
ltlType.Text = "法人/其他组织";
phCivic.Visible = false;
phOrg.Visible = true;
ltlOrgName.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgName);
ltlOrgUnitCode.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgUnitCode);
ltlOrgLegalPerson.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgLegalPerson);
ltlOrgLinkName.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgLinkName);
ltlOrgPhone.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgPhone);
ltlOrgPostCode.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgPostCode);
ltlOrgAddress.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgAddress);
ltlOrgEmail.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgEmail);
ltlOrgFax.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.OrgFax);
ltlName.Text = ltlOrgName.Text;
}
ltlState.Text = EGovPublicApplyStateUtils.GetText(applyInfo.State);
ltlQueryCode.Text = applyInfo.QueryCode;
ltlTitle.Text = applyInfo.Title;
ltlContent.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.Content);
ltlPurpose.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.Purpose);
ltlIsApplyFree.Text = TranslateUtils.ToBool(applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.Content)) ? "申请" : "不申请";
ltlProvideType.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.ProvideType);
ltlObtainType.Text = applyInfo.GetExtendedAttribute(GovPublicApplyAttribute.ObtainType);
if (phReply != null)
{
if (applyInfo.State == EGovPublicApplyState.Denied || applyInfo.State == EGovPublicApplyState.Replied || applyInfo.State == EGovPublicApplyState.Redo || applyInfo.State == EGovPublicApplyState.Checked)
{
var replyInfo = DataProvider.GovPublicApplyReplyDao.GetReplyInfoByApplyId(applyInfo.Id);
if (replyInfo != null)
{
phReply.Visible = true;
ltlDepartmentAndUserName.Text =
$"{DepartmentManager.GetDepartmentName(replyInfo.DepartmentID)}({replyInfo.UserName})";
ltlAddDate.Text = DateUtils.GetDateAndTimeString(replyInfo.AddDate);
ltlReply.Text = replyInfo.Reply;
ltlFileUrl.Text = replyInfo.FileUrl;
}
}
}
if (divAddDepartment != null)
{
divAddDepartment.Attributes.Add("onclick", ModalGovPublicCategoryDepartmentSelect.GetOpenWindowString(PublishmentSystemId));
var scriptBuilder = new StringBuilder();
if (applyInfo.DepartmentId > 0)
{
var departmentName = DepartmentManager.GetDepartmentName(applyInfo.DepartmentId);
scriptBuilder.Append(
$@"<script>showCategoryDepartment('{departmentName}', '{applyInfo.DepartmentId}');</script>");
}
ltlScript.Text = scriptBuilder.ToString();
}
rptRemarks.DataSource = DataProvider.GovPublicApplyRemarkDao.GetDataSourceByApplyId(applyInfo.Id);
rptRemarks.ItemDataBound += rptRemarks_ItemDataBound;
rptRemarks.DataBind();
if (rptLogs != null)
{
rptLogs.DataSource = DataProvider.GovPublicApplyLogDao.GetDataSourceByApplyId(applyInfo.Id);
rptLogs.ItemDataBound += rptLogs_ItemDataBound;
rptLogs.DataBind();
}
}
}
