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); } }