private void loadData()
{
DataSet dsAll = new DataSet();
DataTable masterDt = getTempDataTable("row", 34);
DataTable detailDt = getTempDataTable("row", 11);
List <Project> projList = ConnectionManager.Context.table("Project").select("*").getList <Project>(new Project());
foreach (Project proj in projList)
{
#region 生成数据
if (proj != null && !string.IsNullOrEmpty(proj.ProjectID))
{
//项目类型
string catalogType = ConnectionManager.Context.table("Catalog").where ("CatalogID='" + proj.CatalogID + "'").select("CatalogType").getValue <string>("未知");
//课题列表
List <Subject> subList = ConnectionManager.Context.table("Subject").where ("CatalogID = '" + proj.CatalogID + "' and ProjectID = '" + proj.ProjectID + "'").select("*").getList <Subject>(new Subject());
foreach (Subject sub in subList)
{
#region 生成主表数据
List <object> cells = new List <object>();
//项目编号
cells.Add(proj.ProjectNumber);
//项目领域 2
cells.Add(proj.Domains);
//项目名称 3
cells.Add(proj.ProjectName);
//总经费(万元)
cells.Add(proj.TotalMoney);
//周期
cells.Add(proj.TotalTime);
//第一年度经费+第二年度经费+第三年度经费+第四年度经费+第五年度经费
for (int kkk = 1; kkk <= 5; kkk++)
{
cells.Add(ConnectionManager.Context.table("Dicts").where ("CatalogID='" + proj.CatalogID + "' and DictName='Year" + kkk + "'").select("DictValue").getValue <string>(string.Empty));
}
//密级
cells.Add(proj.SecretLevel);
//起止时间
List <DateTime> dtList = new List <DateTime>();
Noear.Weed.DataList dlMoneySendList = ConnectionManager.Context.table("MoneySends").where ("CatalogID='" + proj.CatalogID + "'").orderBy("WillTime").select("WillTime").getDataList();
if (dlMoneySendList.getRowCount() >= 1)
{
foreach (DataItem diiii in dlMoneySendList.getRows())
{
DateTime willTime = diiii.get("WillTime") != null?DateTime.Parse(diiii.get("WillTime").ToString()) : DateTime.Now;
dtList.Add(willTime);
}
}
if (dtList.Count >= 2)
{
cells.Add(dtList[0].ToString("yyyy年MM月dd日") + "~" + dtList[dtList.Count - 1].ToString("yyyy年MM月dd日"));
}
else if (dtList.Count == 1)
{
cells.Add(dtList[0].ToString("yyyy年MM月dd日") + "~");
}
else
{
cells.Add("");
}
//计划批次 13
cells.Add(proj.TaskNumber);
//项目负责人
Person masterPerson = ConnectionManager.Context.table("Person").where ("CatalogID = '" + proj.CatalogID + "' and SubjectID = '' and IsProjectMaster = 'true'").select("*").getItem <Person>(new Person());
if (masterPerson != null && masterPerson.PersonID != null && masterPerson.PersonID.Length >= 1)
{
cells.Add(masterPerson.PersonName);
}
else
{
cells.Add(string.Empty);
}
//项目牵头单位
cells.Add(proj.DutyUnit);
//项目负责人职务/职称+项目负责人座机+项目负责人手机
if (masterPerson != null && masterPerson.PersonID != null && masterPerson.PersonID.Length >= 1)
{
cells.Add(masterPerson.PersonJob);
cells.Add(masterPerson.Telephone);
cells.Add(masterPerson.Mobilephone);
}
else
{
cells.Add(string.Empty);
cells.Add(string.Empty);
cells.Add(string.Empty);
}
//牵头单位所属大单位
cells.Add(proj.DutyUnitOrg);
//牵头单位地址
cells.Add(proj.DutyUnitAddress);
//课题名称
cells.Add(sub.SubjectName);
//课题负责单位
cells.Add(sub.DutyUnit);
//课题负责单位所属大单位
cells.Add(sub.DutyUnitOrg);
//课题负责单位通信地址
cells.Add(sub.DutyUnitAddress);
//课题总经费
if (catalogType != null && catalogType == "合同书")
{
//合同书总经费
//cells.Add(ConnectionManager.Context.table("Dicts").where("CatalogID = '" + proj.CatalogID + "' and SubjectID ='" + sub.SubjectID + "' and DictType='SubjectMoney,SubjectMoneyInfo' and DictName = 'Money1'").select("DictValue").getValue<string>(""));
cells.Add(sub.TotalMoney);
}
else
{
//建议书总经费
cells.Add(sub.TotalMoney);
}
//选题评议
cells.Add(proj.OKQuestionMemo);
//立项审核
cells.Add(proj.OKCheckA);
//立项复议
cells.Add(proj.OKCheckB);
//合同审查等级
cells.Add(proj.ContactCheckLevelA);
//合同审核等级
cells.Add(proj.ContactCheckLevelB);
//备注
cells.Add(proj.Memo);
//课题ID
cells.Add(proj.ProjectID + "***" + sub.SubjectID);
cells.Add(proj.DutyNormalUnit);
cells.Add(sub.SecretLevel);
masterDt.Rows.Add(cells.ToArray());
#endregion
#region 生成从表数据
if (sub != null && !string.IsNullOrEmpty(sub.SubjectID))
{
List <Person> perList = ConnectionManager.Context.table("Person").where ("CatalogID = '" + proj.CatalogID + "' and SubjectID = '" + sub.SubjectID + "'").select("*").getList <Person>(new Person());
foreach (Person p in perList)
{
List <object> cellSubjectObj = new List <object>();
//姓名
cellSubjectObj.Add(p.PersonName);
//身份证
cellSubjectObj.Add(p.PersonIDCard);
//性别
cellSubjectObj.Add(p.PersonSex);
//工作单位
cellSubjectObj.Add(p.WorkUnit);
//职务/职称
cellSubjectObj.Add(p.PersonJob);
//专业
cellSubjectObj.Add(p.PersonSpecialty);
//座机
cellSubjectObj.Add(p.Telephone);
//手机
cellSubjectObj.Add(p.Mobilephone);
//任务分工
cellSubjectObj.Add(p.TaskContent);
//项目中职务
//string roleStr = "未知";
//if (p.IsProjectMaster == "true")
//{
// roleStr = "项目负责人兼" + sub.SubjectName + "的" + p.JobInProject;
//}
//else
//{
// roleStr = sub.SubjectName + "的" + p.JobInProject;
//}
//cells.Add(roleStr);
string roleStr = "未知";
if (p.IsProjectMaster == "true")
{
roleStr = "项目负责人兼" + p.JobInProject;
}
else
{
roleStr = p.JobInProject;
}
cellSubjectObj.Add(roleStr);
//课题ID
cellSubjectObj.Add(proj.ProjectID + "***" + sub.SubjectID);
detailDt.Rows.Add(cellSubjectObj.ToArray());
}
}
#endregion
}
}
#endregion
}
#region 生成从属关系数据
masterDt.TableName = "MainView";
detailDt.TableName = "SubjectView";
dsAll.Tables.Add(masterDt);
dsAll.Tables.Add(detailDt);
DataColumn keyColumn = dsAll.Tables[masterDt.TableName].Columns["row32"]; //主键
DataColumn foreignColumn = dsAll.Tables[detailDt.TableName].Columns["row11"]; //外键
//
//对于主从表，层次名至关重要，关系名必须和从表的层次名一致,
//否则从表显示的是从表的所有字段，而不是所设计的显示字段
//
dsAll.Relations.Add(detailDt.TableName, keyColumn, foreignColumn, false); //从表的层次名
gcData.DataSource = dsAll.Tables[masterDt.TableName];
#endregion
}