private void initConfig()
{
lFbg = new List <FBloodGroup>();
fbg = new FBloodGroup();
fbg.f_patient_blood_group_id = "f_patient_blood_group_id";
fbg.patient_blood_group_description = "patient_blood_group_description";
fbg.active = "active";
fbg.pkField = "f_patient_blood_group_id";
fbg.table = "f_patient_blood_group";
}
private FBloodGroup setBloodGroup(DataTable dt)
{
FBloodGroup dept1 = new FBloodGroup();
if (dt.Rows.Count > 0)
{
dept1.f_patient_blood_group_id = dt.Rows[0][fbg.f_patient_blood_group_id].ToString();
dept1.patient_blood_group_description = dt.Rows[0][fbg.patient_blood_group_description].ToString();
}
return(dept1);
}
public FBloodGroup selectByPk1(String copId)
{
FBloodGroup cop1 = new FBloodGroup();
DataTable dt = new DataTable();
String sql = "select fbg.* " +
"From " + fbg.table + " fbg " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where fbg." + fbg.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setBloodGroup(dt);
return(cop1);
}
public void getlFBloodGroup()
{
//lDept = new List<Position>();
lFbg.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
FBloodGroup itm1 = new FBloodGroup();
itm1.f_patient_blood_group_id = row[fbg.f_patient_blood_group_id].ToString();
itm1.patient_blood_group_description = row[fbg.patient_blood_group_description].ToString();
lFbg.Add(itm1);
}
}
