Esempio n. 1
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);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmProductionSchedule_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> {
                    checkAll
                });

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateCurrentDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateCurrentDateEnd.DateTime   = nowDate.Date;
                datePlanDateBegin.DateTime    = nowDate.Date;
                datePlanDateEnd.DateTime      = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DefaultDays);
                checkPlanDate.Checked         = false;

                searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                searchLookUpCodeFileName.Text        = "全部";
                lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue             = SystemInfo.user.EmpName;
                comboBoxReqState.SelectedIndex       = 0;

                repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false);

                if (textCommon.Text == "")
                {
                    psDAO.QueryProductionSchedule(dataSet_PSchedule.Tables[0], "", "", "", "", "", 0, "", -1, "", true);
                    psDAO.QueryProductionScheduleBom(dataSet_PSchedule.Tables[1], "", true);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 3
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);
            }
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmSpecialWarehouseReceiptQuery_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateSWRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateSWRDateEnd.DateTime   = nowDate.Date;

                lookUpReqDep.Properties.DataSource      = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                  = 0;
                lookUpRepertoryNo.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
                lookUpRepertoryNo.ItemIndex             = 0;
                comboBoxWarehouseState.SelectedIndex    = 0;
                lookUpPrepared.Properties.DataSource    = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue                = SystemInfo.user.EmpName;

                repLookUpReqDep.DataSource       = commonDAO.QueryDepartment(false);
                repLookUpRepertoryNo.DataSource  = commonDAO.QueryRepertoryInfo(false);
                repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false);

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 5
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmPrReqQuery_Load(object sender, EventArgs e)
        {
            try
            {
                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;
                repositoryItemLookUpEdit1.DataSource    = commonDAO.QueryDepartment(false);
                repositoryItemLookUpEdit2.DataSource    = commonDAO.QueryPurCategory(false);

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

                gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex);
            }
        }
Esempio n. 6
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmStnModule_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateGetTimeBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateGetTimeEnd.DateTime   = nowDate.Date;

                LookUpCreator.Properties.DataSource = commonDAO.QueryUserInfo(false);

                repItemLookUpCreator.DataSource = LookUpCreator.Properties.DataSource;

                repLookUpCreator.DataSource = LookUpCreator.Properties.DataSource;

                if (querySMNoStr == "")
                {
                    smDAO.QueryStnModule(dataSet_StnModule.Tables[0], "", "", 0, "", "", true);
                    Set_ButtonEditGrid_State(true);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 7
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmOrderApply_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> {
                    checkAll
                });

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateOrderDateEnd.DateTime   = nowDate.Date;
                checkOrderDate.Checked      = false;

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

                repLookUpReqDep.DataSource          = commonDAO.QueryDepartment(false);
                repLookUpPurCategory.DataSource     = commonDAO.QueryPurCategory(false);
                repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
Esempio n. 8
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);
            }
        }
Esempio n. 9
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmProductionScheduleQuery_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateCurrentDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateCurrentDateEnd.DateTime   = nowDate.Date;
                dateReqDateBegin.DateTime     = nowDate.Date;
                dateReqDateEnd.DateTime       = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DefaultDays);
                checkReqDate.Checked          = false;

                lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue             = SystemInfo.user.EmpName;

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                if (textCommon.Text == "")
                {
                    btnQuery_Click(null, null);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 10
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);
            }
        }
Esempio n. 11
0
        /// <summary>
        /// 选择操作员或者权限角色
        /// </summary>
        private void radioHandleCate_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (radioHandleCate.SelectedIndex == 0)//操作员
                {
                    labHandleOwner.Text = "操作员";
                    searchLookUpHandleOwner.Properties.DataSource    = commonDAO.QueryUserInfo(false);
                    searchLookUpHandleOwner.Properties.DisplayMember = "EmpName";
                    searchLookUpHandleOwner.Properties.ValueMember   = "LoginId";

                    gridColRoleNo.Visible   = false;
                    gridColRoleName.Visible = false;
                    gridColLoginId.Visible  = true;
                    gridColEmpName.Visible  = true;
                }
                else//权限角色
                {
                    labHandleOwner.Text = "权限角色";
                    searchLookUpHandleOwner.Properties.DataSource    = commonDAO.QueryRole(false);
                    searchLookUpHandleOwner.Properties.DisplayMember = "RoleName";
                    searchLookUpHandleOwner.Properties.ValueMember   = "RoleNo";

                    gridColLoginId.Visible  = false;
                    gridColEmpName.Visible  = false;
                    gridColRoleNo.Visible   = true;
                    gridColRoleName.Visible = true;
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--选择操作员或者权限角色错误。", ex);
            }
        }
Esempio n. 12
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmPrReqListQuery_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateRequirementDateBegin.DateTime = nowDate.Date;
                dateRequirementDateEnd.DateTime   = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays);
                dateReqDateBegin.DateTime         = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateReqDateEnd.DateTime           = nowDate.Date;
                checkReqDate.Checked = false;

                DataTable departmentTable_t = commonDAO.QueryDepartment(true);
                DataTable purCateTable_t    = commonDAO.QueryPurCategory(true);

                lookUpReqDep.Properties.DataSource      = departmentTable_t;
                lookUpReqDep.ItemIndex                  = 0;
                lookUpPurCategory.Properties.DataSource = purCateTable_t;
                lookUpPurCategory.ItemIndex             = 0;
                //searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                //searchLookUpProjectNo.Text = "全部";
                //searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                //searchLookUpCodeFileName.EditValue = 0;

                ControlCommonInit ctlInit = new ControlCommonInit();
                ctlInit.SearchLookUpEdit_PartsCode(searchLookUpCodeFileName, true);
                searchLookUpCodeFileName.EditValue = 0;
                ctlInit.SearchLookUpEdit_ProjectList(searchLookUpProjectNo, true);
                searchLookUpProjectNo.Text = "全部";
                ctlInit.ComboBoxEdit_OrderState_Submit(comboBoxReqState);
                comboBoxReqState.SelectedIndex = 0;

                //repItemLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
                //repItemLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false);
                repItemLookUpReqDep.DataSource      = departmentTable_t;
                repItemLookUpPurCategory.DataSource = purCateTable_t;
                repLookUpCreator.DataSource         = commonDAO.QueryUserInfo(false);

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

                gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 13
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);
            }
        }
Esempio n. 14
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);
            }
        }
Esempio n. 15
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmPriceInfo_Load(object sender, EventArgs e)
        {
            try
            {
                searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(false);
                lookUpCurrencyCate.Properties.DataSource          = commonDAO.QueryCurrencyCate(false);

                repLookUpBussinessBaseNo.DataSource = searchLookUpBussinessBaseNo.Properties.DataSource;
                repLookUpCurrencyCate.DataSource    = lookUpCurrencyCate.Properties.DataSource;
                repLookUpCreator.DataSource         = commonDAO.QueryUserInfo(false);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 16
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmDeliveryDetail_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
                    btnListAdd
                });

                LookUpCreator.Properties.DataSource = commonDAO.QueryUserInfo(false);

                btnRefresh_Click(null, null);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 17
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmSettleAccounts_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> {
                    checkAll
                });

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateSADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateSADateEnd.DateTime   = nowDate.Date;

                DataTable bussBaseTable       = commonDAO.QueryBussinessBaseInfo(false);
                DataTable bussBaseAddAllTable = commonDAO.QueryBussinessBaseInfo(true);

                searchLookUpBussinessBaseNo.Properties.DataSource = bussBaseAddAllTable;
                searchLookUpBussinessBaseNo.Text     = "全部";
                lookUpReqDep.Properties.DataSource   = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex               = 0;
                lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue             = SystemInfo.user.EmpName;

                repSearchBussinessBaseNo.DataSource = bussBaseTable;
                repLookUpReqDep.DataSource          = commonDAO.QueryDepartment(false);

                repLookUpCurrencyCate.DataSource = commonDAO.QueryCurrencyCate(false);

                dateSODateBegin.DateTime = dateSADateBegin.DateTime;
                dateSODateEnd.DateTime   = dateSADateEnd.DateTime;
                searchBussinessBaseNo.Properties.DataSource = bussBaseAddAllTable;
                searchBussinessBaseNo.Text = "全部";

                repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable;

                if (textCommon.Text == "")
                {
                    saDAO.QuerySettleAccountsHead(dataSet_SettleAccounts.Tables[0], "", "", "", "", "", "", true);
                    saDAO.QuerySettlementList(dataSet_SettleAccounts.Tables[1], "", true);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 18
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmQuotationInfo_History_Load(object sender, EventArgs e)
        {
            try
            {
                ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> {
                    btnListAdd
                });

                DataTable bussBaseTable     = commonDAO.QueryBussinessBaseInfo(false);
                DataTable currencyCateTable = commonDAO.QueryCurrencyCate(false);

                searchBussinessBaseNo.Properties.DataSource = bussBaseTable;
                LookUpCreator.Properties.DataSource         = commonDAO.QueryUserInfo(false);
                LookUpModifierId.Properties.DataSource      = LookUpCreator.Properties.DataSource;

                repLookUpCurrencyCate.DataSource = currencyCateTable;

                repItemCORBussinessBaseNo.DataSource = bussBaseTable;
                repItemCORCurrencyCate.DataSource    = currencyCateTable;

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateRecordDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateRecordDateEnd.DateTime   = nowDate.Date;

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

                repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable;
                repLookUpQState.DataSource = CommonHandler.GetQuotationInfoStateTable(false);

                if (queryAutoQuotationNoStr == "")
                {
                    dataSet_Quotation.Tables[0].Clear();
                    quoDAO.QueryQuotationBaseInfo(dataSet_Quotation.Tables[0], "", "", "", 0, "", true);
                    Set_ButtonEditGrid_State(true);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 19
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmStnSummary_Load(object sender, EventArgs e)
        {
            try
            {
                LookUpCreator.Properties.DataSource = commonDAO.QueryUserInfo(false);

                repLookUpCreator.DataSource = LookUpCreator.Properties.DataSource;

                if (queryAutoQuotationNoStr == "")
                {
                    ssDAO.QueryStnSummary(TableStnSummary, "", "", true);
                    ssDAO.QueryStnSummaryList(TableStnList, "", true);
                    Set_ButtonEditGrid_State(true);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 20
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmSelectQuotationInfo_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     = "全部";
                lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue             = SystemInfo.user.EmpName;

                repSearchLookUpBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
                repLookUpQState.DataSource = CommonHandler.GetQuotationInfoStateTable(false);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 21
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmApprovalList_Load(object sender, EventArgs e)
        {
            try
            {
                FrmCommonDAO commonDAO = new FrmCommonDAO();
                repItemLookUpTypeNo.DataSource   = commonDAO.QueryApprovalType(false);
                repItemLookUpApprover.DataSource = commonDAO.QueryUserInfo(false);

                if (editForm == null)
                {
                    editForm = new FrmBaseEdit();
                    editForm.FormBorderStyle     = FormBorderStyle.None;
                    editForm.TopLevel            = false;
                    editForm.TableName           = "PUR_ApprovalList";
                    editForm.TableCaption        = "审批信息设置";
                    editForm.Sql                 = string.Format("select * from PUR_ApprovalList where typeNo='{0}' Order by AppSequence", TypeNoStr);
                    editForm.PrimaryKeyColumn    = "AutoId";
                    editForm.MasterDataSet       = dSApprovalList;
                    editForm.MasterBindingSource = bSApprovalList;
                    //editForm.MasterEditPanel = pnlEdit;
                    editForm.BrowseXtraGridView = gridViewApprovalList;
                    editForm.CheckControl      += CheckControl;
                    editForm.SaveRowBefore     += SaveRowBefore;
                    editForm.DeleteRowBefore   += DeleteRowBefore;
                    editForm.ButtonList.Add(btnUp);
                    editForm.ButtonList.Add(btnDown);
                    editForm.DeleteAfterRefresh = true;
                    //editForm.btnSaveExcel.Visible = false;
                    editForm.VisibleSearchContrl = false;
                    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);
            }
        }
Esempio n. 22
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmStnSummary_Query_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateGetTimeBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateGetTimeEnd.DateTime   = nowDate.Date;

                searchLookUpStnModule.Properties.DataSource = ssDAO.QueryStnModule(true);
                searchLookUpStnModule.Text           = "全部";
                lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue             = SystemInfo.user.EmpName;

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 23
0
        /// <summary>
        /// 窗体加载事件错误
        /// </summary>
        private void FrmOrderQuery_Load(object sender, EventArgs e)
        {
            try
            {
                lookUpReqDep.Properties.DataSource                = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex                            = 0;
                lookUpPurCategory.Properties.DataSource           = commonDAO.QueryPurCategory(true);
                lookUpPurCategory.ItemIndex                       = 0;
                comboBoxReqState.SelectedIndex                    = 0;
                lookUpPrepared.Properties.DataSource              = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue                          = SystemInfo.user.EmpName;
                searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true);
                searchLookUpBussinessBaseNo.Text                  = "全部";

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

                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;

                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);
            }
        }
Esempio n. 24
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWarehouseWarrantQuery_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateWWDateEnd.DateTime   = nowDate.Date;

                lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true);
                lookUpReqDep.ItemIndex             = 0;
                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;
                comboBoxWarehouseState.SelectedIndex               = 0;
                lookUpPrepared.Properties.DataSource               = commonDAO.QueryUserInfo(true);
                lookUpPrepared.EditValue = SystemInfo.user.EmpName;

                repLookUpReqDep.DataSource          = commonDAO.QueryDepartment(false);
                repLookUpRepertoryNo.DataSource     = commonDAO.QueryRepertoryInfo(false);
                repLookUpWWTypeNo.DataSource        = wwDAO.QueryWarehouseWarrantType(false);
                repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
                repLookUpApprovalType.DataSource    = commonDAO.QueryApprovalType(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);
            }
        }
Esempio n. 25
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmQuotationApply_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateRecordDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays);
                dateRecordDateEnd.DateTime   = nowDate.Date;

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

                repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);

                repLookUpCurrencyCate.DataSource = commonDAO.QueryCurrencyCate(false);

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Esempio n. 26
0
        public void SearchLookUpEdit_UserInfo(SearchLookUpEdit searchLookUp, string valueMemberStr, bool addAllItem)
        {
            if (DataTypeConvert.GetString(searchLookUp.Properties.View.Tag) == "Init")
            {
                return;
            }

            GridColumn grdColAutoId = new GridColumn();

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

            GridColumn grdColLoginId = new GridColumn();

            grdColLoginId.Caption   = "用户名";
            grdColLoginId.FieldName = "LoginId";
            grdColLoginId.Name      = "grdColLoginId";
            grdColLoginId.AppearanceHeader.Options.UseTextOptions = true;
            grdColLoginId.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            grdColLoginId.Visible      = true;
            grdColLoginId.VisibleIndex = 0;

            GridColumn grdColEmpName = new GridColumn();

            grdColEmpName.Caption   = "员工名";
            grdColEmpName.FieldName = "EmpName";
            grdColEmpName.Name      = "grdColEmpName";
            grdColEmpName.AppearanceHeader.Options.UseTextOptions = true;
            grdColEmpName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            grdColEmpName.Visible      = true;
            grdColEmpName.VisibleIndex = 1;

            GridColumn grdColDepartmentName = new GridColumn();

            grdColDepartmentName.Caption   = "部门";
            grdColDepartmentName.FieldName = "DepartmentName";
            grdColDepartmentName.Name      = "grdColDepartmentName";
            grdColDepartmentName.AppearanceHeader.Options.UseTextOptions = true;
            grdColDepartmentName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            grdColDepartmentName.Visible      = true;
            grdColDepartmentName.VisibleIndex = 2;

            searchLookUp.Properties.View.Columns.AddRange(new GridColumn[] { grdColAutoId, grdColLoginId, grdColEmpName, grdColDepartmentName });

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

            if (userInfoTable_True == null)
            {
                userInfoTable_True = commonDAO.QueryUserInfo(addAllItem);
            }

            searchLookUp.Properties.DataSource = userInfoTable_True;

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

            searchLookUp.Properties.View.Tag = "Init";
        }
Esempio n. 27
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWorkFlowsLineSet_Load(object sender, EventArgs e)
        {
            try
            {
                if (!isEditWorkFlows)
                {
                    lookUpLineType.Properties.ReadOnly = true;
                }

                if (lineIdInt == 0)
                {
                    labEnabled.Visible   = false;
                    checkEnabled.Visible = false;

                    PageCondition.PageVisible = false;

                    lookUpLineType.Properties.DataSource = DataTypeConvert.EnumToDataTable_NoInclude(typeof(WorkFlowsHandleDAO.LineType), "LineType", "TypeId", new List <int>()
                    {
                        -1, 0
                    });
                }
                else if (lineIdInt > 0)
                {
                    repLookUpCreator.DataSource  = commonDAO.QueryUserInfo(false);
                    repLookUpCreator1.DataSource = repLookUpCreator.DataSource;
                    repLookUpCreator2.DataSource = repLookUpCreator.DataSource;

                    lookUpLineType.Properties.DataSource = DataTypeConvert.EnumToDataTable_NoInclude(typeof(WorkFlowsHandleDAO.LineType), "LineType", "TypeId", new List <int>()
                    {
                        -1, 0
                    });

                    RefreshLineControlInfo();

                    setDAO.QueryWorkFlowsLineConditionList(TableCondition, lineIdInt);
                }
                else
                {
                    PageBaseInfo.PageVisible   = false;
                    BtnCopy.Visible            = false;
                    PageLineHandle.PageVisible = false;

                    colMultiLevelApprover.Visible  = false;
                    colMultiLevelApprover1.Visible = false;
                    pnlLineHandleTop.Height        = 97;
                    btnHandleNew.Location          = new Point(298, 54);
                    btnHandleDelete.Location       = new Point(354, 54);

                    repLookUpCreator.DataSource  = commonDAO.QueryUserInfo(false);
                    repLookUpCreator2.DataSource = repLookUpCreator.DataSource;

                    radioHandleCate_SelectedIndexChanged(null, null);

                    RefreshConditionInfo();

                    setDAO.QueryWorkFlowsLineConditionList(TableCondition, lineIdInt);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }