public FamilyRoles()
{
DataTable dt = null;
using (FirebirdDBHelper db = new FirebirdDBHelper(util.strDBConn))
{
try
{
dt = db.GetDataTableSP("GET_FAMILY_ROLE");
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
}
FamilyRole fr = new FamilyRole()
{
Fr_Idx = "0"
, Fr_Name = util.LoadProjectResource("TEXT_CB_FIRSTFIELD", "COMMONRES", "").ToString()
, Fr_Sort = "0"
, Fr_Use = "1"
};
_roles.Add(fr);
foreach (DataRow myRow in dt.Rows)
{
fr = new FamilyRole()
{
Fr_Idx = myRow["o_fr_idx"].ToString()
,
Fr_Name = myRow["o_fr_name"].ToString()
,
Fr_Sort = myRow["o_fr_sort"].ToString()
,
Fr_Use = myRow["o_fr_use"].ToString()
};
_roles.Add(fr);
}
}
public FamilyRoles()
{
DataTable dt = null;
using (FirebirdDBHelper db = new FirebirdDBHelper(util.strDBConn))
{
try
{
dt = db.GetDataTableSP("GET_FAMILY_ROLE");
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
}
FamilyRole fr = new FamilyRole() {
Fr_Idx = "0"
, Fr_Name = util.LoadProjectResource("TEXT_CB_FIRSTFIELD", "COMMONRES", "").ToString()
, Fr_Sort = "0"
, Fr_Use = "1"
};
_roles.Add(fr);
foreach (DataRow myRow in dt.Rows)
{
fr = new FamilyRole()
{
Fr_Idx = myRow["o_fr_idx"].ToString()
,
Fr_Name = myRow["o_fr_name"].ToString()
,
Fr_Sort = myRow["o_fr_sort"].ToString()
,
Fr_Use = myRow["o_fr_use"].ToString()
};
_roles.Add(fr);
}
}
