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