private void FillData()
{
using (SqlConnection cn = new SqlConnection(BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
//int currentPhysicianClientId = 0;
string currentPhysicianClientId = "0";
CytologyUnsatLetterItem item = new CytologyUnsatLetterItem();
CytologyUnsatLetterDetailItem detailItem = new CytologyUnsatLetterDetailItem();
while (dr.Read())
{
//int thisPhysicianClientId = BaseData.GetIntValue("PhysicianClientId", dr);
string thisPhysicianClientId = BaseData.GetStringValue("PhysicianClientId", dr);
if (thisPhysicianClientId != currentPhysicianClientId)
{
item = new CytologyUnsatLetterItem();
item.Fill(dr);
this.Add(item);
detailItem = new CytologyUnsatLetterDetailItem();
detailItem.Fill(dr);
item.DetailItems.Add(detailItem);
}
else
{
detailItem = new CytologyUnsatLetterDetailItem();
detailItem.Fill(dr);
item.DetailItems.Add(detailItem);
}
currentPhysicianClientId = thisPhysicianClientId;
}
}
}
}
private void FillData()
{
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
string currentPhysicianClientId = "0";
CytologyUnsatLetterItem item = new CytologyUnsatLetterItem();
CytologyUnsatLetterDetailItem detailItem = new CytologyUnsatLetterDetailItem();
while (dr.Read())
{
string thisPhysicianClientId = BaseData.GetStringValue("PhysicianClientId", dr);
if (thisPhysicianClientId != currentPhysicianClientId)
{
item = new CytologyUnsatLetterItem();
item.Fill(dr);
this.Add(item);
detailItem = new CytologyUnsatLetterDetailItem();
detailItem.Fill(dr);
item.DetailItems.Add(detailItem);
}
else
{
detailItem = new CytologyUnsatLetterDetailItem();
detailItem.Fill(dr);
item.DetailItems.Add(detailItem);
}
currentPhysicianClientId = thisPhysicianClientId;
}
}
}
}