public static void InitChonDienDan(PLComboboxAdd PLDien_Dan,bool? IsAdd)
{
QueryBuilder query = null;
query = new QueryBuilder("SELECT * FROM NHOM_DIEN_DAN where ID_CHA<>0 " + (IsAdd == true ? " AND VISIBLE_BIT='Y'" : "") + " and 1=1");
DataSet ds = HelpDB.getDatabase().LoadDataSet(query);
PLDien_Dan._init(ds.Tables[0], "NAME", "ID");
}
public static void InitChonChuyenMuc(PLComboboxAdd PLChuyenMuc,long ID_Dien_Dan)
{
QueryBuilder query = null;
query = new QueryBuilder("SELECT * FROM CHUYEN_MUC where CHUYEN_MUC.VISIBLE_BIT='Y' AND ID_NHOM_DIEN_DAN=" + ID_Dien_Dan +" and 1=1" );
DataSet ds = HelpDB.getDatabase().LoadDataSet(query);
PLChuyenMuc._init(ds.Tables[0], "NAME", "ID");
}
public void InitCtrl(PLComboboxAdd Input, bool? IsAdd, bool ReadOnly)
{
DataSet ds = new DataSet();
DataTable dt = I();
ds.Tables.Add(dt);
Input.DataSource = ds.Tables[0];
Input.DisplayField = "NAME";
Input.IDField = "ID";
Input._init();
}
public void InitCtrl(PLComboboxAdd Input, bool? IsAdd)
{
QueryBuilder query = null;
if (IsAdd == true)
query = new QueryBuilder("SELECT * FROM DM_VAN_DE_GOP_Y where VISIBLE_BIT = 'Y' AND 1=1");
else
query = new QueryBuilder("SELECT * FROM DM_VAN_DE_GOP_Y where 1=1");
query.setAscOrderBy("NAME");
DataSet ds = HelpDB.getDatabase().LoadDataSet(query);
Input._init(ds.Tables[0], "NAME", "ID");
}
public static void ChonNhomTin(PLComboboxAdd Input, bool? IsAdd)
{
DataSet dsNTT;
//true:add, false:edit, null:xem
QueryBuilder query = new QueryBuilder("select ID,NAME from DM_NHOM_TIN_TUC WHERE 1=1");
if (IsAdd == true)
query.addCondition("VISIBLE_BIT='Y'");
query.setAscOrderBy("NAME");
dsNTT = TinTucPermission.I._LoadDataSetWithResGroupPermission(query, "ID");
Input._init(dsNTT.Tables[0], "NAME", "ID");
}
public void loadLoaiDA(PLComboboxAdd Input)
{
QueryBuilder query = null;
query = new QueryBuilder("SELECT * FROM DM_LOAI_DU_AN where 1=1");
query.setAscOrderBy("lower(ID)");
DataSet ds = DABase.getDatabase().LoadReadOnlyDataSet(query);
Input._init(ds.Tables[0], "NAME", "ID");
}
