protected void Page_Load(object sender, EventArgs e)
{
string param = Request["param"].ToLower(), paras = "";
var rptName = HttpUtility.UrlDecode(Request["name"] ?? string.Empty);
var qTime = Request["time"] ?? string.Empty;
var orgId = Request["orgid"] ?? string.Empty;
var tid = Request["treeid"] ?? string.Empty;
var rptid = Request["rptid"] ?? string.Empty;
//点查询按钮
if (param == "query")
{
try
{
var bll = new BLL.BLLReport();
var styleObj = bll.GetRptStyle(rptid, tid, orgId);
var style = styleObj.RptStyle;
var dType = styleObj.styleType;
if (dType == "D")
qTime = DateTime.Parse(qTime).ToString("yyyy-MM-dd 0:00:00");
else if (dType == "M" || dType == "MM")
qTime = DateTime.Parse(qTime).ToString("yyyy-MM-01 0:00:00");
else if (dType == "Y" || dType == "YY")
qTime = qTime + "-01-01 0:00:00";
if (!string.IsNullOrEmpty(style))
{
string msg;
var ht = GetRptData(dType, rptid, orgId, tid, Convert.ToDateTime(qTime), out msg);
CreateReport(ht, style);
}
else
{ Response.Write("<span>此机构暂无该报表<span>"); }
}
catch (System.Exception ex)
{
Response.Write("<span>" + ex.Message + "<span>");
}
}
else if (param == "isdate")
{
var bll = new BLL.BLLReport();
var styleObj = bll.GetRptStyle(rptid, tid, orgId);
var dateType = styleObj.styleType;
object obj = new
{
dateType = dateType
};
string result = Newtonsoft.Json.JsonConvert.SerializeObject(obj);
Response.Write(result);
Response.End();
}
}
private void CreateReport(IDictionary idc, string rptName, string treeId, string orgId)
{
var bll = new BLL.BLLReport();
//var styleObj = bll.GetRptStyleByName(rptName);
var styleObj = bll.GetRptStyle(rptName, treeId, orgId);
var style = styleObj.RptStyle;
if (!string.IsNullOrEmpty(style))
{
var sp1 = new SpreadsheetClass();
var doc = new XmlDocument();
doc.LoadXml(style);
var xn = new XmlNamespaceManager(doc.NameTable);
xn.AddNamespace("ss", "urn:schemas-microsoft-com:office:spreadsheet");
var nodes = doc.SelectNodes("//ss:Data", xn);
//根据key替换数据
foreach (XmlNode node in nodes)
{
var tmpValue = node.InnerText.Trim();
if (tmpValue.Length > 2 && tmpValue.Substring(0, 1) == "♂")
{
node.InnerText = idc.Contains(tmpValue) ? idc[tmpValue].ToString() : string.Empty;
//style = style.Replace(tmpValue, node.InnerText);
}
}
//sp1.XMLData = style;
sp1.XMLData = doc.OuterXml;
//dvShow.InnerHtml = sp1.HTMLData;
sp1.XMLData = sp1.XMLData.Replace("ss:Table", "ss:Table ss:id=\"CX\"");
Response.Write(sp1.HTMLData);
}
else
{
//Response.Write("<script>alert('set style first.')</script>");
//dvShow.InnerHtml = "报表样式未设置，请先设置报表样式";
Response.Write("<span>请先设置报表样式<span>");
}
}
private void CreateReport(IDictionary idc, string rptName, string treeId, string orgId)
{
var bll = new BLL.BLLReport();
//var styleObj = bll.GetRptStyleByName(rptName);
var styleObj = bll.GetRptStyle(rptName, treeId, orgId);
var style = styleObj.RptStyle;
if (!string.IsNullOrEmpty(style))
{
var sp1 = new SpreadsheetClass();
var doc = new XmlDocument();
doc.LoadXml(style);
var xn = new XmlNamespaceManager(doc.NameTable);
xn.AddNamespace("ss", "urn:schemas-microsoft-com:office:spreadsheet");
var nodes = doc.SelectNodes("//ss:Data", xn);
//根据key替换数据
foreach (XmlNode node in nodes)
{
var tmpValue = node.InnerText.Trim();
if (tmpValue.Length > 2 && tmpValue.Substring(0, 1) == "♂")
{
node.InnerText = idc.Contains(tmpValue) ? idc[tmpValue].ToString() : string.Empty;
//style = style.Replace(tmpValue, node.InnerText);
}
}
//sp1.XMLData = style;
sp1.XMLData = doc.OuterXml;
//dvShow.InnerHtml = sp1.HTMLData;
sp1.XMLData = sp1.XMLData.Replace("ss:Table", "ss:Table ss:id=\"CX\"");
Response.Write(sp1.HTMLData);
}
else
{
//Response.Write("<script>alert('set style first.')</script>");
//dvShow.InnerHtml = "报表样式未设置，请先设置报表样式";
Response.Write("<span>请先设置报表样式<span>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string param = Request["param"].ToLower(), paras = "";
var rptName = HttpUtility.UrlDecode(Request["name"] ?? string.Empty);
var qTime = Request["time"] ?? string.Empty;
var orgId = Request["orgid"] ?? string.Empty;
var tid = Request["treeid"] ?? string.Empty;
var rptid = Request["rptid"] ?? string.Empty;
//点查询按钮
if (param == "query")
{
try
{
var bll = new BLL.BLLReport();
var styleObj = bll.GetRptStyle(rptid, tid, orgId);
var style = styleObj.RptStyle;
var dType = styleObj.styleType;
if (dType == "D")
{
qTime = DateTime.Parse(qTime).ToString("yyyy-MM-dd 0:00:00");
}
else if (dType == "M" || dType == "MM")
{
qTime = DateTime.Parse(qTime).ToString("yyyy-MM-01 0:00:00");
}
else if (dType == "Y" || dType == "YY")
{
qTime = qTime + "-01-01 0:00:00";
}
if (!string.IsNullOrEmpty(style))
{
string msg;
var ht = GetRptData(dType, rptid, orgId, tid, Convert.ToDateTime(qTime), out msg);
CreateReport(ht, style);
}
else
{
Response.Write("<span>此机构暂无该报表<span>");
}
}
catch (System.Exception ex)
{
Response.Write("<span>" + ex.Message + "<span>");
}
}
else if (param == "isdate")
{
var bll = new BLL.BLLReport();
var styleObj = bll.GetRptStyle(rptid, tid, orgId);
var dateType = styleObj.styleType;
object obj = new
{
dateType = dateType
};
string result = Newtonsoft.Json.JsonConvert.SerializeObject(obj);
Response.Write(result);
Response.End();
}
}