spread 签套循环改变颜色编号为颜色

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 签套循环改变颜色编号为颜色   

原文地址:https://www.cnblogs.com/zzh1236/p/1389183.html