//新进住民环境适应及辅导记录 zhongyh
private void NewRegEnvAdaptation(WordDocument doc, ReportRequest request)
{
ISocialWorkerManageService reportManageService = IOCContainer.Instance.Resolve <ISocialWorkerManageService>();
var bd = reportManageService.GetNewRegEnvAdaptationById(request.id);
var orginfo = orgserver.GetOrg(bd.Data.ORGID);
var p = orgserver.GetEmployee(bd.Data.CREATEBY);
var response = new BaseResponse <List <object> >(new List <object>());
response.Data.Add
(new
{
NAME = request.feeName,
INDATE = bd.Data.INDATE,
W1EVALDATE = bd.Data.W1EVALDATE,
INFORMFLAG = (bd.Data.INFORMFLAG == 1) ? "是" : "否",
COMMFLAG = (bd.Data.COMMFLAG == 1) ? "是" : "否",
INTERPERSONAL = bd.Data.INTERPERSONAL,
PARTICIPATION = bd.Data.PARTICIPATION,
COORDINATION = bd.Data.COORDINATION,
EMOTION = bd.Data.EMOTION,
RESISTANCE = bd.Data.RESISTANCE,
HELP = bd.Data.HELP,
PROCESSACTIVITY = bd.Data.PROCESSACTIVITY,
TRACEREC2 = bd.Data.TRACEREC,
WEEK = bd.Data.WEEK,
W2EVALDATE = bd.Data.W2EVALDATE,
W3EVALDATE = bd.Data.W3EVALDATE,
W4EVALDATE = bd.Data.W4EVALDATE,
W1EVALUATION = bd.Data.EVALUATION,
CREATEBY = p.Data != null?p.Data.EmpName:"",
ORG = orginfo.Data.OrgName,
});
BindData(response.Data[0], doc);
}
public IHttpActionResult Query(string keyWord, string keyword2, string MODIFYFLAG, string orgid, int currentPage, int pageSize)
{
BaseRequest <DC_COMMFILEFilter> request = new BaseRequest <DC_COMMFILEFilter>();
request.CurrentPage = currentPage;
request.PageSize = pageSize;
//字典名称和编号
if (!string.IsNullOrEmpty(keyWord))
{
request.Data.ITEMTYPE = keyWord;
request.Data.TYPENAME = keyWord;
}
//字典子项名称和编号
if (!string.IsNullOrEmpty(keyword2))
{
request.Data.SUBITEMNAME = keyword2;
}
//字典状态
if (!string.IsNullOrEmpty(MODIFYFLAG))
{
request.Data.MODIFYFLAG = MODIFYFLAG;
}
//if (!string.IsNullOrEmpty(orgid))
//{ request.Data.ORGID = orgid; }
//else
//{
// request.Data.ORGID = SecurityHelper.CurrentPrincipal.OrgId;//默认查当前用户所在的组织
//}
var orginfo = orgserver.GetOrg(request.Data.ORGID);
var responseByQuery = service.QueryDCcommfile(request);
var response = new BaseResponse <List <object> >(new List <object>());
response.CurrentPage = responseByQuery.CurrentPage;
response.PagesCount = responseByQuery.PagesCount;
response.RecordsCount = responseByQuery.RecordsCount;
Array.ForEach(responseByQuery.Data.ToArray(), (item) =>
{
response.Data.Add(new
{
ITEMTYPE = item.ITEMTYPE,
TYPENAME = item.TYPENAME,
MODIFYFLAG = item.MODIFYFLAG,
DESCRIPTION = item.DESCRIPTION,
ORGID = orginfo.Data.OrgName //SecurityHelper.CurrentPrincipal.UserId + SecurityHelper.CurrentPrincipal.LoginName
});
}); //item.ORGID +
return(Ok(response));
}
protected string GetOrgName(string orgId)
{
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
var org = organizationManageService.GetOrg(orgId);
return(org.Data == null ? "" : org.Data.OrgName);
}
/// <summary>
/// IADL表
/// </summary>
/// <param name="doc"></param>
private void IADLOperation(WordDocument doc)
{
int feeNo = 7;
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
var org = organizationManageService.GetOrg(SecurityHelper.CurrentPrincipal.OrgId);
doc.ReplaceText("Org", org.Data.OrgName);
IReportManageService reportManageService = IOCContainer.Instance.Resolve <IReportManageService>();
var questionList = reportManageService.GetQuestionList(feeNo, 7);
if (questionList.Count == 0)
{
InitData(typeof(Question), doc);
InitValue(81, 88, doc);
return;
}
List <Dictionary <string, string> > list = new List <Dictionary <string, string> >();
foreach (var question in questionList)
{
var dict = new Dictionary <string, string>();
BindData(question, doc, dict);
var answers = reportManageService.GetAnswers(question.Id).ToList();
for (var i = 81; i <= 88; i++)
{
var answer = answers.Find(o => o.Id == i);
dict.Add("Value" + i, answer != null ? answer.Value : "未填");
}
list.Add(dict);
}
doc.FillTable(0, list);
}
/// <summary>
/// P11约束月统计表
/// </summary>
/// <param name="doc"></param>
private void P11Operation(WordDocument doc)
{
DateTime date = DateTime.Parse("2016-04-01");
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
var org = organizationManageService.GetOrg(SecurityHelper.CurrentPrincipal.OrgId);
doc.ReplaceText("Org", org.Data.OrgName);
doc.ReplaceText("Year", date.Year.ToString());
doc.ReplaceText("Month", date.Month.ToString());
IReportManageService reportManageService = IOCContainer.Instance.Resolve <IReportManageService>();
var constraintList = reportManageService.GetConstraintList(date);
string key = string.Empty;
dynamic[] tags = new dynamic[] {
new { Type = "ExecReason", Value = "001", Text = "因预防跌倒而使用身体约束人数（bl)" },
new { Type = "ExecReason", Value = "002", Text = "因预防自拔管路而使用身体约束人数（b2)" },
new { Type = "ExecReason", Value = "003", Text = "因预防自伤而使用身体约束人数（b3)" },
new { Type = "ExecReason", Value = "004", Text = "因行为紊乱而使用身体约束人数（b4)" },
new { Type = "ExecReason", Value = "005", Text = "因协助治疗而使用身体约束人数（b5)" },
new { Type = "ExecReason", Value = "006", Text = "因其他因素而使用身体约束人数（b6)" },
new { Type = "Duration", Value = "002", Text = "约束持续大於4小时小於等於8小时人数（cl)" },
new { Type = "Duration", Value = "003", Text = "约束持续大於8小时小於等於16小时人数（c2)" },
new { Type = "Duration", Value = "004", Text = "约束持续大於16小时小於等於24小时人数（c3)" },
new { Type = "Duration", Value = "005", Text = "约束持续大於24小时人数（c4)" },
new { Type = "ConstraintWay", Value = "002", Text = "受身体约束二种以上住民人数(d)" },
new { Type = "Cancel", Value = "24Flag", Text = "当月移除身体约束至少维持24小时以上之住民人数(e)" },
};
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("name");
dt.Columns.Add("total");
foreach (dynamic item in tags)
{
dr = dt.NewRow();
dr["name"] = item.Text;
switch ((string)item.Type)
{
case "ExecReason":
dr["total"] = constraintList.Count(it => it.ExecReason == item.Value);
break;
case "Duration":
dr["total"] = constraintList.Count(it => it.Duration == item.Value);
break;
case "ConstraintWay":
dr["total"] = constraintList.Count(it => it.ConstraintWayCnt == "002");
break;
case "Cancel":
dr["total"] = constraintList.Count(it => it.Cancel24Flag);
break;
}
dt.Rows.Add(dr);
doc.ReplaceText(string.Format("{0}{1}", item.Type, item.Value), dr["total"].ToString());
}
doc.FillChartData(0, dt, 10);
dt.Dispose();
}
public IHttpActionResult Query(string empNo = "", string empName = "", string empGroup = "", string orgid = "", int currentPage = 1, int pageSize = 10, int needEmp = 0, int needShort = 0)
{
BaseRequest <EmployeeFilter> request = new BaseRequest <EmployeeFilter>()
{
CurrentPage = currentPage,
PageSize = pageSize,
Data =
{
OrgId = SecurityHelper.CurrentPrincipal.OrgId,
EmpNo = empNo,
EmpName = empName,
EmpGroup = empGroup,
NeedEmp = needEmp
}
};
//自定义机构 针对超级管理员zhongyh
if (!string.IsNullOrEmpty(orgid))
{
request.Data.OrgId = orgid;
}
var orginfo = empFileService.GetOrg(request.Data.OrgId);//取机构名称
var response = new BaseResponse <IList <Employee> >();
if (needEmp > 0)
{
var responseObject = new BaseResponse <List <object> >();
response = empFileService.QueryUserUnionEmp(request);
}
else
{
response = empFileService.QueryEmployee(request);
}
if (needShort > 0)
{
var responseObject = new BaseResponse <IList <Object> >()
{
Data = new List <object>()
};
foreach (var item in response.Data)
{
responseObject.Data.Add(new { EmpName = item.EmpName, EmpNo = item.EmpNo });
}
return(Ok(responseObject));
}
else
{
foreach (var item in response.Data)
{
item.OrgId = orginfo.Data.OrgName;
}
return(Ok(response));
}
}
public IHttpActionResult Query(string keyWord, string Activecode, string orgid, int currentPage = 1, int pageSize = 10)
{
BaseRequest <DC_TeamActivitydtlFilter> request = new BaseRequest <DC_TeamActivitydtlFilter>();
request.CurrentPage = currentPage;
request.PageSize = pageSize;
if (!string.IsNullOrEmpty(Activecode))
{
request.Data.ACTIVITYCODE = Activecode;
}
request.Data.TITLENAME = keyWord;
if (!string.IsNullOrEmpty(orgid))
{
request.Data.ORGID = orgid;
}
else
{
request.Data.ORGID = SecurityHelper.CurrentPrincipal.OrgId;
}
var orginfo = orgserver.GetOrg(request.Data.ORGID);
var responseByQuery = service.QueryTeamActivitydtl(request);
var response = new BaseResponse <List <object> >(new List <object>());
response.CurrentPage = responseByQuery.CurrentPage;
response.PagesCount = responseByQuery.PagesCount;
response.RecordsCount = responseByQuery.RecordsCount;
Array.ForEach(responseByQuery.Data.ToArray(), (item) =>
{
if (!(string.IsNullOrEmpty(item.TITLENAME) && string.IsNullOrEmpty(item.ITEMNAME)))
{
response.Data.Add(new
{
ID = item.ID,
SEQNO = item.SEQNO,//item.SEQNO,
TITLENAME = item.TITLENAME,
ACTIVITYCODE = item.ACTIVITYCODE,
ITEMNAME = item.ITEMNAME,
ORGID = orginfo.Data.OrgName
}
);
}
});
return(Ok(response));
}
/// <summary>
/// 院内感染指标统计表
/// </summary>
/// <param name="doc"></param>
private void Infectionperation(WordDocument doc)
{
DateTime date = DateTime.Parse("2016-05-01");
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
var org = organizationManageService.GetOrg(SecurityHelper.CurrentPrincipal.OrgId);
doc.ReplaceText("Org", org.Data.OrgName);
doc.ReplaceText("Year", date.Year.ToString());
doc.ReplaceText("Month", date.Month.ToString());
IReportManageService reportManageService = IOCContainer.Instance.Resolve <IReportManageService>();
var list = reportManageService.GetInfection(date);
//doc.ReplaceText("totalB",list.Sum(o=>o.Total).ToString());
//var keys = new[] { "001", "002", "003", "004", "005" };
//for (int i = 0; i < keys.Length; i++)
//{
// var obj = list.FirstOrDefault(o => o.Type == keys[i]);
// doc.ReplaceText(i.ToString(), obj == null ? "" : obj.Total.ToString());
//}
//doc.ReplaceText("totalC", list.Where(o=>o.Type==keys[0] || o.Type==keys[1]).Sum(o => o.Total).ToString());
//doc.ReplaceText("totalD", list.Where(o => o.Type == keys[2] || o.Type == keys[3]).Sum(o => o.Total).ToString());
//var constraintList = reportManageService.GetInfectionIndList(date);
//string key = string.Empty;
dynamic[] tags = new dynamic[] {
new { Type = "totalB", Value = "001,002,003,004,005", Text = "总感染人次(b)" },
new { Type = "totalC", Value = "001,002", Text = "呼吸道感染人次(c)" },
new { Type = "001", Value = "001", Text = "上呼吸道感染人次(cl)" },
new { Type = "002", Value = "002", Text = "下呼吸道感染人次(c2)" },
new { Type = "totalD", Value = "003,004", Text = "泌尿道感染人次(d)" },
new { Type = "003", Value = "003", Text = "当月使用存留导尿管泌尿道感染人次(dl)" },
new { Type = "004", Value = "004", Text = "当月未使用存留导尿管泌尿道感染人次(d2)" },
new { Type = "005", Value = "005", Text = "疥疮感染人次(g)" }
};
DataTable dt = new DataTable();
dt.Columns.Add("name");
dt.Columns.Add("total");
foreach (dynamic item in tags)
{
var dr = dt.NewRow();
dr["name"] = item.Text;
string[] types = item.Value.Split(',');
dr["total"] = list.Where(o => types.Contains(o.Type)).Sum(o => o.Total);
dt.Rows.Add(dr);
doc.ReplaceText(item.Type, dr["total"].ToString());
}
doc.FillChartData(0, dt, 10);
dt.Dispose();
}
/// <summary>
/// 家庭照顾者生活品质评估问卷
/// </summary>
/// <param name="doc"></param>
/// <param name="request"></param>
private void RegLifeQualityEvalOperation(WordDocument doc, ReportRequest request)
{
var question = service.GetRegLifeQualityEvalById(request.id);
var basic = reportManageService.GetBasicInfoById(Convert.ToInt32(question.Data.FeeNo));
var org = organizationManageService.GetOrg(SecurityHelper.CurrentPrincipal.OrgId);
if (basic != null)
{
doc.ReplaceText("Org", org.Data.OrgName);
doc.ReplaceText("ResidentNo", basic.Data.ResidentNo);
doc.ReplaceText("Name", basic.Data.RegName);
doc.ReplaceText("Nick", basic.Data.NickName == null ? "" : basic.Data.NickName);
}
if (question == null)
{
return;
}
else
{
question.Data.Ability = question.Data.FamilyAbility;
}
BindData(question.Data, doc);
}
/// <summary>
/// P14社工服务记录
/// </summary>
/// <param name="doc"></param>
private void P14Operation(WordDocument doc)
{
long feeNo = 7;
int careSvrId = 18;
IResidentManageService residentManageService = IOCContainer.Instance.Resolve <IResidentManageService>();
ISocialWorkerManageService socialWorkerManageService = IOCContainer.Instance.Resolve <ISocialWorkerManageService>();
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
IDictManageService dictManageService = IOCContainer.Instance.Resolve <IDictManageService>();
ICarePlansManageService carePlansManageService = IOCContainer.Instance.Resolve <ICarePlansManageService>();
var resident = residentManageService.GetResident(feeNo);
if (resident.Data == null)
{
return;
}
var person = residentManageService.GetPerson(resident.Data.RegNo ?? 0);
var careSvr = socialWorkerManageService.GetCareSvrById(careSvrId);
var emp = organizationManageService.GetEmployee(careSvr.Data.Carer);
var org = organizationManageService.GetOrg(SecurityHelper.CurrentPrincipal.OrgId);
var diaPR = carePlansManageService.GetDiaPR("001", careSvr.Data.QuestionLevel);
CodeFilter request = new CodeFilter();
request.ItemTypes = new string[] { "K00.017", "E00.215", "E00.216", "E00.217" };
var dict = (List <CodeValue>)dictManageService.QueryCode(request).Data;
doc.ReplaceText("Org", org.Data.OrgName);
doc.ReplaceText("Name", person.Data.Name);
doc.ReplaceText("FeeNo", feeNo.ToString());
//doc.ReplaceText("Inday", resident.Data.InDate.HasValue ? resident.Data.InDate.Value.ToString("yyyy-MM-dd") : "");
doc.ReplaceText("RoomNo", resident.Data.RoomNo);
doc.ReplaceText("Area", resident.Data.Floor);
doc.ReplaceText("RecDate", careSvr.Data.RecDate.HasValue ? careSvr.Data.RecDate.Value.ToString("yyyy-MM-dd") : "");
doc.ReplaceText("Carer", emp.Data.EmpName);
doc.ReplaceText("SvrAddress", dict.Find(it => it.ItemType == "K00.017" && it.ItemCode == careSvr.Data.SvrAddress).ItemName);
doc.ReplaceText("SvrType", dict.Find(it => it.ItemType == "E00.215" && it.ItemCode == careSvr.Data.SvrType).ItemName);
doc.ReplaceText("SvrPeople", careSvr.Data.SvrPeople);
doc.ReplaceText("RelationType", dict.Find(it => it.ItemType == "E00.216" && it.ItemCode == careSvr.Data.RelationType).ItemName);
doc.ReplaceText("EvalStatus", dict.Find(it => it.ItemType == "E00.217" && it.ItemCode == careSvr.Data.EvalStatus).ItemName);
doc.ReplaceText("EvalShour", careSvr.Data.EvalMinutes.HasValue ? ((decimal)careSvr.Data.EvalMinutes.Value / 60).ToString("F2") : "");
//doc.ReplaceText("H32_no", careSvrId.ToString());
doc.ReplaceText("ProcessActivity", careSvr.Data.ProcessActivity);
//doc.ReplaceText("QuestionLevel", careSvr.Data.QuestionLevel);
doc.ReplaceText("QuestionFocus", diaPR.Data.Find(it => it.ItemCode == careSvr.Data.QuestionFocus).ItemName);
doc.ReplaceText("QuestionDesc", careSvr.Data.QuestionDesc);
doc.ReplaceText("TreatDesc", careSvr.Data.TreatDesc);
doc.ReplaceText("EvalDesc", careSvr.Data.EvalDesc);
}
public ActionResult ResidentExport()
{
string templateName = Request["templateName"];
string startDateStr = Request["startDate"];
string endDateStr = Request["endDate"];
string floorId = Request["floorId"] ?? "";
int feeNo = 0;
if (Request["feeNo"] != null)
{
feeNo = int.Parse(Request["feeNo"]);
}
if (floorId != "")
{
feeNo = 0;
}
ResidentFilter.Data.FeeNo = feeNo;
ResidentFilter.Data.FloorId = floorId;
list = residentService.QueryResidentExtend(ResidentFilter);
#region 新近住民环境及辅导记录
if (templateName == "LTC_NEWEnvironmentTutor")
{
using (WordDocument doc = new WordDocument())
{
doc.LoadModelDoc(templateName);
foreach (Resident r in list.Data)
{
BaseRequest BaseRequest = new BaseRequest();
BaseRequest <NewResideEntenvRecFilter> request = new BaseRequest <NewResideEntenvRecFilter>();
request.Data.FEENO = r.FeeNo;
var NewRegEnvAdaptation = reportManageService.QueryNewRegEnvAdaptation(request);
for (var i = 0; i < NewRegEnvAdaptation.Data.Count; i++)
{
//实例化一个模板
doc.NewPartDocument();
var orginfo = orgserver.GetOrg(NewRegEnvAdaptation.Data[i].ORGID);
var p = orgserver.GetEmployee(NewRegEnvAdaptation.Data[i].CREATEBY);
var response = new BaseResponse <List <object> >(new List <object>());
response.Data.Add
(new
{
NAME = r.Name,
INDATE = NewRegEnvAdaptation.Data[i].INDATE,
W1EVALDATE = NewRegEnvAdaptation.Data[i].W1EVALDATE,
INFORMFLAG = (NewRegEnvAdaptation.Data[i].INFORMFLAG == 1) ? "是" : "否",
COMMFLAG = (NewRegEnvAdaptation.Data[i].COMMFLAG == 1) ? "是" : "否",
INTERPERSONAL = NewRegEnvAdaptation.Data[i].INTERPERSONAL,
PARTICIPATION = NewRegEnvAdaptation.Data[i].PARTICIPATION,
COORDINATION = NewRegEnvAdaptation.Data[i].COORDINATION,
EMOTION = NewRegEnvAdaptation.Data[i].EMOTION,
RESISTANCE = NewRegEnvAdaptation.Data[i].RESISTANCE,
HELP = NewRegEnvAdaptation.Data[i].HELP,
PROCESSACTIVITY = NewRegEnvAdaptation.Data[i].PROCESSACTIVITY,
TRACEREC2 = NewRegEnvAdaptation.Data[i].TRACEREC,
WEEK = NewRegEnvAdaptation.Data[i].WEEK,
W2EVALDATE = NewRegEnvAdaptation.Data[i].W2EVALDATE,
W3EVALDATE = NewRegEnvAdaptation.Data[i].W3EVALDATE,
W4EVALDATE = NewRegEnvAdaptation.Data[i].W4EVALDATE,
W1EVALUATION = NewRegEnvAdaptation.Data[i].EVALUATION,
CREATEBY = NewRegEnvAdaptation.Data[i].CREATEBY,
ORG = orginfo.Data.OrgName,
});
MultiBindData(response.Data[0], doc);
//添加一个模板
doc.AddPartDocument();
}
}
//导出一个模板
//Util.DownloadFile(doc.SaveDoc());
if (!doc.IsDocNull())
{
Util.DownloadFile(doc.SaveMarkDoc(templateName));
}
}
}
#endregion
#region 新近住民环境介绍记录表
else if (templateName == "LTC_NEWEnvironmentRec")
{
using (WordDocument doc = new WordDocument())
{
doc.LoadModelDoc(templateName);
foreach (Resident r in list.Data)
{
BaseRequest <NewResideEntenvRecFilter> request = new BaseRequest <NewResideEntenvRecFilter>();
request.Data.FEENO = r.FeeNo;
var NewResideEntenvRec = reportManageService.QueryNewResideEntenvRec(request);
for (var i = 0; i < NewResideEntenvRec.Data.Count; i++)
{
//实例化一个模板
doc.NewPartDocument();
var orginfo = orgserver.GetOrg(NewResideEntenvRec.Data[i].ORGID);
DateTime t1 = DateTime.Now;
DateTime t2 = Convert.ToDateTime(NewResideEntenvRec.Data[i].BIRTHDATE);
var response = new BaseResponse <List <object> >(new List <object>());
response.Data.Add
(new
{
age = t1.Year - t2.Year,
ID = NewResideEntenvRec.Data[i].ID,
RESIDENGNO = NewResideEntenvRec.Data[i].RESIDENGNO,
BEDNO = NewResideEntenvRec.Data[i].BEDNO,
SEX = (NewResideEntenvRec.Data[i].SEX == "M") ? "男" : "女",
INDATE = NewResideEntenvRec.Data[i].INDATE,
RECORDDATE = NewResideEntenvRec.Data[i].RECORDDATE,
BIRTHDATE = NewResideEntenvRec.Data[i].BIRTHDATE,
FAMILYPARTICIPATION = (NewResideEntenvRec.Data[i].FAMILYPARTICIPATION == true) ? "是" : "否",
CONTRACTFLAG = ((NewResideEntenvRec.Data[i].CONTRACTFLAG == true) ? "01.契约内容说明" : "") + ((NewResideEntenvRec.Data[i].LIFEFLAG == true) ? "02.生活公约说明" : ""),
STAFF1 = NewResideEntenvRec.Data[i].STAFF1,
REGULARACTIVITY = ((NewResideEntenvRec.Data[i].REGULARACTIVITY == true) ? "01.定期活动说明" : "") + ((NewResideEntenvRec.Data[i].NOTREGULARACTIVITY == true) ? "02.不定期活动说明" : ""),
STAFF2 = NewResideEntenvRec.Data[i].STAFF2,
name = r.Name,
BELLFLAG = ((NewResideEntenvRec.Data[i].BELLFLAG == true) ? "01.紧急铃" : "") +
" " + ((NewResideEntenvRec.Data[i].LAMPFLAG == true) ? "02.床头灯" : "") +
" " + ((NewResideEntenvRec.Data[i].TVFLAG == true) ? "03.电视" : "") +
" " + ((NewResideEntenvRec.Data[i].LIGHTSWITCH == true) ? "04.电灯开关" : "") +
" " + ((NewResideEntenvRec.Data[i].ESCAPEDEVICE == true) ? "05.逃生设备" : "") +
" " + ((NewResideEntenvRec.Data[i].ENVIRONMENT == true) ? "06.公共环境" : "") +
" " + ((NewResideEntenvRec.Data[i].COMMUNITYFACILITIES == true) ? "07.社区设施" : "") +
" " + ((NewResideEntenvRec.Data[i].POSTOFFICE == true) ? "邮局" : "") +
" " + ((NewResideEntenvRec.Data[i].SCHOOL == true) ? "学校" : "") +
" " + ((NewResideEntenvRec.Data[i].BANK == true) ? "银行" : "") +
" " + ((NewResideEntenvRec.Data[i].STATION == true) ? "车站" : "") +
" " + ((NewResideEntenvRec.Data[i].PARK == true) ? "公园" : "") +
" " + ((NewResideEntenvRec.Data[i].TEMPLE == true) ? "寺庙" : "") +
" " + ((NewResideEntenvRec.Data[i].HOSPITAL == true) ? "医疗院所" : "") +
" " + ((NewResideEntenvRec.Data[i].OTHERFACILITIES == true) ? "其他" : ""),
CLEANLINESS = ((NewResideEntenvRec.Data[i].CLEANLINESS == true) ? "01.个人清洁" : "") +
" " + ((NewResideEntenvRec.Data[i].MEDICALCARE == true) ? "02.医保保健" : "") +
" " + ((NewResideEntenvRec.Data[i].MEALSERVICE == true) ? "03.膳食服务" : "") +
" " + ((NewResideEntenvRec.Data[i].WORKACTIVITIES == true) ? "04.社工拟定活动" : ""),
STAFF3 = NewResideEntenvRec.Data[i].STAFF3,
STAFF4 = NewResideEntenvRec.Data[i].STAFF4,
PERSONINCHARGE = ((NewResideEntenvRec.Data[i].PERSONINCHARGE == true) ? "01.负责人 " : "") +
" " + ((NewResideEntenvRec.Data[i].DIRECTOR == true) ? "02.主任" : "") +
" " + ((NewResideEntenvRec.Data[i].NURSE == true) ? "03.护士" : "") +
" " + ((NewResideEntenvRec.Data[i].NURSEAIDES == true) ? "04.照顾服务员" : "") +
" " + ((NewResideEntenvRec.Data[i].RESIDENT == true) ? "05.住民" : "") +
" " + ((NewResideEntenvRec.Data[i].DOCTOR == true) ? "06.医师" : "") +
" " + ((NewResideEntenvRec.Data[i].SOCIALWORKER == true) ? "07.社工" : "") +
" " + ((NewResideEntenvRec.Data[i].DIETITIAN == true) ? "08.营养师" : "") +
" " + ((NewResideEntenvRec.Data[i].OTHERPEOPLE == true) ? "09.其他人员" : ""),
STAFF5 = NewResideEntenvRec.Data[i].STAFF5,
RECORDBY = NewResideEntenvRec.Data[i].RECORDBY,
FEENO = NewResideEntenvRec.Data[i].FEENO,
REGNO = NewResideEntenvRec.Data[i].REGNO,
org = orginfo.Data.OrgName
});
MultiBindData(response.Data[0], doc);
//添加一个模板
doc.AddPartDocument();
}
}
//导出一个模板
//Util.DownloadFile(doc.SaveDoc());
if (!doc.IsDocNull())
{
Util.DownloadFile(doc.SaveMarkDoc(templateName));
}
}
}
#endregion
#region 个案基本资料
else if (templateName == "PA001")
{
using (WordDocument doc = new WordDocument())
{
doc.LoadModelDoc(templateName);
foreach (Resident r in list.Data)
{
doc.NewPartDocument();
BaseRequest BaseRequest = new BaseRequest();
BaseRequest <NewResideEntenvRecFilter> request = new BaseRequest <NewResideEntenvRecFilter>();
request.Data.REGNO = r.RegNo;
var Person = residentService.GetPersonExtend(r.RegNo.Value);
if (Person.Data.ImgUrl != null)
{
string mapPath = string.Format("{0}\\{1}", AppDomain.CurrentDomain.BaseDirectory, Person.Data.ImgUrl.Replace("/", @"\"));
if (System.IO.File.Exists(mapPath))
{
doc.InsertImage("photo", mapPath, 150, 200);
}
}
CodeFilter codeFilter = new CodeFilter();
codeFilter.ItemTypes = new string[] { "A00.030", "A00.032", "A00.035", "A00.001", "A00.007", "A00.008", "A00.011" };
var dict = (List <CodeValue>)dictManageService.QueryCode(codeFilter).Data;
CodeValue findItem;
Person.Data.Sex = dict.Find(it => it.ItemType == "A00.001" && it.ItemCode == Person.Data.Sex) != null?
dict.Find(it => it.ItemType == "A00.001" && it.ItemCode == Person.Data.Sex).ItemName : "";
Person.Data.Education = dict.Find(it => it.ItemType == "A00.007" && it.ItemCode == Person.Data.Education) != null?
dict.Find(it => it.ItemType == "A00.007" && it.ItemCode == Person.Data.Education).ItemName : "";
Person.Data.ReligionCode = dict.Find(it => it.ItemType == "A00.008" && it.ItemCode == Person.Data.ReligionCode) != null?
dict.Find(it => it.ItemType == "A00.008" && it.ItemCode == Person.Data.ReligionCode).ItemName : "";
Person.Data.MerryFlag = dict.Find(it => it.ItemType == "A00.011" && it.ItemCode == Person.Data.MerryFlag) != null?
dict.Find(it => it.ItemType == "A00.011" && it.ItemCode == Person.Data.MerryFlag).ItemName : "";
MultiBindData(Person.Data, doc);
DataTable dt = new DataTable();
dt.Columns.Add("c1");
dt.Columns.Add("c2");
dt.Columns.Add("c3");
dt.Columns.Add("c4");
dt.Columns.Add("c5");
dt.Columns.Add("c6");
if (Person.Data.RelationDtl != null)
{
foreach (var item in Person.Data.RelationDtl)
{
var dr = dt.NewRow();
dr["c1"] = item.Name;
findItem = dict.Find(it => it.ItemType == "A00.030" && it.ItemCode == item.Contrel);
dr["c2"] = findItem != null ? findItem.ItemName : "";
findItem = dict.Find(it => it.ItemType == "A00.032" && it.ItemCode == item.RelationType);
dr["c3"] = findItem != null ? findItem.ItemName : "";
dr["c4"] = item.Phone;
dr["c5"] = item.Address;
findItem = dict.Find(it => it.ItemType == "A00.035" && it.ItemCode == item.WorkCode);
dr["c6"] = findItem != null ? findItem.ItemName : "";
dt.Rows.Add(dr);
}
}
doc.MultiFillTable(0, dt, "", "", 32);
doc.AddPartDocument();
dt.Dispose();
}
//导出一个模板
Util.DownloadFile(doc.SaveDoc());
}
}
#endregion
return(View("ResidentExport"));
}
public IHttpActionResult Get(string orgID)
{
var response = organizationManageService.GetOrg(orgID);
return(Ok(response));
}
/// <summary>
/// P13社工定期处遇评估表
/// </summary>
/// <param name="doc"></param>
private void P13Operation(WordDocument doc)
{
int recordId = 4;
ISocialWorkerManageService reportManageService = IOCContainer.Instance.Resolve <ISocialWorkerManageService>();
IResidentManageService residentManageService = IOCContainer.Instance.Resolve <IResidentManageService>();
//ISocialWorkerManageService socialWorkerManageService = IOCContainer.Instance.Resolve<ISocialWorkerManageService>();
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
IDictManageService dictManageService = IOCContainer.Instance.Resolve <IDictManageService>();
var question = reportManageService.GetRegEvaluateById(recordId).Data;
if (question == null)
{
return;
}
if (!question.FeeNo.HasValue)
{
return;
}
var resident = residentManageService.GetResident(question.FeeNo.Value);
var person = residentManageService.GetPerson(resident.Data.RegNo ?? 0);
var emp = organizationManageService.GetEmployee(question.EvaluateBy);
CodeFilter request = new CodeFilter
{
ItemTypes = new string[]
{
"E00.014", "E00.005", "E00.008", "E00.009", "E00.015", "E00.016", "E00.017", "E00.018",
"E00.019", "E00.206", "E00.207", "E00.208", "E00.209", "E00.210", "E00.211"
}
};
var org = organizationManageService.GetOrg(resident.Data.OrgId);
var dict = (List <CodeValue>)dictManageService.QueryCode(request).Data;
doc.ReplaceText("MindState", dict.Find(it => it.ItemType == "E00.005" && it.ItemCode == question.MindState).ItemName);
doc.ReplaceText("ExpressionState", dict.Find(it => it.ItemType == "E00.008" && it.ItemCode == question.ExpressionState).ItemName);
doc.ReplaceText("LanguageState", dict.Find(it => it.ItemType == "E00.015" && it.ItemCode == question.LanguageState).ItemName);
doc.ReplaceText("NonexpressionState", dict.Find(it => it.ItemType == "E00.009" && it.ItemCode == question.NonexpressionState).ItemName);
doc.ReplaceText("EmotionState", dict.Find(it => it.ItemType == "E00.016" && it.ItemCode == question.EmotionState).ItemName);
doc.ReplaceText("Personality", dict.Find(it => it.ItemType == "E00.017" && it.ItemCode == question.Personality).ItemName);
doc.ReplaceText("Attention", dict.Find(it => it.ItemType == "E00.018" && it.ItemCode == question.Attention).ItemName);
doc.ReplaceText("Realisticsense", dict.Find(it => it.ItemType == "E00.019" && it.ItemCode == question.Realisticsense).ItemName);
doc.ReplaceText("SocialParticipation", dict.Find(it => it.ItemType == "E00.206" && it.ItemCode == question.SocialParticipation).ItemName);
doc.ReplaceText("SocialAttitude", dict.Find(it => it.ItemType == "E00.207" && it.ItemCode == question.SocialAttitude).ItemName);
doc.ReplaceText("SocialSkills", dict.Find(it => it.ItemType == "E00.208" && it.ItemCode == question.SocialSkills).ItemName);
doc.ReplaceText("CommSkills", dict.Find(it => it.ItemType == "E00.209" && it.ItemCode == question.CommSkills).ItemName);
doc.ReplaceText("ResponseSkills", dict.Find(it => it.ItemType == "E00.210" && it.ItemCode == question.ResponseSkills).ItemName);
doc.ReplaceText("FixissueSkills", dict.Find(it => it.ItemType == "E00.211" && it.ItemCode == question.FixissueSkills).ItemName);
doc.ReplaceText("BookDegree", dict.Find(it => it.ItemType == "E00.014" && it.ItemCode == question.BookDegree).ItemName);
doc.ReplaceText("EmpName", emp == null ? "" : emp.Data.EmpName);
doc.ReplaceText("Org", org == null ? "" : org.Data.OrgName);
doc.ReplaceText("Name", person == null ? "" : person.Data.Name);
if (person != null && person.Data.Age != null)
{
doc.ReplaceText("Age", person.Data.Age.ToString());
}
else
{
doc.ReplaceText("Age", "");
}
doc.ReplaceText("BedNo", resident.Data.BedNo);
doc.ReplaceText("Floor", resident.Data.Floor);
doc.ReplaceText("IllCard", question.IllCardName);
doc.ReplaceText("Service", question.ServiceName);
doc.ReplaceText("NextDate", question.NextEvalDate == null ? "" : ((DateTime)question.NextEvalDate).ToString("yyyy-MM-dd"));
BindData(question, doc);
}
/// <summary>
/// P15个案日常生活记录
/// </summary>
/// <param name="doc"></param>
private void P15Operation(WordDocument doc)
{
ISocialWorkerManageService socialWorkerService = IOCContainer.Instance.Resolve <ISocialWorkerManageService>();
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
IDictManageService dictManageService = IOCContainer.Instance.Resolve <IDictManageService>();
BaseRequest <LifeRecordFilter> lifeRecordFilter = new BaseRequest <LifeRecordFilter>();
lifeRecordFilter.CurrentPage = 1;
lifeRecordFilter.PageSize = 1000;
var org = organizationManageService.GetOrg(SecurityHelper.CurrentPrincipal.OrgId);
var response = socialWorkerService.QueryLifeRecord(lifeRecordFilter);
doc.ReplaceText("Org", org.Data.OrgName);
CodeFilter codeFilter = new CodeFilter();
codeFilter.ItemTypes = new string[] { "A00.400", "A00.401", "A00.402" };
var dict = (List <CodeValue>)dictManageService.QueryCode(codeFilter).Data;
DataTable dt = new DataTable();
dt.Columns.Add("c1");
dt.Columns.Add("c2");
dt.Columns.Add("c3");
dt.Columns.Add("c4");
dt.Columns.Add("c5");
dt.Columns.Add("c6");
dt.Columns.Add("c7");
dt.Columns.Add("c8");
dt.Columns.Add("c9");
dt.Columns.Add("c10");
dt.Columns.Add("c11");
dt.Columns.Add("c12");
if (response.Data != null)
{
CodeValue findItem;
foreach (var item in response.Data)
{
var dr = dt.NewRow();
dr["c1"] = item.Name;
dr["c2"] = item.FeeNo;
dr["c3"] = item.Floor + " " + item.RoomNo;
if (item.RecordDate.HasValue)
{
var data = item.RecordDate.Value;
dr["c4"] = string.Format("{0}/{1}/{2}", data.Year, data.Month, data.Day);
}
dr["c5"] = item.BodyTemp.HasValue ? item.BodyTemp.Value.ToString("N1") : "";
findItem = dict.Find(it => it.ItemType == "A00.400" && it.ItemCode == item.AmActivity);
dr["c10"] = findItem != null ? findItem.ItemName : "";
findItem = dict.Find(it => it.ItemType == "A00.401" && it.ItemCode == item.PmActivity);
dr["c11"] = findItem != null ? findItem.ItemName : "";
findItem = dict.Find(it => it.ItemType == "A00.403" && it.ItemCode == item.Comments);
dr["c12"] = findItem != null ? findItem.ItemName : "";
//dr["c1"] = item.Name;RecordByName
dt.Rows.Add(dr);
}
}
doc.FillTable(0, dt, "", "", 1);
dt.Dispose();
}
protected override void Operation(WordDocument doc)
{
ISocialWorkerManageService socialWorkerService = IOCContainer.Instance.Resolve <ISocialWorkerManageService>();
IOrganizationManageService organizationManageService = IOCContainer.Instance.Resolve <IOrganizationManageService>();
IDictManageService dictManageService = IOCContainer.Instance.Resolve <IDictManageService>();
IReportManageService reportManageService = IOCContainer.Instance.Resolve <IReportManageService>();
BaseRequest <LifeRecordFilter> lifeRecordFilter = new BaseRequest <LifeRecordFilter>();
lifeRecordFilter.CurrentPage = 1;
lifeRecordFilter.PageSize = 1000;
lifeRecordFilter.Data.FeeNo = ParamId;
lifeRecordFilter.Data.StartDate = StartDate;
lifeRecordFilter.Data.EndDate = EndDate.AddDays(1);
var org = organizationManageService.GetOrg(SecurityHelper.CurrentPrincipal.OrgId);
var response = socialWorkerService.QueryLifeRecord(lifeRecordFilter);
doc.ReplaceText("Org", org.Data.OrgName);
CodeFilter codeFilter = new CodeFilter();
codeFilter.ItemTypes = new string[] { "A00.400", "A00.401", "A00.402" };
var dict = (List <CodeValue>)dictManageService.QueryCode(codeFilter).Data;
DataTable dt = new DataTable();
dt.Columns.Add("c1");
dt.Columns.Add("c2");
dt.Columns.Add("c3");
dt.Columns.Add("c4");
dt.Columns.Add("c5");
dt.Columns.Add("c6");
dt.Columns.Add("c7");
dt.Columns.Add("c8");
dt.Columns.Add("c9");
dt.Columns.Add("c10");
dt.Columns.Add("c11");
dt.Columns.Add("c12");
if (response.Data != null)
{
if (response.Data.Count == 0)
{
response.Data.Add(new LifeRecordModel());
}
CodeValue findItem;
foreach (var item in response.Data)
{
var dr = dt.NewRow();
dr["c1"] = item.Name;
dr["c2"] = item.ResidentsNo;
//dr["c3"] = item.Floor + " " + item.RoomNo;
if (organizationManageService.GetOrgFloor(item.Floor).Data != null &&
organizationManageService.GetOrgRoom(item.RoomNo).Data != null)
{
dr["c3"] = organizationManageService.GetOrgFloor(item.Floor).Data.FloorName + " " + organizationManageService.GetOrgRoom(item.RoomNo).Data.RoomName;
}
if (item.RecordDate.HasValue)
{
var data = item.RecordDate.Value;
//dr["c4"] = string.Format("{0}/{1}/{2}", data.Year - 1911, data.Month, data.Day);
dr["c4"] = string.Format("{0}/{1}/{2}", data.Year, data.Month, data.Day);
}
dr["c5"] = item.BodyTemp.HasValue ? item.BodyTemp.Value.ToString("N1") : "";
dr["c10"] = string.IsNullOrEmpty(item.AmActivity) ? "" : item.AmActivity.ToString();
dr["c11"] = string.IsNullOrEmpty(item.PmActivity) ? "" : item.PmActivity.ToString();
findItem = dict.Find(it => it.ItemType == "A00.402" && it.ItemCode == item.Comments);
dr["c12"] = findItem != null ? findItem.ItemName : "";
//dr["c1"] = item.Name;RecordByName
dt.Rows.Add(dr);
}
}
doc.FillTable(0, dt, "", "", 1);
dt.Dispose();
}
