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); }