private FPrefix setPrefix(DataTable dt)
{
FPrefix dept1 = new FPrefix();
if (dt.Rows.Count > 0)
{
dept1.f_patient_prefix_id = dt.Rows[0][frac.f_patient_race_id].ToString();
dept1.patient_prefix_description = dt.Rows[0][frac.patient_race_description].ToString();
}
return(dept1);
}
private FPrefix setMarriageStatus(DataTable dt)
{
FPrefix dept1 = new FPrefix();
if (dt.Rows.Count > 0)
{
dept1.f_patient_prefix_id = dt.Rows[0][fms.f_patient_marriage_status_id].ToString();
dept1.patient_prefix_description = dt.Rows[0][fms.patient_marriage_status_description].ToString();
}
return(dept1);
}
public FPrefix selectByPk1(String copId)
{
FPrefix cop1 = new FPrefix();
DataTable dt = new DataTable();
String sql = "select fpn.* " +
"From " + frac.table + " fpn " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where fpn." + frac.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setPrefix(dt);
return(cop1);
}
private void initConfig()
{
lFpf = new List <FPrefix>();
fpf = new FPrefix();
fpf.active = "active";
fpf.f_prefix_id = "f_prefix_id";
fpf.f_sex_id = "f_sex_id";
fpf.prefix_description = "prefix_description";
fpf.active = "active";
fpf.pkField = "f_prefix_id";
fpf.table = "f_prefix";
}
public void getlFPrefix()
{
//lDept = new List<Position>();
lFpf.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
FPrefix itm1 = new FPrefix();
itm1.f_prefix_id = row[fpf.f_prefix_id].ToString();
itm1.prefix_description = row[fpf.prefix_description].ToString();
lFpf.Add(itm1);
}
}