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 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(); }