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"));
}
protected override void Operation(Infrastructure.Word.WordDocument doc)
{
int recordId = (int)ParamId;
doc.ReplaceText("Org", GetOrgName(SecurityHelper.CurrentPrincipal.OrgId));
IResidentManageService ResidentManageService = IOCContainer.Instance.Resolve <IResidentManageService>();
IDictManageService dictManageService = IOCContainer.Instance.Resolve <IDictManageService>();
var Person = ResidentManageService.GetPersonExtend(recordId);
if (Person == null)
{
return;
}
if (Person.Data.ImgUrl != null)
{
string mapPath = string.Format("{0}\\{1}", AppDomain.CurrentDomain.BaseDirectory, Person.Data.ImgUrl.Replace("/", @"\"));
if (File.Exists(mapPath))
{
doc.InsertImage("photo", mapPath, 150, 200);
}
else
{
doc.ReplaceText("photo", "");
}
}
else
{
doc.ReplaceText("photo", "");
}
if (Person.Data.Genogram != null)
{
string mapPath = string.Format("{0}\\{1}", AppDomain.CurrentDomain.BaseDirectory, Person.Data.Genogram.Replace("/", @"\"));
if (File.Exists(mapPath))
{
doc.InsertImage("Genogram", mapPath, 150, 200);
}
else
{
doc.ReplaceText("Genogram", "");
}
}
else
{
doc.ReplaceText("photo", "");
}
CodeFilter codeFilter = new CodeFilter();
codeFilter.ItemTypes = new string[] { "A00.030", "A00.032", "A00.035", "A00.001", "A00.007", "A00.008"
, "A00.011", "A00.002", "A00.016", "A00.020", "A00.021", "A00.022", "A00.038", "A00.043", "A00.031" };
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.servicetype = dict.Find(it => it.ItemType == "A00.002" && it.ItemCode == Person.Data.servicetype) != null?
dict.Find(it => it.ItemType == "A00.002" && it.ItemCode == Person.Data.servicetype).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 : "";
Person.Data.EATHABITS = dict.Find(it => it.ItemType == "A00.038" && it.ItemCode == Person.Data.EATHABITS) != null?
dict.Find(it => it.ItemType == "A00.038" && it.ItemCode == Person.Data.EATHABITS).ItemName : "";
Person.Data.SOURCETYPE = dict.Find(it => it.ItemType == "A00.016" && it.ItemCode == Person.Data.SOURCETYPE) != null?
dict.Find(it => it.ItemType == "A00.016" && it.ItemCode == Person.Data.SOURCETYPE).ItemName : "";
Person.Data.ECONOMYFLAG = dict.Find(it => it.ItemType == "A00.020" && it.ItemCode == Person.Data.ECONOMYFLAG) != null?
dict.Find(it => it.ItemType == "A00.020" && it.ItemCode == Person.Data.ECONOMYFLAG).ItemName : "";
Person.Data.CASETYPE = dict.Find(it => it.ItemType == "A00.021" && it.ItemCode == Person.Data.CASETYPE) != null?
dict.Find(it => it.ItemType == "A00.021" && it.ItemCode == Person.Data.CASETYPE).ItemName : "";
Person.Data.DISABDEGREE = dict.Find(it => it.ItemType == "A00.022" && it.ItemCode == Person.Data.DISABDEGREE) != null?
dict.Find(it => it.ItemType == "A00.022" && it.ItemCode == Person.Data.DISABDEGREE).ItemName : "";
Person.Data.SubsidyUnit = dict.Find(it => it.ItemType == "A00.043" && it.ItemCode == Person.Data.SubsidyUnit) != null?
dict.Find(it => it.ItemType == "A00.043" && it.ItemCode == Person.Data.SubsidyUnit).ItemName : "";
Person.Data.CAddress1 = Person.Data.City2 + "" + Person.Data.Address2 + "" + Person.Data.Address2dtl;
Person.Data.CAddress2 = Person.Data.City1 + "" + Person.Data.Address1 + "" + Person.Data.Address1dtl;
Person.Data.EffectiveTime = Person.Data.BOOKISSUEDATE + "-" + Person.Data.BOOKEXPDATE;
Person.Data.Living = Person.Data.FloorName + "/" + Person.Data.RoomName;
Person.Data.ISIdentificationText = Person.Data.ISREEVAL == null ? "是" : (!Person.Data.ISREEVAL.Value ? "是" : "否");
string[] str = new string[] { "第一类 神经系统构造及精神、心智功能", "第二类 眼，耳及相关机构与感官功能及疼痛",
"第三类 涉及声音与言语构造及其功能", "第四类 循环、造血、免疫与呼吸系统构造及其功能",
"第五类 消化、新陈代谢与内分泌系统相关构造及其功能", "第六类 泌尿与生殖系统相关构造及其功能",
"第七类 神经、肌肉、骨骼之移动相关构造及其功能", "第八类 皮肤与相关构造及其功能" };
var Barrier_2 = "";
if (Person.Data.DISABILITYCATE1 != null)
{
Barrier_2 += Person.Data.DISABILITYCATE1.Value? str[0]:"";
}
if (Person.Data.DISABILITYCATE2 != null)
{
Barrier_2 += "," + (Person.Data.DISABILITYCATE2.Value ? str[1] : "");
}
if (Person.Data.DISABILITYCATE3 != null)
{
Barrier_2 += "," + (Person.Data.DISABILITYCATE3.Value ? str[2] : "");
}
if (Person.Data.DISABILITYCATE4 != null)
{
Barrier_2 += "," + (Person.Data.DISABILITYCATE4.Value ? str[3] : "");
}
if (Person.Data.DISABILITYCATE5 != null)
{
Barrier_2 += "," + (Person.Data.DISABILITYCATE5.Value ? str[4] : "");
}
if (Person.Data.DISABILITYCATE6 != null)
{
Barrier_2 += "," + (Person.Data.DISABILITYCATE6.Value ? str[5] : "");
}
if (Person.Data.DISABILITYCATE7 != null)
{
Barrier_2 += "," + (Person.Data.DISABILITYCATE7.Value ? str[6] : "");
}
if (Person.Data.DISABILITYCATE8 != null)
{
Barrier_2 += "," + (Person.Data.DISABILITYCATE8.Value ? str[7] : "");
}
Person.Data.Barrier_2 = Barrier_2;
BindData(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");
dt.Columns.Add("c7");
if (Person.Data.RelationDtl != null)
{
if (Person.Data.RelationDtl.Count > 0)
{
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.031" && it.ItemCode == item.Kinship);
dr["c3"] = findItem != null ? findItem.ItemName : "";
findItem = dict.Find(it => it.ItemType == "A00.001" && it.ItemCode == item.Sex);
dr["c4"] = findItem != null ? findItem.ItemName : "";
dr["c5"] = item.Phone;
dr["c6"] = item.Address2;
findItem = dict.Find(it => it.ItemType == "A00.035" && it.ItemCode == item.WorkCode);
dr["c7"] = findItem != null ? findItem.ItemName : "";
dt.Rows.Add(dr);
}
}
else
{
var dr = dt.NewRow();
dr["c1"] = "";
dr["c2"] = "";
dr["c3"] = "";
dr["c4"] = "";
dr["c5"] = "";
dr["c6"] = "";
dt.Rows.Add(dr);
}
}
else
{
var dr = dt.NewRow();
dr["c1"] = "";
dr["c2"] = "";
dr["c3"] = "";
dr["c4"] = "";
dr["c5"] = "";
dr["c6"] = "";
dt.Rows.Add(dr);
}
doc.FillTable(0, dt, "", "", 23);
dt.Dispose();
}
protected override void Operation(Infrastructure.Word.WordDocument doc)
{
int recordId = (int)ParamId;
doc.ReplaceText("Org", GetOrgName(SecurityHelper.CurrentPrincipal.OrgId));
IResidentManageService ResidentManageService = IOCContainer.Instance.Resolve <IResidentManageService>();
IDictManageService dictManageService = IOCContainer.Instance.Resolve <IDictManageService>();
var Person = ResidentManageService.GetPersonExtend(recordId);
if (Person == null)
{
return;
}
if (Person.Data.ImgUrl != null)
{
string mapPath = string.Format("{0}\\{1}", AppDomain.CurrentDomain.BaseDirectory, Person.Data.ImgUrl.Replace("/", @"\"));
if (File.Exists(mapPath))
{
doc.InsertImage("photo", mapPath, 150, 200);
}
else
{
doc.ReplaceText("photo", "");
}
}
else
{
doc.ReplaceText("photo", "");
}
CodeFilter codeFilter = new CodeFilter();
codeFilter.ItemTypes = new string[] { "A00.030", "A00.032", "A00.035", "A00.001", "A00.007", "A00.008", "A00.011", "A00.002" };
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.servicetype = dict.Find(it => it.ItemType == "A00.002" && it.ItemCode == Person.Data.servicetype) != null?
dict.Find(it => it.ItemType == "A00.002" && it.ItemCode == Person.Data.servicetype).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 : "";
Person.Data.CAddress1 = Person.Data.City2 + "" + Person.Data.Address2 + "" + Person.Data.Address2dtl;
Person.Data.CAddress2 = Person.Data.City1 + "" + Person.Data.Address1 + "" + Person.Data.Address1dtl;
BindData(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)
{
if (Person.Data.RelationDtl.Count > 0)
{
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);
}
}
else
{
var dr = dt.NewRow();
dr["c1"] = "";
dr["c2"] = "";
dr["c3"] = "";
dr["c4"] = "";
dr["c5"] = "";
dr["c6"] = "";
dt.Rows.Add(dr);
}
}
else
{
var dr = dt.NewRow();
dr["c1"] = "";
dr["c2"] = "";
dr["c3"] = "";
dr["c4"] = "";
dr["c5"] = "";
dr["c6"] = "";
dt.Rows.Add(dr);
}
doc.FillTable(0, dt, "", "", 32);
dt.Dispose();
}