DataRow[] drsporary = dtoutcar.Select(" BeginTime>='" + strdtm + "' and BeginTime<='"
+ Convert.ToDateTime(strdtm).AddDays(1).ToString("yyyy-MM-dd") + "' and CarOutTypeId in ('" + TempTaskTypeId1 + "','" + TempTaskTypeId2 + "','" + TempTaskTypeId3 + "' ) ");
解决方法:
DataRow[] drsporary = dtoutcar.Select(" BeginTime>='" + strdtm + "' and BeginTime<='"
+ Convert.ToDateTime(strdtm).AddDays(1).ToString("yyyy-MM-dd") + "' and CarOutTypeId IN(CONVERT('" + TempTaskTypeId1 + "', 'System.Guid'),CONVERT('" + TempTaskTypeId2 + "', 'System.Guid'),CONVERT('" + TempTaskTypeId3 + "', 'System.Guid') ) ");