日期:2014-05-16 浏览次数:20929 次
string sqlString = string.Format("SELECT * FROM T_HRMS_员工学历表 where 人员编码 = '{0}'", dr["人员编码"].ToString());
this.gridControl1.DataSource = DataBase.GetDataTable(sqlString);
this.gridView1.BestFitColumns();
sqlString = string.Format("SELECT * FROM T_HRMS_员工职称表 where 人员编码 = '{0}'", dr["人员编码"].ToString());
this.gridControl2.DataSource = DataBase.GetDataTable(sqlString);
this.gridView2.BestFitColumns();
sqlString = string.Format("SELECT * FROM T_HRMS_员工职务表 where 人员编码 = '{0}'", dr["人员编码"].ToString());
this.gridControl3.DataSource = DataBase.GetDataTable(sqlString);
this.gridView3.BestFitColumns();
sqlString = string.Format("SELECT * FROM T_HRMS_员工家庭表 where 人员编码 = '{0}'", dr["人员编码"].ToString());
this.gridControl4.DataSource = DataBase.GetDataTable(sqlString);
this.gridView4.BestFitColumns();
sqlString = string.Format("SELECT * FROM T_HRMS_员工奖励表 where 人员编码 = '{0}'", dr["人员编码"].ToString());
this.gridControl5.DataSource = DataBase.GetDataTable(sqlString);
this.gridView5.BestFitColumns();