private void initConfig()
{
lFet = new List <FEducationType>();
fet = new FEducationType();
fet.patient_education_type_description = "patient_education_type_description";;
fet.f_patient_education_type_id = "f_patient_education_type_id";
fet.active = "active";
fet.pkField = "f_patient_education_type_id";
fet.table = "f_patient_education_type";
}
private FEducationType setEduca(DataTable dt)
{
FEducationType dept1 = new FEducationType();
if (dt.Rows.Count > 0)
{
dept1.f_patient_education_type_id = dt.Rows[0][fet.f_patient_education_type_id].ToString();
dept1.patient_education_type_description = dt.Rows[0][fet.patient_education_type_description].ToString();
}
return(dept1);
}
public FEducationType selectByPk1(String copId)
{
FEducationType cop1 = new FEducationType();
DataTable dt = new DataTable();
String sql = "select fet.* " +
"From " + fet.table + " fet " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where fet." + fet.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setEduca(dt);
return(cop1);
}
public void getlFEducationType()
{
//lDept = new List<Position>();
lFet.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
FEducationType itm1 = new FEducationType();
itm1.f_patient_education_type_id = row[fet.f_patient_education_type_id].ToString();
itm1.patient_education_type_description = row[fet.patient_education_type_description].ToString();
lFet.Add(itm1);
}
}
