/// <summary>
/// 创建时间：2017/5/8
/// 查看报表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
private void LookAdvisory(HttpContext context)
{
try
{
int id = 0;
if (Common.GetRequest("id") != null && Common.GetRequest("id") != "")
{
id = Convert.ToInt32(Common.GetRequest("id"));
}
AdvisoryStatisticsService.AdvisoryStatisticsModel entity = MgrServices.AdvisoryStatisticsService.LookAdvisory(id);
String json = Common.ObjectToJson(entity);
context.Response.Write(json);
}
catch
{
}
}
/// <summary>
/// 创建时间：2017/5/9
/// 添加个体咨询档案报表
/// </summary>
/// <param name="context"></param>
private void AddPersonStatementInfo(HttpContext context)
{
try
{
string id = Common.GetRequest("id");
string uId = Common.GetSessionValue("UserID", context);
int UserId = 0;
if (uId != null)
{
UserId = Convert.ToInt32(uId);
}
string title = Common.GetRequest("title");
List <object> obj = new List <object>();
DataSet source = MgrServices.AdvisoryStatisticsService.GetPersonalStatementInfo(id, UserId);
string roleName = source.Tables[1].Rows[0][0].ToString();//
PageInfo page = new PageInfo();
bool contentIsNull = true;//判断是否有咨询记录，只要有一条则代表通过
if (source != null && source.Tables.Count > 0)
{
DataTable table1 = source.Tables[0];
var tempTable = table1.AsEnumerable().GroupBy(x => new { D_ID = x.Field <int>("D_ID"), DName = x.Field <string>("D_name") }).Select(x => new
{
D_ID = x.Key.D_ID, //部门ID
dName = x.Key.DName, //部门名称
count = x.Count(y => int.Parse(y["D_ID"].ToString()) == x.Key.D_ID), //人数
womenNum = x.Count(y => y["U_Sex"].ToString() == "女"), //女性人数
manNum = x.Count(y => y["U_Sex"].ToString() == "男"), //男性人数
Severity = 0 //严重程度
}).ToArray();
obj.Add(tempTable); //用来创建表格的数据源，包含部门名称、人数、重点关注人数 0
foreach (DataRow item in table1.Rows)
{
if (item["Content"].ToString() != "")
{
contentIsNull = false;
}
String[] str =
{
item["D_ID"].ToString(), //部门ID 0
item["Id"].ToString(), //ID 1
item["StartDate"].ToString(), //开始时间 2
item["QTName"].ToString(), //问题类型 3
item["Content"].ToString(), //咨询记录JSon 4
item["U_Sex"].ToString() //性别 5
};
page.data.Add(str);
}
}
if (contentIsNull)
{
context.Response.Write(-2);
return;
}
obj.Add(page); //生成图表的数据源。 1
obj.Add(roleName); //角色名称 2
obj.Add(Common.GetSessionValue("loginName", context)); //创建报表的人 3
obj.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); //创建报表的日期 4
string number = GetNumber();
obj.Add(number); //报表编号 5
String json = Common.ObjectToJson(obj);
string _enterpriseCode = Common.GetSessionValue("EnterpriseCode", context);//企业ID
AdvisoryStatisticsService.AdvisoryStatisticsModel entity =
new AdvisoryStatisticsService.AdvisoryStatisticsModel();
entity.Content = title;
entity.CeatePerson = UserId;
entity.CreateTime = Convert.ToDateTime(Convert.ToDateTime(obj[4]).ToString("yyyy/MM/dd HH:mm:ss"));
entity.Number = number;
entity.Result = json;
entity.Type = false;
entity.EnterpriseCode = _enterpriseCode;
int result = MgrServices.AdvisoryStatisticsService.InsertAdvisoryStatistic(entity);
if (result <= 0)
{
context.Response.Write(-1);
return;
}
object[] arr = { entity.Number, result };
context.Response.Write(Common.ObjectToJson(arr));
}
catch
{
context.Response.Write(-1);
}
}
/// <summary>
/// 创建时间：2017/5/9
/// 添加团体咨询档案报表
/// </summary>
/// <param name="context"></param>
private void AddTeamStatementInfo(HttpContext context)
{
try
{
#region
int result = 0;
string id = Common.GetRequest("id");
string uId = Common.GetSessionValue("UserID", context);
int UserId = 0;
if (uId != null)
{
UserId = Convert.ToInt32(uId);
}
string title = Common.GetRequest("title");
List <object> obj = new List <object>();
DataSet source = MgrServices.AdvisoryStatisticsService.GetTeamStatementInfo(id, UserId);
string roleName = source.Tables[1].Rows[0][0].ToString();//
PageInfo page = new PageInfo();
bool contentIsNull = true;//判断是否有咨询记录，只要有一条则代表通过
if (source != null && source.Tables.Count > 0)
{
DataTable table = source.Tables[0];
if (table.Rows.Count > 0)
{
foreach (DataRow item in table.Rows)
{
if (item["Content"].ToString() != "")
{
contentIsNull = false;
}
String[] str =
{
item["Id"].ToString(), //ID 0
item["Number"].ToString(), //档案编号 1
item["CSName"].ToString(), //主题名称 2
item["U_Name"].ToString(), //咨询师姓名 3
item["QTName"].ToString(), //问题类型 4
item["Content"].ToString() //json 5
};
page.data.Add(str);
}
}
if (contentIsNull)
{
context.Response.Write(-2);
return;
}
obj.Add(page); //生成图表的数据源。 0
obj.Add(roleName); //角色名称 1
obj.Add(Common.GetSessionValue("loginName", context)); //创建报表的人 2
obj.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); //创建报表的日期 3
string number = GetNumber();
obj.Add(number); //报表编号 4
String json = Common.ObjectToJson(page);
#endregion
string enterpriseCode = Common.GetSessionValue("EnterpriseCode", context); //企业ID
AdvisoryStatisticsService.AdvisoryStatisticsModel entity =
new AdvisoryStatisticsService.AdvisoryStatisticsModel();
entity.Content = title;
entity.CeatePerson = UserId;
entity.CreateTime =
Convert.ToDateTime(Convert.ToDateTime(obj[3]).ToString("yyyy/MM/dd HH:mm:ss"));
entity.Number = number;
entity.Result = json;
entity.Type = true;
entity.EnterpriseCode = enterpriseCode;
result = MgrServices.AdvisoryStatisticsService.InsertAdvisoryStatistic(entity);
if (result <= 0)
{
context.Response.Write(-1);
return;
}
object[] arr = { entity.Number, result };
context.Response.Write(Common.ObjectToJson(arr));
}
}
catch
{
}
}
