public static void loadcongviec(PLCombobox input,long id)
{
string sql = "select * from cong_viec where loai_du_an="+id;
DataSet ds = HelpDB.getDatabase().LoadDataSet(sql);
input.DataSource = ds.Tables[0];
input.DisplayField = "NAME";
input.ValueField = "ID";
input._setSelectedID(-1);
input._init();
}
//PHUOCNC : Tại sao có 2 cái phân biệt thế này.
public static void ChonNhanVienRPT(PLCombobox input)
{
string sql = "select * from DM_NHAN_VIEN";
DataSet ds = HelpDB.getDatabase().LoadDataSet(sql);
input.DataSource = ds.Tables[0];
input.DisplayField = "NAME";
input.ValueField = "ID";
input._setSelectedID(-1);
input._init();
}
public static void ChonNhanVien(PLCombobox input)
{
string sql = "Select NV.* from DM_NHAN_VIEN NV inner join USER_CAT US on nv.id=us.employee_id";
DataSet ds = HelpDB.getDatabase().LoadDataSet(sql);
input.DataSource = ds.Tables[0];
input.DisplayField = "NAME";
input.ValueField = "ID";
input._setSelectedID(-1);
input._init();
}
public static void ChonLoaiDuAn(PLCombobox input)
{
string sql = "select * from DM_LOAI_DU_AN where VISIBLE_BIT='Y'";
DataSet ds = HelpDB.getDatabase().LoadDataSet(sql);
input.DataSource=ds.Tables[0];
input.DisplayField = "NAME";
input.ValueField = "ID";
input._setSelectedID(-1);
input._init();
}
public static void loadduan(PLCombobox input)
{
string sql = "select * from DU_AN";
DataSet ds = HelpDB.getDatabase().LoadDataSet(sql);
input.DataSource = ds.Tables[0];
input.DisplayField = "name";
input.ValueField = "ID";
input._setSelectedID(-1);
input._init();
}
public void InitKeNgangTang(PLCombobox combo, string control)
{
control = control.ToUpper();
string sql = string.Format(@"SELECT DISTINCT iif({0} is not null,{0},-2) ID, iif({0} is not null,{0}, '<Rỗng>') NAME
FROM CHUONG_TRINH_POST_MASTER WHERE IS_DELETE ='N' OR IS_DELETE IS NULL", control);
DataSet ds = HelpDB.getDatabase().LoadDataSet(sql);
combo.DataSource = ds.Tables[0];
combo.DisplayField = "NAME";
combo.ValueField = "ID";
combo._init();
combo.MainCtrl.Properties.SortColumnIndex = -1;
combo._setSelectedID(-1);
}
public static void InitCtrl(PLCombobox input, bool? isAdd)
{
string sql = string.Format(@"SELECT *
From {0}
where 1=1", TABLE_MAP);
var query = new QueryBuilder(sql);
if (isAdd == true)
query.addCondition("VISIBLE_BIT='Y'");
query.setAscOrderBy("lower(NAME)");
DataSet ds = HelpDB.getDatabase().LoadDataSet(query, TABLE_MAP);
input.DataSource = ds.Tables[0];
input.DisplayField = "NAME";
input.ValueField = "ID";
input._init();
input._setSelectedID(AppCtrl.GetDefaultKenhPhat());
}