62,039
社区成员
发帖
与我相关
我的任务
分享
protected void gvMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)//判断行类型
{
string gvId = gvMain.DataKeys[e.Row.RowIndex].Value.ToString();//得到部门id
tb_CadreInfo ev = CadreInfoManager.GetCoadreById(gvId);
e.Row.Cells[0].Text = ev.VcCadreName;
}
}
public static tb_CadreInfo GetCoadreById(string cadreId)
{
string sql = "SELECT * FROM tb_CadreInfo WHERE vcDepartID = @vcDepartID";
SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@vcDepartID", cadreId));
if (reader.Read())
{
tb_CadreInfo cNAme = new tb_CadreInfo();
cNAme.VcDepartID = (string)reader["vcDepartID"];
cNAme.VcCadreName = (string)reader["vcCadreName"];
cNAme.Td_DepartQueue = (int)reader["td_DepartQueue"];
reader.Close();
return cNAme;
}
else
{
reader.Close();
return null;
}
}