if (conn.State.ToString() == "Closed") conn.Open();
strSQL = "SELECT TOP (1) * FROM 工程检查记录 WHERE (gcName = '" + gcName + "') ORDER BY id DESC";
SqlDataAdapter daa = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
daa.Fill(ds);
strSQL = "UPDATE a工程工地_属性 SET 下次检查时间 = DATEADD(d, 15, CAST('" + ds.Tables[0].Rows[0]["rq"].ToString() + "' AS smalldatetime)) WHERE (序号 = " + ds.Tables[0].Rows[0]["gcName"].ToString() + ")";
SqlCommand comm2 = new SqlCommand(strSQL, conn);
comm2.ExecuteNonQuery();
comm2.Dispose();
ds.Clear();
daa.Dispose();
if (conn.State.ToString() == "Open") conn.Close();
}
catch (Exception ex)
{
Response.Write("<script language='javascript'>alert('保存出错!');</script>");
}
finally
{
if (conn.State.ToString() == "Open") conn.Close();