滞纳金问题

lynmerry11 2009-03-30 11:36:43

SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connString"]);
string query = "select 应缴日期,总计,业主房号 from 业主缴费表 where 缴费日期=''";//有值
//select 应缴日期,总计,业主房号 from 业主缴费表 where 缴费日期=null无值显示
SqlCommand myCommand = new SqlCommand(query, myConnection);
myConnection .Open ();
SqlDataReader myReader = myCommand.ExecuteReader();
DateTime d3=DateTime .Now ;//当前日期
float f=0.0F;
ArrayList al = new ArrayList();//存储应缴滞纳金额
ArrayList al1 = new ArrayList();//存储对应的业主房号
while (myReader .Read ())

{
for(int i=0;i<myReader.FieldCount ;i++)
{
DateTime d= myReader.GetDateTime (0);//应缴日期
float f1 = float .Parse (myReader.GetValue(1).ToString ());
string c = myReader.GetValue(2).ToString ();
//以下为若超过应缴日期15天则要交滞纳金
if(d.Month ==d3.Month &d.Date.AddDays (15).Day <=d3.Day )
{
al.Add ((d3 .Day -d.Day )*0.15*f1);
al1.Add (c);
}
if (d.Month <d3.Month &d3.Day+30-d.Day >=15)
{
al.Add ((d3 .Day-30-d.Day -15)*0.15*f1);
al1.Add ( c);
}
}
}
myReader .Close ();
//以下修改业主缴费表对应业主房号添加应缴滞纳金额
for (int i = 0; i < al.Count; i++)
{
string update = "update 业主缴费表 set 应缴滞纳金='"+al[i]+"' where 业主房号='"+al1[i]+"'";

SqlCommand sql = new SqlCommand(update, myConnection);
sql.ExecuteNonQuery();

}
myConnection.Close();

以下为找出应缴滞纳金的业主信息显示到dataGrid2上
string queryStr1 = "select * from 业主缴费表 where 应缴滞纳金!=NULL";
SqlDataAdapter myDataAdapter = new SqlDataAdapter(queryStr1, myConnection);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "check");
DataGrid2.DataSource = myDataSet.Tables["check"].DefaultView;
DataGrid2.DataBind();
问题是：显示不出来应缴滞纳金的业主信息

...全文