Пример #1
0
        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";
        }
Пример #2
0
        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);
        }
Пример #3
0
        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);
        }
Пример #4
0
        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);
            }
        }