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