//填充DataGird
private void tableFill()
{
string strSql="select c.id,a.Content item ,b.Content from Assess_Item b left join (select * from Assess_Item where Grade=0) a on Left(RTrim(LTrim(b.ItemCode)),2)=a.ItemCode left join Assess_Relation c on c.ItemId=b.id where b.Grade=1 and c.PostTypeId=" + this.identityNo (this.peopleList .SelectedValue .Trim ()) + " order by a.Content";
this.DataGridEx1 .DataSource =this.ExecuteReader (strSql,"ASOM");
this.DataGridEx1 .DataBind ();
}
//合并单元格
private void DataGridEx1_PreRender(object sender, System.EventArgs e)
{
int rowCount=this.DataGridEx1 .Items .Count ;
int itemCount=0;
int itemStart=0;
for (int i=0;i<rowCount ;i++)
{
if(i==0)
itemStart=0;
else
{
string str1=this.DataGridEx1 .Items [i].Cells [1].Text .Trim ();
string str2=this.DataGridEx1 .Items [itemStart].Cells [1].Text .Trim ();
if(this.DataGridEx1 .Items [i].Cells [1].Text .Trim ()==this.DataGridEx1 .Items [itemStart].Cells [1].Text .Trim ())
{
itemCount+=1;
this.DataGridEx1 .Items[i].Cells [1].Visible =false;
}
else
{
this.DataGridEx1 .Items [itemStart].Cells [1].RowSpan =itemCount+1;
itemCount=0;
itemStart=i;
}
}
}
//如果取出的数据为空,不合并单元格
if(rowCount>0)
this.DataGridEx1 .Items [itemStart].Cells [1].RowSpan =itemCount+1;
}