예제 #1
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmInventoryAdjustmentsQuery_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateIADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateIADateEnd.DateTime   = nowDate.Date;

                lookUpAdjustmentsRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
                lookUpAdjustmentsRepertoryNo.ItemIndex             = 0;
                lookUpReqDep.Properties.DataSource               = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                           = 0;
                lookUpPrepared.Properties.DataSource             = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue                         = SystemInfo.user.EmpName;
                searchAdjustmentsProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                searchAdjustmentsProjectNo.Text                  = "全部";

                repLookUpInRepertoryNo.DataSource        = commonDAO.QueryRepertoryInfo(false);
                repSearchAdjustmentsProjectNo.DataSource = commonDAO.QueryProjectList(false);
                repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);

                gridBottomIA.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #2
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmPrReqList_Overplus_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateReqDateEnd.DateTime   = nowDate.Date;

                lookUpReqDep.Properties.DataSource             = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                         = 0;
                lookUpPurCategory.Properties.DataSource        = commonDAO.QueryPurCategory(true);
                lookUpPurCategory.ItemIndex                    = 0;
                searchLookUpProjectNo.Properties.DataSource    = commonDAO.QueryProjectList(true);
                searchLookUpProjectNo.Text                     = "全部";
                searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                searchLookUpCodeFileName.Text                  = "全部";
                comboBoxReqState.SelectedIndex                 = 0;

                repLookUpReqDep.DataSource      = commonDAO.QueryDepartment(false);
                repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
                repLookUpProjectNo.DataSource   = commonDAO.QueryProjectList(false);

                gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex);
            }
        }
예제 #3
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmPrReqApply_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> {
                    checkAll
                });

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateReqDateEnd.DateTime   = nowDate.Date;
                checkReqDate.Checked      = false;

                lookUpReqDep.Properties.DataSource          = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                      = 0;
                lookUpPurCategory.Properties.DataSource     = commonDAO.QueryPurCategory(true);
                lookUpPurCategory.ItemIndex                 = 0;
                lookUpApplicant.Properties.DataSource       = commonDAO.QueryUserInfo(true);
                lookUpApplicant.ItemIndex                   = 0;
                searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                searchLookUpProjectNo.Text                  = "全部";

                repLookUpReqDep.DataSource      = commonDAO.QueryDepartment(false);
                repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
                repSearchProjectNo.DataSource   = commonDAO.QueryProjectList(false);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex);
            }
        }
예제 #4
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmInventoryAdjustments_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
                    btnListAdd, checkAll
                });

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateIADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateIADateEnd.DateTime   = nowDate.Date;

                DataTable repertoryTable         = commonDAO.QueryRepertoryInfo(false);
                DataTable repertoryAddAllTable   = commonDAO.QueryRepertoryInfo(true);
                DataTable projectListAddAllTable = commonDAO.QueryProjectList(true);

                lookUpAdjustmentsRepertoryNo.Properties.DataSource = repertoryAddAllTable;
                lookUpAdjustmentsRepertoryNo.ItemIndex             = 0;
                lookUpReqDep.Properties.DataSource               = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                           = 0;
                lookUpPrepared.Properties.DataSource             = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue                         = SystemInfo.user.EmpName;
                searchAdjustmentsProjectNo.Properties.DataSource = projectListAddAllTable;
                searchAdjustmentsProjectNo.Text                  = "全部";

                repLookUpInRepertoryNo.DataSource        = repertoryTable;
                repSearchAdjustmentsProjectNo.DataSource = commonDAO.QueryProjectList(false);
                repLookUpReqDep.DataSource       = commonDAO.QueryDepartment(false);
                repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
                repSearchOutShelfNo.DataSource   = commonDAO.QueryShelfInfo(false);

                lookUpRepertoryNo.Properties.DataSource     = repertoryAddAllTable;
                lookUpRepertoryNo.ItemIndex                 = 0;
                searchLookUpProjectNo.Properties.DataSource = projectListAddAllTable;
                searchLookUpProjectNo.Text = "全部";
                searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                searchLookUpCodeFileName.Text = "全部";

                repLookUpRepertoryNo.DataSource = repertoryTable;

                if (textCommon.Text == "")
                {
                    iaDAO.QueryInventoryAdjustmentsHead(dataSet_IA.Tables[0], "", "", "", "", "", "", "", true);
                    iaDAO.QueryInventoryAdjustmentsList(dataSet_IA.Tables[1], "", true);
                }
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #5
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmSalesOrder_History_Load(object sender, EventArgs e)
        {
            try
            {
                DataTable bussBaseTable = commonDAO.QueryBussinessBaseInfo(false);

                searchProjectName.Properties.DataSource      = commonDAO.QueryProjectList(false);
                searchBussinessBaseNo.Properties.DataSource  = bussBaseTable;
                lookUpCollectionTypeNo.Properties.DataSource = commonDAO.QueryCollectionType(false);
                lookUpCurrencyCate.Properties.DataSource     = commonDAO.QueryCurrencyCate(false);
                lookUpProjectLeader.Properties.DataSource    = commonDAO.QueryUserInfo(false);

                DateTime nowDate = BaseSQL.GetServerDateTime();

                repSearchBussinessBaseNo.DataSource = bussBaseTable;

                dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateSalesOrderDateEnd.DateTime   = nowDate.Date;

                searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
                searchLookUpBussinessBaseNo.Text = "全部";

                repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable;

                Set_ButtonEditGrid_State(true);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
예제 #6
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmSalesOrderQuery_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateSalesOrderDateEnd.DateTime   = nowDate.Date;

                searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
                searchLookUpBussinessBaseNo.Text      = "全部";
                searchProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                searchProjectNo.Text = "全部";
                lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue             = SystemInfo.user.EmpName;

                repSearchBussinessBaseNo.DataSource  = commonDAO.QueryBussinessBaseInfo(false);
                repLookUpCollectionTypeNo.DataSource = commonDAO.QueryCollectionType(false);

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
                gridBottomOrderHead.pageRowCount = 5;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
예제 #7
0
        /// <summary>
        /// 窗体加载事件错误
        /// </summary>
        private void FrmOrderQuery_Load(object sender, EventArgs e)
        {
            try
            {
                DataTable departmentTable_t = commonDAO.QueryDepartment(true);
                DataTable bussInfoTable_t   = commonDAO.QueryBussinessBaseInfo(true);
                DataTable purCateTable_t    = commonDAO.QueryPurCategory(true);

                lookUpReqDep.Properties.DataSource = departmentTable_t;
                lookUpReqDep.ItemIndex             = 0;
                searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t;
                searchLookUpBussinessBaseNo.Text        = "全部";
                lookUpPurCategory.Properties.DataSource = purCateTable_t;
                lookUpPurCategory.ItemIndex             = 0;

                ControlCommonInit ctlInit = new ControlCommonInit();
                ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator);
                searchLookUpCreator.EditValue = SystemInfo.user.AutoId;
                ctlInit.ComboBoxEdit_OrderState_Submit(comboBoxReqState);
                comboBoxReqState.SelectedIndex = 0;

                //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
                //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
                //repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
                repLookUpReqDep.DataSource          = departmentTable_t;
                repSearchBussinessBaseNo.DataSource = bussInfoTable_t;
                repLookUpPurCategory.DataSource     = purCateTable_t;
                repSearchProjectNo.DataSource       = commonDAO.QueryProjectList(false);
                repLookUpApprovalType.DataSource    = commonDAO.QueryApprovalType(false);
                repLookUpPayTypeNo.DataSource       = commonDAO.QueryPayType(false);
                repLookUpCreator.DataSource         = searchLookUpCreator.Properties.DataSource;

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateOrderDateEnd.DateTime   = nowDate.Date;
                datePlanDateBegin.DateTime  = nowDate.Date;
                datePlanDateEnd.DateTime    = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays);
                checkPlanDate.Checked       = false;

                if (SystemInfo.DisableProjectNo)
                {
                    colProjectNo.Visible = false;
                    colStnNo.Visible     = false;
                }

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #8
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmOrderList_NoWarehousing_Days_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateOrderDateEnd.DateTime   = nowDate.Date;
                datePlanDateBegin.DateTime  = nowDate.Date;
                datePlanDateEnd.DateTime    = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DefaultDays);
                checkPlanDate.Checked       = false;

                lookUpReqDep.Properties.DataSource                = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                            = 0;
                lookUpPurCategory.Properties.DataSource           = commonDAO.QueryPurCategory(true);
                lookUpPurCategory.ItemIndex                       = 0;
                searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
                searchLookUpBussinessBaseNo.Text                  = "全部";
                comboBoxReqState.SelectedIndex                    = 0;
                searchLookUpProjectNo.Properties.DataSource       = commonDAO.QueryProjectList(true);
                searchLookUpProjectNo.Text                        = "全部";
                searchLookUpCodeFileName.Properties.DataSource    = commonDAO.QueryPartsCode(true);
                searchLookUpCodeFileName.Text                     = "全部";

                repLookUpReqDep.DataSource          = commonDAO.QueryDepartment(false);
                repLookUpPurCategory.DataSource     = commonDAO.QueryPurCategory(false);
                repSearchProjectNo.DataSource       = commonDAO.QueryProjectList(false);
                repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                SetGridViewAppearance();

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #9
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWarehouseReceipt_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
                    btnListAdd, checkAll
                });

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateWRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateWRDateEnd.DateTime   = nowDate.Date;

                lookUpReqDep.Properties.DataSource                 = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                             = 0;
                lookUpRepertoryNo.Properties.DataSource            = commonDAO.QueryRepertoryInfo(true);
                lookUpRepertoryNo.ItemIndex                        = 0;
                lookUpWarehouseReceiptTypeNo.Properties.DataSource = wrDAO.QueryWarehouseReceiptType(true);
                lookUpWarehouseReceiptTypeNo.ItemIndex             = 0;
                comboBoxWarehouseState.SelectedIndex               = 0;
                lookUpPrepared.Properties.DataSource               = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue                           = SystemInfo.user.EmpName;
                lookUpApprover.Properties.DataSource               = commonDAO.QueryUserInfo(true);
                lookUpApprover.ItemIndex                           = -1;
                lookUpManufactureNo.Properties.DataSource          = wrDAO.QueryManufactureInfo(true);
                lookUpManufactureNo.ItemIndex                      = 0;

                repLookUpReqDep.DataSource        = commonDAO.QueryDepartment(false);
                repLookUpRepertoryNo.DataSource   = commonDAO.QueryRepertoryInfo(false);
                repLookUpWRTypeNo.DataSource      = wrDAO.QueryWarehouseReceiptType(false);
                repLookUpApprovalType.DataSource  = commonDAO.QueryApprovalType(false);
                repLookUpManufactureNo.DataSource = wrDAO.QueryManufactureInfo(false);

                repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);
                repSearchShelfId.DataSource      = commonDAO.QueryShelfInfo(false);
                repSearchProjectNo.DataSource    = commonDAO.QueryProjectList(false);

                if (textCommon.Text == "")
                {
                    wrDAO.QueryWarehouseReceiptHead(dataSet_WR.Tables[0], "", "", "", "", "", "", 0, "", -1, "", true);
                    wrDAO.QueryWarehouseReceiptList(dataSet_WR.Tables[1], "", true);
                }
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #10
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmPrReq_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
                    btnListAdd, checkAll
                });

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateReqDateEnd.DateTime   = nowDate.Date;

                lookUpReqDep.Properties.DataSource      = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                  = 0;
                lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true);
                lookUpPurCategory.ItemIndex             = 0;
                comboBoxReqState.SelectedIndex          = 0;
                lookUpApplicant.Properties.DataSource   = commonDAO.QueryUserInfo(true);
                lookUpApplicant.EditValue               = SystemInfo.user.EmpName;
                lookUpApprover.Properties.DataSource    = commonDAO.QueryUserInfo(true);
                lookUpApprover.ItemIndex                = -1;

                repLookUpReqDep.DataSource       = commonDAO.QueryDepartment(false);
                repLookUpPurCategory.DataSource  = commonDAO.QueryPurCategory(false);
                repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false);
                repSearchProjectNo.DataSource    = commonDAO.QueryProjectList(false);

                repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);

                if (textCommon.Text == "")
                {
                    prReqDAO.QueryPrReqHead(dataSet_PrReq.Tables[0], "", "", "", "", 0, "", -1, "", true);
                }
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + tsmiCtjz.Text, ex);
            }
        }
예제 #11
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmPSBomToPrReq_Load(object sender, EventArgs e)
        {
            try
            {
                textPbBomNo.Text = pbBomNoStr;

                lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(false);
                lookUpReqDep.EditValue             = SystemInfo.user.DepartmentNo;

                searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(false);
                searchLookUpProjectNo.Text = projectNoStr;

                DataTable tempTable = commonDAO.QueryStnList(projectNoStr);
                searchLookUpStnNo.Properties.DataSource = tempTable;
                if (tempTable.Rows.Count > 0)
                {
                    searchLookUpStnNo.EditValue = tempTable.Rows[0]["StnNo"];
                }

                lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(false);
                lookUpPurCategory.ItemIndex             = 0;

                lookUpEditApprovalType.Properties.DataSource = commonDAO.QueryApprovalType(false);
                lookUpEditApprovalType.ItemIndex             = 0;

                DataTable psBomTable = PStoPRDAO.Query_NoPr_PSBom(pbBomNoStr, bomListAutoIdInt);
                gridControlPSBom.DataSource = psBomTable;
                if (psBomTable.Rows.Count == 0)
                {
                    MessageHandler.ShowMessageBox("当前选中的制作Bom信息没有生产计划,不能生成请购单。");
                    this.Close();
                    return;
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
예제 #12
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWarehouseWarrantList_NoSettlement_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateWWDateEnd.DateTime   = nowDate.Date;

                searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
                searchLookUpBussinessBaseNo.Text                   = "全部";
                lookUpRepertoryNo.Properties.DataSource            = commonDAO.QueryRepertoryInfo(true);
                lookUpRepertoryNo.ItemIndex                        = 0;
                lookUpWarehouseWarrantTypeNo.Properties.DataSource = wwDAO.QueryWarehouseWarrantType(true);
                lookUpWarehouseWarrantTypeNo.ItemIndex             = 0;
                lookUpReqDep.Properties.DataSource                 = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex = 0;
                comboBoxWarehouseState.SelectedIndex        = 0;
                searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                searchLookUpProjectNo.Text = "全部";
                searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                searchLookUpCodeFileName.Text = "全部";

                repLookUpReqDep.DataSource          = commonDAO.QueryDepartment(false);
                repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
                repLookUpRepertoryNo.DataSource     = commonDAO.QueryRepertoryInfo(false);
                repLookUpWWTypeNo.DataSource        = wwDAO.QueryWarehouseWarrantType(false);
                repLookUpShelfId.DataSource         = commonDAO.QueryShelfInfo(false);

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #13
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWarehouseNowInfo_Load(object sender, EventArgs e)
        {
            try
            {
                lookUpRepertoryNo.Properties.DataSource     = commonDAO.QueryRepertoryInfo(true);
                lookUpRepertoryNo.ItemIndex                 = 0;
                searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                searchLookUpProjectNo.Text = "全部";
                searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                searchLookUpCodeFileName.Text           = "全部";
                searchLookUpShelf.Properties.DataSource = commonDAO.QueryShelfInfo(true);
                searchLookUpShelf.EditValue             = 0;

                gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #14
0
파일: FrmStnList.cs 프로젝트: comborep/PSAP
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmStnList_Load(object sender, EventArgs e)
        {
            try
            {
                searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(false);

                if (editForm == null)
                {
                    editForm = new FrmBaseEdit();
                    editForm.FormBorderStyle = FormBorderStyle.None;
                    editForm.TopLevel        = false;
                    editForm.TableName       = "BS_StnList";
                    editForm.TableCaption    = "站号";
                    SetEditFormSQL();
                    editForm.PrimaryKeyColumn     = "AutoID";
                    editForm.MasterDataSet        = dSStnList;
                    editForm.MasterBindingSource  = bSStnList;
                    editForm.MasterEditPanel      = pnlEdit;
                    editForm.PrimaryKeyControl    = textStnNo;
                    editForm.OtherNoChangeControl = new List <Control>()
                    {
                        searchLookUpProjectNo
                    };
                    editForm.BrowseXtraGridView = gridViewStnList;
                    editForm.CheckControl      += CheckControl;
                    this.pnlToolBar.Controls.Add(editForm);
                    editForm.Dock = DockStyle.Fill;
                    editForm.Show();
                }
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
예제 #15
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmQueryStockDurationTotal_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateDurBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateDurEnd.DateTime   = nowDate.Date;

                lookUpRepertoryNo.Properties.DataSource     = commonDAO.QueryRepertoryInfo(true);
                lookUpRepertoryNo.ItemIndex                 = 0;
                searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                searchLookUpProjectNo.Text = "全部";
                searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                searchLookUpCodeFileName.Text = "全部";

                gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(false);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
예제 #16
0
        private DataTable projectListTable_false = null; //不包含全部选项

        /// <summary>
        /// SearchLookUpEdit项目信息控件初始化
        /// </summary>
        public void SearchLookUpEdit_ProjectList(SearchLookUpEdit searchLookUp, bool addAllItem, string valueMemberStr = "ProjectNo", string displayMemberStr = "ProjectName")
        {
            if (DataTypeConvert.GetString(searchLookUp.Properties.View.Tag) == "Init")
            {
                return;
            }

            GridColumn grdColAutoId = new GridColumn();

            grdColAutoId.Caption   = "AutoId";
            grdColAutoId.FieldName = "AutoId";
            grdColAutoId.Name      = "grdColAutoId";

            GridColumn grdColProjectNo = new GridColumn();

            grdColProjectNo.Caption   = "项目号";
            grdColProjectNo.FieldName = "ProjectNo";
            grdColProjectNo.Name      = "grdColProjectNo";
            grdColProjectNo.AppearanceHeader.Options.UseTextOptions = true;
            grdColProjectNo.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            grdColProjectNo.Visible      = true;
            grdColProjectNo.VisibleIndex = 0;

            GridColumn grdColProjectName = new GridColumn();

            grdColProjectName.Caption   = "项目名称";
            grdColProjectName.FieldName = "ProjectName";
            grdColProjectName.Name      = "grdColProjectName";
            grdColProjectName.AppearanceHeader.Options.UseTextOptions = true;
            grdColProjectName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            grdColProjectName.Visible      = true;
            grdColProjectName.VisibleIndex = 1;

            GridColumn grdColRemark = new GridColumn();

            grdColRemark.Caption   = "备注";
            grdColRemark.FieldName = "Remark";
            grdColRemark.Name      = "grdColRemark";
            grdColRemark.AppearanceHeader.Options.UseTextOptions = true;
            grdColRemark.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            grdColRemark.Visible      = true;
            grdColRemark.VisibleIndex = 2;

            searchLookUp.Properties.View.Columns.AddRange(new GridColumn[] { grdColAutoId, grdColProjectNo, grdColProjectName, grdColRemark });

            searchLookUp.Properties.NullText      = "";
            searchLookUp.EnterMoveNextControl     = true;
            searchLookUp.Properties.ValueMember   = valueMemberStr;
            searchLookUp.Properties.DisplayMember = displayMemberStr;

            if (addAllItem)
            {
                if (projectListTable_True == null)
                {
                    projectListTable_True = commonDAO.QueryProjectList(true);
                }
                searchLookUp.Properties.DataSource = projectListTable_True;
            }
            else
            {
                if (projectListTable_false == null)
                {
                    projectListTable_false = commonDAO.QueryProjectList(false);
                }
                searchLookUp.Properties.DataSource = projectListTable_false;
            }

            searchLookUp.Properties.View.IndicatorWidth          = 60;
            searchLookUp.Properties.View.CustomDrawRowIndicator += searchLookUpView_CustomDrawRowIndicator;

            searchLookUp.Properties.View.Tag = "Init";
        }