public void ProcessRequest(HttpContext context)
{
//string unit = String.IsNullOrEmpty(context.Request["unit"].ToString()) ? string.Empty : context.Request["unit"].ToString();
//传过来的文本框内容
string time = String.IsNullOrEmpty(context.Request["beginTime"].ToString()) ? "1900-01" : context.Request["beginTime"].ToString();
//月，季，年
string timeType = String.IsNullOrEmpty(context.Request["timeType"].ToString()) ? string.Empty : context.Request["timeType"].ToString();
//传过来的季度
string quarterType = String.IsNullOrEmpty(context.Request["quarterType"].ToString()) ? "-1" : context.Request["quarterType"].ToString();
//先根据paraId，取出所有paraId的outtable,循环outtable,取平均值。
info allInfo = new info();
List<ConsumeInfo> infoList = new List<ConsumeInfo>();
infoList = bl.get(time, timeType, quarterType, out errMsg);
ConsumeInfo info = new ConsumeInfo();
info.ConsumeValue = 23;
info.Name = "七月份耗差平均";
info.RealValue = 34;
info.StandardValue = 12.4;
infoList.Add(info);
info = new ConsumeInfo();
info.ConsumeValue = 23;
info.Name = "七月份分项比例";
info.RealValue = 34;
info.StandardValue = 12.4;
infoList.Add(info);
//表格
//string content = infoList.ToJsonItem();
int count = 0;
object obj = new
{
total = count,
rows = infoList
};
//列名
//List<column> col = new List<column>();
//foreach (var info in infoList)
//{
// column c = new column();
// c.field = info.Name;
// c.title = info.Name;
// c.width = "150px";
// c.align = "center";
//}
//string lm = JsonConvert.SerializeObject(col);
string result = JsonConvert.SerializeObject(infoList);
context.Response.ContentType = "text/json;charset=gb2312;";
context.Response.Write(result);
}
/// <summary>
/// 获取第一次全取出来的数据。再过滤。 在GetBase函数中 循环。。。 paraId+_el_B再循环得到实际值.....
/// </summary>
/// <param name="unitId"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public List<info> GetFirstInfo(string unitId, out string errMsg)
{
DataTable dt = el.GetTableName(unitId, out errMsg);
List<info> infoList = new List<info>();
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr["T_OUTTABLE"].ToString()))
{
info tmp = new info();
tmp.TableName = dr["T_OUTTABLE"].ToString();
tmp.UnitId = dr["T_UNITID"].ToString();
tmp.ParaId = dr["T_PARAID"].ToString();
tmp.Unit = dr["T_UNIT"].ToString();
tmp.TargetType = Convert.ToInt32(dr["I_TARGETTYPE"].ToString());
tmp.ConsumeType = Convert.ToInt32(dr["I_CONSUMETYPE"].ToString());
tmp.Order = Convert.ToInt32(dr["I_ORDER"].ToString());
infoList.Add(tmp);
}
else
{
continue;
}
}
}
return infoList;
}
