public static string SearchDailyWork(string Date)
{
DatePre dp = new DatePre(Date);
DataSet a = new DataSet();
try
{
string strSql = "select id,StationName,Content from WeekRule where [WeekTime]='" + dp.WeekTime + "' UNION select id,StationName,Content from MonthRule where [MonthTime]=" + dp.MouthTime + " UNION select id,StationName,Content from YearRule where [MonthTime]=" + dp.Mouth + " and [Day]=" + dp.Day;//暂不考虑时间
a = AccessHelper.ExecuteDataset(CommandType.Text, strSql);
//update DefectRecord set [Time]=#2015/2/13 18:00:00#
}
catch (Exception e)
{
throw new Exception(e.Message);
}
string re = ConvertJson.ToJson(a);
return(re);
}