private void initConfig() { lFet = new List <FEducationType>(); fet = new FEducationType(); fet.patient_education_type_description = "patient_education_type_description";; fet.f_patient_education_type_id = "f_patient_education_type_id"; fet.active = "active"; fet.pkField = "f_patient_education_type_id"; fet.table = "f_patient_education_type"; }
private FEducationType setEduca(DataTable dt) { FEducationType dept1 = new FEducationType(); if (dt.Rows.Count > 0) { dept1.f_patient_education_type_id = dt.Rows[0][fet.f_patient_education_type_id].ToString(); dept1.patient_education_type_description = dt.Rows[0][fet.patient_education_type_description].ToString(); } return(dept1); }
public FEducationType selectByPk1(String copId) { FEducationType cop1 = new FEducationType(); DataTable dt = new DataTable(); String sql = "select fet.* " + "From " + fet.table + " fet " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where fet." + fet.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setEduca(dt); return(cop1); }
public void getlFEducationType() { //lDept = new List<Position>(); lFet.Clear(); DataTable dt = new DataTable(); dt = selectAll(); foreach (DataRow row in dt.Rows) { FEducationType itm1 = new FEducationType(); itm1.f_patient_education_type_id = row[fet.f_patient_education_type_id].ToString(); itm1.patient_education_type_description = row[fet.patient_education_type_description].ToString(); lFet.Add(itm1); } }