コード例 #1
0
        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();
        }
コード例 #2
0
        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);
        }