private void initConfig() { lSex = new List <FSex>(); sex = new FSex(); sex.f_sex_id = "f_sex_id"; sex.sex_description = "sex_description"; sex.active = "active"; sex.pkField = "f_sex_id"; sex.table = "f_sex"; }
private FSex setSex(DataTable dt) { FSex dept1 = new FSex(); if (dt.Rows.Count > 0) { dept1.f_sex_id = dt.Rows[0][sex.f_sex_id].ToString(); dept1.sex_description = dt.Rows[0][sex.sex_description].ToString(); } return(dept1); }
public FSex selectByPk1(String copId) { FSex cop1 = new FSex(); DataTable dt = new DataTable(); String sql = "select sex.* " + "From " + sex.table + " sex " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where sex." + sex.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setSex(dt); return(cop1); }
public void getlSex() { //lDept = new List<Position>(); lSex.Clear(); DataTable dt = new DataTable(); dt = selectAll(); foreach (DataRow row in dt.Rows) { FSex itm1 = new FSex(); itm1.f_sex_id = row[sex.f_sex_id].ToString(); itm1.sex_description = row[sex.sex_description].ToString(); lSex.Add(itm1); } }