日期:2014-05-17 浏览次数:20499 次
StringBuilder sqlmax = new StringBuilder();
sqlmax.Append("select * from cbdl ");
sqlmax.Append(sqlcondition);
SqlParameter[] para2 = new SqlParameter[]{
new SqlParameter("@IDdateStart",da1.Value),
new SqlParameter("@IDdateEnd",da2.Value),
};
DataSet dsmax = helper.GetDataset(sqlmax.ToString(), para2);
resvalue.Append("<div class='tt_tr' tilte='最大值'>");
resvalue.Append("<div class='iddate'>" + "最大值" + "</div>");
//循环各列并赋值
if (dsmax != null && dsmax.Tables[0].Rows.Count > 0)
{
for (int i = 3; i < dsmax.Tables[0].Columns.Count; i++)
{
double Maxnum;
//DataRow row = dsmax.Tables[0].Rows[i];
if (dsmax.Tables[0].Rows[0][i] == DBNull.Value)
{