public static Test.ThinPrepPap.AcidWashList GetAcidWashList(DateTime startDate) { Test.ThinPrepPap.AcidWashList result = new Test.ThinPrepPap.AcidWashList(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select pso.MasterAccessionNo, po.ReportNo, po.OrderDate, po.Accepted, a.PLastName, a.PFirstName, a.PMiddleInitial from tblPanelOrder po join tblPanelSetOrder pso on po.ReportNo = pso.ReportNo " + " join tblAccessionOrder a on pso.MasterAccessionNo = a.MasterAccessionNo where po.PanelId = 39 and po.OrderDate >= @StartDate order by po.OrderDate Desc"; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = startDate; using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Test.ThinPrepPap.AcidWashListItem acidWashLIstItem = new Test.ThinPrepPap.AcidWashListItem(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(acidWashLIstItem, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(acidWashLIstItem); } } } return result; }
public static Test.ThinPrepPap.AcidWashList GetAcidWashList(DateTime startDate) { Test.ThinPrepPap.AcidWashList result = new Test.ThinPrepPap.AcidWashList(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select pso.MasterAccessionNo, po.ReportNo, po.OrderTime, po.Accepted, a.PLastName, a.PFirstName, a.PMiddleInitial, po.Comment, su.UserName " + "from tblPanelOrder po " + "join tblSystemUser su on po.OrderedById = su.UserId " + "join tblPanelSetOrder pso on po.ReportNo = pso.ReportNo " + "join tblAccessionOrder a on pso.MasterAccessionNo = a.MasterAccessionNo where po.PanelId = 39 and po.OrderTime >= @StartDate " + "order by po.OrderTime Desc;"; cmd.Parameters.AddWithValue("@StartDate", startDate); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { Test.ThinPrepPap.AcidWashListItem acidWashLIstItem = new Test.ThinPrepPap.AcidWashListItem(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(acidWashLIstItem, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(acidWashLIstItem); } } } result.SetState(); return(result); }