private void initConfig()
{
fdt = new FDocType();
lFreezeMedia = new List <FDocType>();
lMethod = new List <FDocType>();
lStage = new List <FDocType>();
lFetStage = new List <FDocType>();
lStageDay3 = new List <FDocType>();
lStageDau3Desc1 = new List <FDocType>();
lStageDay5 = new List <FDocType>();
lStageDau5Desc1 = new List <FDocType>();
lEggstiRt1 = new List <FDocType>();
lEggstiRt2 = new List <FDocType>();
lEggstiLt1 = new List <FDocType>();
lEggstiLt2 = new List <FDocType>();
lEggstiMedi = new List <FDocType>();
fdt.doc_type_id = "doc_type_id";
fdt.doc_type_code = "doc_type_code";
fdt.doc_type_name = "doc_type_name";
fdt.active = "active";
fdt.status_combo = "status_combo";
fdt.table = "f_doc_type";
fdt.pkField = "doc_type_id";
}
public FDocType selectByPk1(String copId)
{
FDocType cop1 = new FDocType();
DataTable dt = new DataTable();
String sql = "select fdt.* " +
"From " + fdt.table + " fpf " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where fdt." + fdt.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setFDocType(dt);
return(cop1);
}
public void getlEggStiMedication2()
{
//lDept = new List<Position>();
lEggstiMedi.Clear();
DataTable dt = new DataTable();
dt = selectEggStiMedication2();
foreach (DataRow row in dt.Rows)
{
FDocType itm1 = new FDocType();
itm1.doc_type_id = row[fdt.doc_type_id].ToString();
itm1.doc_type_name = row[fdt.doc_type_name].ToString();
lEggstiMedi.Add(itm1);
}
}
public void getlOPUStageDay5Desc1()
{
//lDept = new List<Position>();
lStageDau5Desc1.Clear();
DataTable dt = new DataTable();
dt = selectOPUStageDay5Desc1();
foreach (DataRow row in dt.Rows)
{
FDocType itm1 = new FDocType();
itm1.doc_type_id = row[fdt.doc_type_id].ToString();
itm1.doc_type_name = row[fdt.doc_type_name].ToString();
lStageDau5Desc1.Add(itm1);
}
}
public void getlFETFreezeStage()
{
//lDept = new List<Position>();
lFreezeMedia.Clear();
DataTable dt = new DataTable();
dt = selectFETFreezeMedia();
foreach (DataRow row in dt.Rows)
{
FDocType itm1 = new FDocType();
itm1.doc_type_id = row[fdt.doc_type_id].ToString();
itm1.doc_type_name = row[fdt.doc_type_name].ToString();
lFreezeMedia.Add(itm1);
}
}
public void getlFETStage()
{
//lDept = new List<Position>();
lFetStage.Clear();
DataTable dt = new DataTable();
dt = selectFETStage();
//FDocType itm = new FDocType();
//itm.doc_type_id = "";
//itm.doc_type_name = "";
//lStage.Add(itm);
foreach (DataRow row in dt.Rows)
{
FDocType itm1 = new FDocType();
itm1.doc_type_id = row[fdt.doc_type_id].ToString();
itm1.doc_type_name = row[fdt.doc_type_name].ToString();
lFetStage.Add(itm1);
}
}
public void getlOPUMethod()
{
//lDept = new List<Position>();
lMethod.Clear();
DataTable dt = new DataTable();
dt = selectOPUMethod();
//FDocType itm1 = new FDocType();
//itm1.doc_type_id = "";
//itm1.doc_type_name = "";
//lMethod.Add(itm1);
foreach (DataRow row in dt.Rows)
{
FDocType itm1 = new FDocType();
itm1.doc_type_id = row[fdt.doc_type_id].ToString();
itm1.doc_type_name = row[fdt.doc_type_name].ToString();
lMethod.Add(itm1);
}
}
private FDocType setFDocType(DataTable dt)
{
FDocType dept1 = new FDocType();
if (dt.Rows.Count > 0)
{
dept1.doc_type_id = dt.Rows[0][fdt.doc_type_id].ToString();
dept1.doc_type_code = dt.Rows[0][fdt.doc_type_code].ToString();
dept1.doc_type_name = dt.Rows[0][fdt.doc_type_name].ToString();
dept1.active = dt.Rows[0][fdt.active].ToString();
dept1.status_combo = dt.Rows[0][fdt.status_combo].ToString();
}
else
{
fdt.doc_type_id = "";
fdt.doc_type_code = "";
fdt.doc_type_name = "";
fdt.active = "";
fdt.status_combo = "";
}
return(dept1);
}
