private void FormatOpinion()
{
IList <CustomIndicatorOpinion> cioEnts = CustomIndicatorOpinion.FindAllByProperty("CreateTime", CustomIndicatorOpinion.Prop_CustomIndicatorId, ciEnt.Id);
string temp = "<table style='font-size:12px'><tr style='font-weight:bold'><td width='12px'></td><td width='160px'>审批意见</td><td width='50px'>审批人</td><td width='70px'>审批时间</td></tr>";
for (int i = 0; i < cioEnts.Count; i++)
{
temp += "<tr><td>" + (i + 1).ToString() + "</td><td>" + cioEnts[i].Opinion + "</td><td>" + cioEnts[i].CreateName + "</td><td>" + cioEnts[0].CreateTime.Value.ToShortDateString() + "</td></tr>";
}
ciEnt.Opinion = temp + "</table>";
ciEnt.DoUpdate();
}
private void DoSelect()
{
sql = @"select A.Id, A.PersonSecondIndicatorName,A.Weight, A.ToolTip,A.SelfRemark,A.PersonFirstIndicatorId,
B.PersonFirstIndicatorName, B.Weight as FirstWeight,B.IndicatorType
from BJKY_Examine..PersonSecondIndicator as A
left join BJKY_Examine..PersonFirstIndicator as B on A.PersonFirstIndicatorId=B.Id
where B.CustomIndicatorId='{0}' order by B.IndicatorType desc,B.SortIndex asc";
sql = string.Format(sql, id);
PageState.Add("DataList", DataHelper.QueryDictList(sql));
SetFormData(ciEnt);
PageState.Add("Entity", ciEnt);
//加载审批意见表 因为有可能多次审批
IList <CustomIndicatorOpinion> cioEnts = CustomIndicatorOpinion.FindAllByProperty(CustomIndicatorOpinion.Prop_CustomIndicatorId, id);
PageState.Add("DataList1", cioEnts);
}
