public static void InitListDuAn(DevExpress.Web.ASPxGridLookup.ASPxGridLookup gridLookup, bool? IsAdd)
{
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colMa = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colMa.Caption = "Mã dự án";
colMa.FieldName = DA_DU_AN.cl_MA_DU_AN;
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colTenDA = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colTenDA.Caption = "Tên dự án";
colTenDA.FieldName = DA_DU_AN.cl_TEN_DU_AN;
DevExpress.Web.ASPxGridView.GridViewDataDateColumn colNgayTao = new DevExpress.Web.ASPxGridView.GridViewDataDateColumn();
colNgayTao.Caption = "Ngày tạo";
colNgayTao.FieldName = DA_DU_AN.cl_NGAY_TAO;
DevExpress.Web.ASPxGridView.GridViewDataDateColumn colNgayBD = new DevExpress.Web.ASPxGridView.GridViewDataDateColumn();
colNgayBD.Caption = "Ngày bắt đầu";
colNgayBD.FieldName = DA_DU_AN.cl_NGAY_BAT_DAU;
DevExpress.Web.ASPxGridView.GridViewDataDateColumn colNgayKT = new DevExpress.Web.ASPxGridView.GridViewDataDateColumn();
colNgayKT.Caption = "Ngày kết thúc";
colNgayKT.FieldName = DA_DU_AN.cl_NGAY_KET_THUC;
DataTable dtTrangThai = DA_DM_TRANG_THAI_DU_AN.GetTableAll();
DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn colTrangThai = new DevExpress.Web.ASPxGridView.GridViewDataComboBoxColumn();
colTrangThai.PropertiesComboBox.DataSource = dtTrangThai;
colTrangThai.PropertiesComboBox.ValueField = DA_DM_TRANG_THAI_DU_AN.cl_ID;
colTrangThai.PropertiesComboBox.TextField = DA_DM_TRANG_THAI_DU_AN.cl_NAME;
colTrangThai.Caption = "Trạng thái dự án";
colTrangThai.FieldName = DA_DU_AN.cl_TRANG_THAI_ID;
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colID = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colID.Caption = "ID";
colID.FieldName = DA_DU_AN.cl_ID;
colID.Visible = false;
gridLookup.Columns.Clear();
gridLookup.Columns.Add(colMa);
gridLookup.Columns.Add(colTenDA);
gridLookup.Columns.Add(colNgayTao);
gridLookup.Columns.Add(colNgayBD);
gridLookup.Columns.Add(colNgayKT);
gridLookup.Columns.Add(colTrangThai);
gridLookup.Columns.Add(colID);
// gridLookup.GridView.Settings.ShowFilterRow = true;
DataTable dtDA= DA_DU_AN.GetTableAll();
AddEmptyRow(dtDA, DA_DU_AN.cl_ID);
gridLookup.DataSource = dtDA;
gridLookup.KeyFieldName = DA_DU_AN.cl_ID;
gridLookup.DataBind();
}
public static void InitListPhieuYeuCau(DevExpress.Web.ASPxGridLookup.ASPxGridLookup gridLookup, bool? IsAdd)
{
//DevExpress.Web.ASPxGridView.GridViewDataTextColumn colMa = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
//colMa.Caption = "Mã dự án";
//colMa.FieldName = DA_DU_AN.cl_MA_DU_AN;
DataTable dtYC = YC_YEU_CAU.GetTable(@"SELECT yc.YEU_CAU_ID,
yc.TIEU_DE,yc.NGAY_YEU_CAU,
lyc.TEN_LOAI_YC,
ttyc.[NAME] TRANG_THAI_YC,
nd.[NAME] NGUOI_YC,yc.NGUOI_YEU_CAU
FROM YC_YEU_CAU yc
LEFT JOIN ND_THONG_TIN_ND nd ON nd.ID=yc.NGUOI_YEU_CAU
LEFT JOIN YC_DM_LOAI_YEU_CAU lyc ON lyc.ID=yc.LOAI_YC_ID
LEFT JOIN YC_DM_TRANG_THAI_YEU_CAU ttyc ON ttyc.ID = yc.TRANG_THAI_ID", YC_YEU_CAU.sTableName
);
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colTieuDe = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colTieuDe.Caption = "Phiếu yêu cầu";
colTieuDe.FieldName = YC_YEU_CAU.cl_TIEU_DE;
DevExpress.Web.ASPxGridView.GridViewDataDateColumn colNgayYC = new DevExpress.Web.ASPxGridView.GridViewDataDateColumn();
colNgayYC.Caption = "Ngày yêu cầu";
colNgayYC.FieldName = YC_YEU_CAU.cl_NGAY_YEU_CAU;
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colNguoiYC = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colNguoiYC.Caption = "Người yêu cầu";
colNguoiYC.FieldName = "NGUOI_YC";
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colLoaiYC = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colLoaiYC.Caption = "Loại yêu cầu";
colLoaiYC.FieldName = "TEN_LOAI_YC";
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colTTYC = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colLoaiYC.Caption = "Trạng thái";
colLoaiYC.FieldName = "TRANG_THAI_YC";
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colID = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colID.Caption = "ID";
colID.FieldName = YC_YEU_CAU.cl_YEU_CAU_ID;
colID.Visible = false;
DevExpress.Web.ASPxGridView.GridViewDataTextColumn colNguoiYCID = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
colNguoiYCID.Caption = "NGUOI_YC_ID";
colNguoiYCID.FieldName = YC_YEU_CAU.cl_NGUOI_YEU_CAU;
colNguoiYCID.Visible = false;
gridLookup.Columns.Clear();
gridLookup.Columns.Add(colTieuDe);
gridLookup.Columns.Add(colNgayYC);
gridLookup.Columns.Add(colNguoiYC);
gridLookup.Columns.Add(colLoaiYC);
gridLookup.Columns.Add(colTTYC);
gridLookup.Columns.Add(colID);
gridLookup.Columns.Add(colNguoiYCID);
// gridLookup.GridView.Settings.ShowFilterRow = true;
AddEmptyRow(dtYC, YC_YEU_CAU.cl_YEU_CAU_ID);
gridLookup.DataSource = dtYC;
gridLookup.KeyFieldName = YC_YEU_CAU.cl_YEU_CAU_ID;
gridLookup.DataBind();
}
public static void InitGridLookup(DevExpress.Web.ASPxGridLookup.ASPxGridLookup gridLookup,
DataTable dtSource, string ValueField, string DisplayField, string[] Columns, string[] Caption)
{
AddEmptyRow(dtSource, ValueField);
if (Columns != null && Columns.Length > 0)
{
if (Caption == null) Caption = new string[0];
for (int i = 0; i < Columns.Length; i++)
{
DevExpress.Web.ASPxGridView.GridViewDataTextColumn col = new DevExpress.Web.ASPxGridView.GridViewDataTextColumn();
col.Caption = i < Caption.Length ? Caption[i] : Columns[i];
col.FieldName = Columns[i];
gridLookup.Columns.Add(col);
}
}
gridLookup.KeyFieldName = ValueField;
gridLookup.DataSource = dtSource;
gridLookup.DataBind();
}
