public void exportExcel()
{
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
//List<ColumnInfo> records = JavaScriptConvert.DeserializeObject<List<ColumnInfo>>(ht["params"].ToString());
List <ColumnInfo> headers = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["headers"].ToString());
List <ColumnInfo> atdtParameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["atdtparams"].ToString());
List <ColumnInfo> personalParameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["personalparams"].ToString());
string scope = ht["scope"].ToString();
List <ColumnInfo> fullParameters = new List <ColumnInfo>();
for (int i = 0; i < personalParameters.Count; i++)
{
fullParameters.Add(personalParameters[i]);
}
for (int i = 0; i < atdtParameters.Count; i++)
{
fullParameters.Add(atdtParameters[i]);
}
fullParameters.Add(new ColumnInfo()
{
ColumnName = "atst", ColumnValue = (scope == "All" ? "" : "1")
}); //1: abnormal
atanarstBll bll = new atanarstBll();
int total = 0;
List <object> obj = bll.GetAnalyzeResult(fullParameters, false, 0, 0, ref total);
if ((obj != null) && (total > 0))
{
List <object> finalObj = BuildAnonymousObject(obj).Cast <object>().ToList();
UtilExcel.ExportToExcel(finalObj[0].GetType(), Response, this.GetType().Name.GetPageName(), headers, finalObj);
}
}
catch (Exception ex)
{
string message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
public void listAnalResult()
{
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
List <ColumnInfo> atdtParameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["atdateparams"].ToString());
List <ColumnInfo> personalParameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["personalparams"].ToString());
string scope = ht["scope"].ToString();
int start = Convert.ToInt32(this.Request["start"]);
int limit = Convert.ToInt32(this.Request["limit"]);
//list(atdtParameters, personalParameters, start, limit, scope);
List <ColumnInfo> fullParameters = new List <ColumnInfo>();
for (int i = 0; i < personalParameters.Count; i++)
{
fullParameters.Add(personalParameters[i]);
}
for (int i = 0; i < atdtParameters.Count; i++)
{
fullParameters.Add(atdtParameters[i]);
}
fullParameters.Add(new ColumnInfo()
{
ColumnName = "atst", ColumnValue = (scope == "All" ? "" : "1")
}); //1: abnormal
atanarstBll bll = new atanarstBll();
int total = 0;
List <object> dataList = bll.GetAnalyzeResult(fullParameters, true, start, start + limit, ref total);
string json = JavaScriptConvert.SerializeObject(dataList);
Response.Write("{results:" + total + ",rows:" + json + "}");
}
catch (Exception ex)
{
string message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
