コード例 #1
0
ファイル: FWMethodExec.cs プロジェクト: khanhdtn/my-fw-win
 public void KhoHangHoa()
 {
     FilterCase obj = new FilterCase(1, "1", "",
         new string[] { "MA_HANG", "TEN_HANG", "TEN_NHOM", "MA_PHIEU", "NGAY_PHAT_SINH", "NGUOI_PHAT_SINH", "DOI_TAC" },
         new string[] { "Mã hàng hóa", "Tên hàng hóa", "Tên nhóm hàng", "Số phiếu", "Ngày phát sinh", "Người phát sinh", "Đối tác" },
         "select * from F_HH1");
     PLFilter frm = new PLFilter(obj);
     ProtocolForm.ShowModalDialog(FrameworkParams.MainForm, frm);
 }
コード例 #2
0
ファイル: HelpControl.cs プロジェクト: khanhdtn/my-fw-win
        public static BarButtonItem addSaveQueryDialog(XtraForm form, BarManager barManager, PopupMenu menu, GridControl gridControl, string dataSetID, string masterQueryNoCondition, 
            params ProtocolVN.Framework.Win.SaveQueryDialog.HookAfterExecAdvQuery[] hooks)
        {
            BarButtonItem advancedSearch = HelpControl.addBarButtonItem(barManager, menu, "Tìm kiếm nâng cao");
            advancedSearch.Glyph = FWImageDic.FIND_IMAGE20;
            advancedSearch.ItemClick += delegate(object sender, ItemClickEventArgs e)
            {
                FilterCase obj = new FilterCase(FrameworkParams.currentUser.id, dataSetID, "Truy vấn mới", masterQueryNoCondition);
                SaveQueryDialog q = new SaveQueryDialog(obj, gridControl);
                if (hooks != null && hooks.Length == 1)
                {
                    q.hook = hooks[0];
                }
                q.Owner = form;
                q.Show();
            };

            return advancedSearch;
        }
コード例 #3
0
        public SaveQueryDialog(FilterCase _objFilter, GridControl gridControlQL)
        {
            InitializeComponent();

            this.ObjFilter = _objFilter;
            this.splitContainerControl1.PanelVisibility = SplitPanelVisibility.Panel1;
            if (gridControlQL.DataSource == null)
            {
                //String query = _objFilter.QUERYSOURCE;
                //if (!query.EndsWith("1=1"))
                //    query = query + " where 1=-1";
                //else
                //    query = query + " and 1=-1";

                string query = "select * from (" + _objFilter.QUERYSOURCE + ") SAVE_QUERY where 1 = -1";
                gridControlQL.DataSource = HelpDB.getDatabase().LoadDataSet(query).Tables[0];
            }
            this.gridControlQL = gridControlQL;
            filterControl1.SourceControl = gridControlQL;
            filterControl1.MenuManager = gridControlQL.MenuManager;
            InitOptions();
            FilterControlHelp.InitCombobox(cbbSqlFilter1, ObjFilter);
        }
コード例 #4
0
ファイル: TrialPLFilter.cs プロジェクト: khanhdtn/my-fw-win
        public PLFilter(FilterCase _objFilter)
        {
            this.ObjFilter = _objFilter;
            InitializeComponent();
            filterControl1.MenuManager = gridControl1.MenuManager;
            InitOptions();

            FilterControlHelp.InitCombobox(cbbSqlFilter1, ObjFilter);
            gridViewVN1.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
            try
            {
                string query = "";
                if (_objFilter.QUERYSOURCE.EndsWith("1=1"))
                {
                    query = _objFilter.QUERYSOURCE + " and 1=-1";
                }
                else
                {
                    query = _objFilter.QUERYSOURCE + " where 1=-1";
                }
                DataSet ds = DABase.getDatabase().LoadDataSet(query);
                gridControl1.DataSource = ds.Tables[0];
                for (int i = 0; i < ObjFilter.FILEDS.Length; i++)
                {
                    GridColumn column = gridViewVN1.Columns[ObjFilter.FILEDS[i]];
                    if(column!=null) column.Caption = ObjFilter.CAPTION[i];
                }

                for (int j = 0; j < gridViewVN1.Columns.Count; j++)
                {
                    if (ObjFilter.CheckFieldExist(gridViewVN1.Columns[j].FieldName) == false)
                        gridViewVN1.Columns[j].Visible = false;
                }

            }
            catch (Exception ex) { PLException.AddException(ex); }
        }
コード例 #5
0
        void itemSaveFilter_Click(object sender, EventArgs e)
        {
            try
            {
                XtraForm f = (XtraForm)this.GridControl.FindForm();
                if (f != null)
                {
                    FilterCase obj = new FilterCase(FrameworkParams.currentUser.id, this._GetPLGUI(), "Truy vấn mới", this._fullQueryData);
                    SaveQueryDialog q = new SaveQueryDialog(obj, this.GridControl);
                    q.Owner = f;
                    q.Show();
                }
            }
            catch
            {

            }
        }
コード例 #6
0
        /// <summary>Step 3: Xác định các control trong filter part và Khởi tạo control trong phần filter.
        /// Các control trong phần filter này là những control chỉ chọn
        /// </summary>
        public override void PLLoadFilterPart()
        {
            barButtonItemDelete.Glyph = FWImageDic.REMOVE_IMAGE20;
            barButtonItem4.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;//Xem trước
            filterControl1.SourceControl = gridControlMaster;
            filterControl1.MenuManager = gridControlMaster.MenuManager;
            //this.barCheckItemFilter.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
            //this.popupControlContainerFilter.Visible = true;
            gridViewMaster.OptionsBehavior.AutoExpandAllGroups = true;
            filterCase = new FilterCase(FrameworkParams.currentUser.id, CHUONG_TRINH.TABLE_NAME, "Chương trình", UpdateRow());
            filterControl1.SetDefaultColumn(filterControl1.FilterColumns[CHUONG_TRINH.TIET_MUC]);
            filterControl1.ShowDateTimeOperators = false;
            HelpGrid.SetReadOnlyHaveMemoCtrl(gridViewMaster, gridViewDetail, gridViewBienMuc);
            try
            {
                if (gridControlMaster.DataSource == null)
                {

                    string query = "select * from (" + filterCase.QUERYSOURCE + ") SAVE_QUERY where 1 = -1";
                    gridControlMaster.DataSource = HelpDB.getDatabase().LoadDataSet(query).Tables[0];
                }
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.NGAY_PHAT_DAU_TIEN]);
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.THOI_HAN_BAN_QUYEN_DISPLAY]);
            }
            catch
            {
            }
        }
コード例 #7
0
        /// <summary>Step 3: Xác định các control trong filter part và Khởi tạo control trong phần filter.
        /// Các control trong phần filter này là những control chỉ chọn
        /// </summary>
        public override void PLLoadFilterPart()
        {
            filterControl1.SourceControl = gridControlMaster;
            filterControl1.MenuManager = gridControlMaster.MenuManager;
            filterControl1.SetDefaultColumn(filterControl1.FilterColumns[CHUONG_TRINH.TIET_MUC]);
            filterCase = new FilterCase(FrameworkParams.currentUser.id, CHUONG_TRINH_POST_MASTER.TABLE_NAME, "Post/Master", UpdateRow());
            filterControl1.ShowDateTimeOperators = false;

             AppCtrl.InitAutocompleteBienMucName(TenTap);
            AppCtrl.InitAutocompleteNoiDung(NoiDung);
            DMPostMaster.InitCtrl(PostMaster, true);
            DMTietMuc.InitCtrl(TietMuc, true);
            AppCtrl.InitCtrlNhanVien(NguoiNhap, true);
            AppCtrl.InitCtrlPhongBan(PhongBan, true);
            DMHardDisks.InitCtrl(SoDKCBHD, true);
            DMLoaiBang.InitCtrl(LoaiLuuTru, true);
            gridViewMaster.OptionsBehavior.AutoExpandAllGroups = true;
            ngayNhap.Default = ProtocolVN.Framework.Win.Trial.SelectionTypes.FromDateToDate;
            HelpControlExt.AutoSetTabIndex(this.popupControlContainerFilter.Controls);
            HelpGrid.SetReadOnlyHaveMemoCtrl(gridViewMaster, gridViewMaster, gridViewDetail);
            barSubItemInNhan.Enabled = false;
            barSubItemInNhan.PaintStyle = BarItemPaintStyle.CaptionGlyph;
            barSubItemInNhan.Glyph = FrameworkParams.imageStore.GetImage1616("btnInNhanDID.png");
            barButtonItemInBeatcamTrong.Glyph = FrameworkParams.imageStore.GetImage1616("btnInNhanTrong.png");
            barButtonItemInBeatacamNgoai.Glyph = FrameworkParams.imageStore.GetImage1616("btnInNhanNgoai.png");
            try
            {
                if (gridControlMaster.DataSource == null)
                {

                    string query = "select * from (" + filterCase.QUERYSOURCE + ") SAVE_QUERY where 1 = -1";
                    gridControlMaster.DataSource = HelpDB.getDatabase().LoadDataSet(query).Tables[0];
                }
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.NGAY_PHAT_DAU_TIEN]);
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.THOI_HAN_BAN_QUYEN_DISPLAY]);
            }
            catch
            {
            }
        }
コード例 #8
0
 /// <summary>
 /// Hiển thị hộp thoại truy vấn nâng cao và cho phép lưu câu truy vấn
 /// </summary>
 public static void showSaveQueryDialog(XtraForm form, String dataSetID, String masterQueryNoCondition, GridControl gridCtrl, bool isModal)
 {
     FilterCase obj = new FilterCase(FrameworkParams.currentUser.id, dataSetID, "Save Query Dialog", masterQueryNoCondition);
     SaveQueryDialog q = new SaveQueryDialog(obj, gridCtrl);
     XtraForm owner = (form == null ? FrameworkParams.MainForm : form);
     q.Owner = owner;
     if (isModal)
     {
         q.ShowDialog();
     }
     else
     {
         q.Show();
     }
 }
コード例 #9
0
        /// <summary>Step 3: Xác định các control trong filter part và Khởi tạo control trong phần filter.
        /// Các control trong phần filter này là những control chỉ chọn
        /// </summary>
        public override void PLLoadFilterPart()
        {
            filterControl1.SourceControl = gridControlMaster;
            filterControl1.MenuManager = gridControlMaster.MenuManager;
            gridViewMaster.OptionsBehavior.AutoExpandAllGroups = true;
            filterCase = new FilterCase(FrameworkParams.currentUser.id, BIEN_MUC.TABLE_NAME, "Biên mục", UpdateRow());
            filterControl1.SetDefaultColumn(filterControl1.FilterColumns[BIEN_MUC.TIET_MUC]);
            //filterControl1.ShowDateTimeConstants = false;
            filterControl1.ShowDateTimeOperators = false;
            filterControl1.BeforeShowValueEditor += new ShowValueEditorEventHandler(filterControl1_BeforeShowValueEditor);
            try
            {
                if (gridControlMaster.DataSource == null)
                {

                    string query = "select * from (" + filterCase.QUERYSOURCE + ") SAVE_QUERY where 1 = -1";
                    gridControlMaster.DataSource = HelpDB.getDatabase().LoadDataSet(query).Tables[0];
                }
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.NGAY_PHAT_DAU_TIEN]);
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.THOI_HAN_BAN_QUYEN_DISPLAY]);
            }
            catch
            {
            }

            HelpGrid.SetReadOnlyHaveMemoCtrl(gridViewMaster);
            gridViewMaster.OptionsBehavior.AutoExpandAllGroups = true;
            ckcCotHienThi.ItemCheck += delegate(object sender, ItemCheckEventArgs e)
            {
                if (e.Index == 0)//chọn tất cả
                {
                    if (e.State == System.Windows.Forms.CheckState.Checked)
                    {
                        ckcCotHienThi.CheckAll();
                    }
                    else if (e.State == System.Windows.Forms.CheckState.Unchecked)
                    {
                        ckcCotHienThi.UnCheckAll();
                    }
                }
                else
                {
                    int checkedCount = ckcCotHienThi.CheckedIndices.Count;
                    if (e.State == System.Windows.Forms.CheckState.Checked)
                    {

                        if (checkedCount >= ckcCotHienThi.Items.Count - 1)
                            ckcCotHienThi.Items[0].CheckState = System.Windows.Forms.CheckState.Checked;
                        if (checkedCount > 0 && checkedCount < ckcCotHienThi.Items.Count - 1)
                            ckcCotHienThi.Items[0].CheckState = System.Windows.Forms.CheckState.Indeterminate;
                    }
                    else if (e.State == System.Windows.Forms.CheckState.Unchecked)
                    {
                        if (checkedCount == 0)
                            ckcCotHienThi.Items[0].CheckState = System.Windows.Forms.CheckState.Unchecked;
                        if (checkedCount > 0 && checkedCount < ckcCotHienThi.Items.Count)
                            ckcCotHienThi.Items[0].CheckState = System.Windows.Forms.CheckState.Indeterminate;
                    }

                }
            };
            if (gridViewMaster.Columns.Count > 0)
                ckcCotHienThi.Items.Add("CHON_TAT_CA", "(Chọn tất cả)");
            List<BandedGridColumn> defaultCol = new List<BandedGridColumn>
            {
                timkiem.CotNoiDung,timkiem.CotTietMuc,timkiem.CotSoTap,timkiem.CotTongTap,timkiem.CotSoLanPhat,timkiem.CotPhatLanDau
            };
            DataSet ds = new DataSet();
            DataTable tbl = new DataTable("COT_HIEN_THI");
            tbl.Columns.AddRange(new DataColumn[]{
                new DataColumn("ID",typeof(Int64)),
                new DataColumn("NAME")
            });
            ds.Tables.Add(tbl);
            for (int i = 0; i < gridViewMaster.Columns.Count;i++ )
            {
                BandedGridColumn col = gridViewMaster.Columns[i];
                System.Windows.Forms.CheckState state = System.Windows.Forms.CheckState.Unchecked;
                if (defaultCol.Contains(col))
                {
                    col.Visible = true;
                    state = System.Windows.Forms.CheckState.Checked;
                }
                ckcCotHienThi.Items.Add(col, col.Caption, state, true);
                tbl.Rows.Add((Int64)i, col.Caption);
            }
            TruongCap1._init(ds.Copy().Tables[0], "NAME", "ID", "", "NAME", "Tên", TruongCap1.Width);
            TruongCap2._init(ds.Copy().Tables[0], "NAME", "ID", "", "NAME", "Tên", TruongCap1.Width);
            TruongCap3._init(ds.Copy().Tables[0], "NAME", "ID", "", "NAME", "Tên", TruongCap1.Width);

            gridControlMaster.EmbeddedNavigator.TextStringFormat = "Tổng số biên mục: {1}";
        }
コード例 #10
0
        /// <summary>Step 3: Xác định các control trong filter part và Khởi tạo control trong phần filter.
        /// Các control trong phần filter này là những control chỉ chọn
        /// </summary>
        public override void PLLoadFilterPart()
        {
            barButtonItemDelete.Glyph = FWImageDic.REMOVE_IMAGE20;
            filterControl1.SourceControl = gridControlMaster;
            filterControl1.MenuManager = gridControlMaster.MenuManager;
            //this.barCheckItemFilter.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
            //this.popupControlContainerFilter.Visible = true;
            gridViewMaster.OptionsBehavior.AutoExpandAllGroups = true;
            filterCase = new FilterCase(FrameworkParams.currentUser.id, BIEN_MUC.TABLE_NAME, "Biên mục", UpdateRow());
            filterControl1.SetDefaultColumn(filterControl1.FilterColumns[BIEN_MUC.TIET_MUC]);
            //filterControl1.ShowDateTimeConstants = false;
            filterControl1.ShowDateTimeOperators = false;
            filterControl1.ShowFilterControlMenu += new DevExpress.XtraEditors.Filtering.ShowFilterControlMenuEventHandler(filterControl1_ShowFilterControlMenu);
            filterControl1.BeforeShowValueEditor += new ShowValueEditorEventHandler(filterControl1_BeforeShowValueEditor);
            try
            {
                if (gridControlMaster.DataSource == null)
                {

                    string query = "select * from (" + filterCase.QUERYSOURCE + ") SAVE_QUERY where 1 = -1";
                    gridControlMaster.DataSource = HelpDB.getDatabase().LoadDataSet(query).Tables[0];
                }
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.NGAY_PHAT_DAU_TIEN]);
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.THOI_HAN_BAN_QUYEN_DISPLAY]);
            }
            catch
            {
            }

            comboKenhPhat = new RepositoryItemLookUpEdit();
            comboKenhPhat.DataSource = HelpDB.getDBService().LoadDataSet(
                string.Format("SELECT * from {0}", DMDaiTruyenHinh.TABLE_MAP)).Tables[0];
            comboKenhPhat.DisplayMember = "NAME";
            comboKenhPhat.ValueMember = "ID";
        }
コード例 #11
0
        /// <summary>
        /// Lấy danh sách tất cả các câu truy vấn đã lưu
        /// </summary>
        /// <param name="Input"></param>
        public static void InitCombobox(PLCombobox Input, FilterCase filter)
        {
            DataSet ds = new DataSet();
            DatabaseFB db = DABase.getDatabase();
            System.Data.Common.DbCommand cmd = db.GetSQLStringCommand("select * from FW_QUERY_STORE where USERID = @USERID and DATASETID = @DATASETID");
            db.AddInParameter(cmd, "@USERID", DbType.Int64, filter.USERID);
            db.AddInParameter(cmd, "@DATASETID", DbType.String, filter.DATASETID);
            db.LoadDataSet(cmd, ds, "FW_QUERY_STORE");

            if (ds.Tables.Count == 0 || (ds.Tables.Count == 1 && ds.Tables[0] == null))
                PLException.AddException(new Exception("Thiếu bảng FW_QUERY_STORE"));

            //Tùy chọn nguồn dữ liệu
            Input.DataSource = ds.Tables[0];
            //Giá trị hiển thị khi chọn
            Input.DisplayField = "TITLE";
            //Giá trị nhận được khi lấy giá trị
            Input.ValueField = "ID";

            Input._init();
        }
コード例 #12
0
        /// <summary>Step 3: Xác định các control trong filter part và Khởi tạo control trong phần filter.
        /// Các control trong phần filter này là những control chỉ chọn
        /// </summary>
        public override void PLLoadFilterPart()
        {
            filterControl1.SourceControl = gridControlMaster;
            filterControl1.MenuManager = gridControlMaster.MenuManager;
            filterControl1.SetDefaultColumn(filterControl1.FilterColumns[CHUONG_TRINH.TIET_MUC]);
            filterCase = new FilterCase(FrameworkParams.currentUser.id, CHUONG_TRINH.TABLE_NAME, "Chương trình", UpdateRow());

            filterControl1.ShowDateTimeOperators = false;

            barButtonItemDelete.Glyph = FWImageDic.REMOVE_IMAGE20;
            barButtonItem4.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;//Xem trước

            TimeslotTu.Properties.HourFormat = DevExpress.XtraEditors.Controls.HourFormat.Hour24;
            TimeslotDen.Properties.HourFormat = DevExpress.XtraEditors.Controls.HourFormat.Hour24;

            TimeslotTu.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
            TimeslotDen.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
            TimeslotDen.EditValue = null;
            TimeslotTu.EditValue = null;
            AppCtrl.InitAutocompleteNoiDung(NoiDung);
             AppCtrl.InitAutocompleteTenGoc(TenGoc);
             AppCtrl.InitAutocompleteCategory(Category);
            DMBanQuyenThuoc.InitCtrl(BanQuyenThuoc, true);
            DMNuocSanXuat.InitCtrl(QuocGia, true);
            DMTietMuc.InitCtrl(TietMuc, true);
            DMDonViCungCap.InitCtrl(DonViCungCap, true);
            AppCtrl.InitCtrlPhongBan(PhongBan, true);
            DMLoaiBang.InitCtrl(LoaiLuuTru, true);
            DMHardDisks.InitCtrl(SoDKCBHD, true);
             AppCtrl.InitAutocompleteBienMucName(TenTap);
            gridViewMaster.OptionsBehavior.AutoExpandAllGroups = true;
            ngayNhap.Default = ProtocolVN.Framework.Win.Trial.SelectionTypes.None;
            HelpControlExt.AutoSetTabIndex(this.popupControlContainerFilter.Controls);
            HelpGrid.SetReadOnlyHaveMemoCtrl(gridViewMaster, gridViewDetail, gridViewBienMuc);
            PhongBan._SelectedIDs = new long[] {   FrameworkParams.LoginCompanyID};

            splitContainerControl2.PanelVisibility = SplitPanelVisibility.Panel1;
            barSubItemInNhan.Enabled = false;
            barSubItemInNhan.PaintStyle = BarItemPaintStyle.CaptionGlyph;
            barSubItemInNhan.Glyph = FrameworkParams.imageStore.GetImage1616("btnInNhanDID.png");
            barButtonItemInBeatcamTrong.Glyph = FrameworkParams.imageStore.GetImage1616("btnInNhanTrong.png");
            barButtonItemInBeatacamNgoai.Glyph = FrameworkParams.imageStore.GetImage1616("btnInNhanNgoai.png");
            //gridViewMaster.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
            //splitContainerControl1.Panel1.LookAndFeel.UseDefaultLookAndFeel = false;
            //splitContainerControl1.Panel1.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Flat;
            //splitContainerControl1.Panel1.Appearance.BorderColor = System.Drawing.Color.Red;
            //splitContainerControl1.Panel1.Appearance.Options.UseBorderColor = true;

            //splitContainerControl1.Panel1.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Simple;
            //splitContainerControl2.Panel1.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Flat;
            //splitContainerControl2.Panel1.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Flat;

            try
            {
                if (gridControlMaster.DataSource == null)
                {

                    string query = "select * from (" + filterCase.QUERYSOURCE + ") SAVE_QUERY where 1 = -1";
                    gridControlMaster.DataSource = HelpDB.getDatabase().LoadDataSet(query).Tables[0];
                }
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.NGAY_PHAT_DAU_TIEN]);
                filterControl1.FilterColumns.Remove(filterControl1.FilterColumns[BIEN_MUC.THOI_HAN_BAN_QUYEN_DISPLAY]);
            }
            catch
            {
            }
        }