OracleDataReader reader1 = bll.select4(cppf, ysbh,qyno);
if(reader1.Read())
{
int i = 0;
do
{
this.fpSpread1.Sheets[0].RowCount = this.fpSpread1.Sheets[0].RowCount + 1;
this.fpSpread1.ActiveSheet.SetValue(i, 0, reader1["snzcbh"].ToString());
this.fpSpread1.ActiveSheet.SetValue(i, 1, reader1["zcmc_ch"].ToString());
this.fpSpread1.ActiveSheet.SetValue(i, 2, reader1["zcpf"].ToString());
this.fpSpread1.ActiveSheet.SetValue(i, 3, reader1["zcgg"].ToString());
this.fpSpread1.ActiveSheet.SetValue(i, 4, reader1["zcdwbh"].ToString());
string zcysbh = reader1["zcysbh"].ToString();
OracleDataReader reader2 = bll.select3(zcysbh);
if (reader2.Read())
{
this.fpSpread1.ActiveSheet.SetValue(i, 5, reader2["zsmc"].ToString());
}
reader2.Close();
i++;
}
while (reader1.Read());
reader1.Close();
spread 签套循环改变颜色编号为颜色