Exemplo n.º 1
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmInventoryMoveQuery_Load(object sender, EventArgs e)
        {
            try
            {
                ControlCommonInit ctlInit = new ControlCommonInit();

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateIMDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateIMDateEnd.DateTime   = nowDate.Date;

                DataTable repertoryTable_t  = commonDAO.QueryRepertoryInfo(true);
                DataTable departmentTable_t = commonDAO.QueryDepartment(true);

                lookUpInRepertoryId.Properties.DataSource  = repertoryTable_t;
                lookUpInRepertoryId.ItemIndex              = 0;
                lookUpOutRepertoryId.Properties.DataSource = repertoryTable_t;
                lookUpOutRepertoryId.ItemIndex             = 0;
                //SearchInLocationId.Properties.DataSource = locationTable_t;
                //SearchInLocationId.EditValue = 0;
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchInLocationId, true);
                SearchInLocationId.EditValue = 0;
                //SearchOutLocationId.Properties.DataSource = locationTable_t;
                //SearchOutLocationId.EditValue = 0;
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchOutLocationId, true);
                SearchOutLocationId.EditValue = 0;
                ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState);
                comboBoxWarehouseState.SelectedIndex = 0;
                lookUpReqDep.Properties.DataSource   = departmentTable_t;
                lookUpReqDep.ItemIndex = 0;
                ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator);
                searchLookUpCreator.EditValue = SystemInfo.user.AutoId;

                //repLookUpInRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false);
                //repLookUpLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false);
                //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
                //repLookUpCreator.DataSource = commonDAO.QueryUserInfo(false);
                repLookUpInRepertoryId.DataSource = repertoryTable_t;
                repLookUpLocationId.DataSource    = SearchInLocationId.Properties.DataSource;
                repLookUpReqDep.DataSource        = departmentTable_t;
                repLookUpCreator.DataSource       = searchLookUpCreator.Properties.DataSource;
                repLookUpApprovalType.DataSource  = commonDAO.QueryApprovalType(false);

                gridBottomIM.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmProductOpenAccount_Load(object sender, EventArgs e)
        {
            try
            {
                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateOpBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateOpEnd.DateTime   = nowDate.Date;

                DataTable repertoryTable_t = commonDAO.QueryRepertoryInfo(true);

                lookUpRepertoryId.Properties.DataSource = repertoryTable_t;
                lookUpRepertoryId.ItemIndex             = 0;
                //SearchLocationId.Properties.DataSource = locationTable_t;
                //SearchLocationId.EditValue = 0;
                //searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                //searchLookUpProjectNo.Text = "全部";
                //searchLookUpShelfId.Properties.DataSource = shelfTable_t;
                //searchLookUpShelfId.EditValue = 0;
                //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.SearchLookUpEdit_ShelfInfo(searchLookUpShelfId, true);
                searchLookUpShelfId.EditValue = 0;
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true);
                SearchLocationId.EditValue = 0;

                //repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false);
                //repLookUpLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false);
                repLookUpRepertoryId.DataSource = repertoryTable_t;
                repLookUpLocationId.DataSource  = SearchLocationId.Properties.DataSource;
                repLookUpShelfId.DataSource     = searchLookUpShelfId.Properties.DataSource;

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

                if (SystemInfo.DisableShelfInfo)
                {
                    labShelfId.Visible          = false;
                    searchLookUpShelfId.Visible = false;
                    colShelfId.Visible          = false;
                }

                gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Exemplo n.º 3
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWarehouseNowInfo_Load(object sender, EventArgs e)
        {
            try
            {
                DataTable repertoryTable_t = commonDAO.QueryRepertoryInfo(true);
                DataTable catgNameTable_f  = commonDAO.QueryPartNoCatg(false);

                lookUpRepertoryId.Properties.DataSource = repertoryTable_t;
                lookUpRepertoryId.ItemIndex             = 0;
                //SearchLocationId.Properties.DataSource = locationTable_t;
                //SearchLocationId.EditValue = 0;
                //searchLookUpShelfId.Properties.DataSource = shelfTable_t;
                //searchLookUpShelfId.EditValue = 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.SearchLookUpEdit_ShelfInfo(searchLookUpShelfId, true);
                searchLookUpShelfId.EditValue = 0;
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true);
                SearchLocationId.EditValue = 0;

                //repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false);
                //repLookUpLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false);
                //repLookUpShelfId.DataSource = commonDAO.QueryShelfInfo(false);
                repLookUpRepertoryId.DataSource = repertoryTable_t;
                repLookUpLocationId.DataSource  = SearchLocationId.Properties.DataSource;
                repLookUpShelfId.DataSource     = searchLookUpShelfId.Properties.DataSource;
                repLookUpCatgName.DataSource    = catgNameTable_f;

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

                if (SystemInfo.DisableShelfInfo)
                {
                    labShelfId.Visible          = false;
                    searchLookUpShelfId.Visible = false;
                    colShelfId.Visible          = false;
                }

                gridBottomWNowInfo.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmReturnedGoodsReportQuery_Load(object sender, EventArgs e)
        {
            try
            {
                ControlCommonInit ctlInit = new ControlCommonInit();

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateRGRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateRGRDateEnd.DateTime   = nowDate.Date;

                DataTable departmentTable_t = commonDAO.QueryDepartment(true);
                DataTable bussInfoTable_t   = commonDAO.QueryBussinessBaseInfo(true);
                DataTable repertoryTable_t  = commonDAO.QueryRepertoryInfo(true);

                lookUpReqDep.Properties.DataSource = departmentTable_t;
                lookUpReqDep.ItemIndex             = 0;
                searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t;
                searchLookUpBussinessBaseNo.Text        = "全部";
                lookUpRepertoryId.Properties.DataSource = repertoryTable_t;
                lookUpRepertoryId.ItemIndex             = 0;
                //SearchLocationId.Properties.DataSource = locationTable_t;
                //SearchLocationId.EditValue = 0;
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true);
                SearchLocationId.EditValue = 0;
                ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState);
                comboBoxWarehouseState.SelectedIndex = 0;
                ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator);
                searchLookUpCreator.EditValue = SystemInfo.user.AutoId;

                //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
                //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
                //repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false);
                //repLookUpRepertoryLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false);
                repLookUpReqDep.DataSource              = departmentTable_t;
                repSearchBussinessBaseNo.DataSource     = bussInfoTable_t;
                repLookUpRepertoryId.DataSource         = repertoryTable_t;
                repLookUpRepertoryLocationId.DataSource = SearchLocationId.Properties.DataSource;
                repLookUpApprovalType.DataSource        = commonDAO.QueryApprovalType(false);
                repLookUpCreator.DataSource             = searchLookUpCreator.Properties.DataSource;

                gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount;

                btnQuery_Click(null, null);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
Exemplo n.º 5
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmShelfInfo_Load(object sender, EventArgs e)
        {
            try
            {
                ControlCommonInit ctlInit = new ControlCommonInit();
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchRepertoryLocationId, false);
                //DataTable locationInfoTable = commonDAO.QueryRepertoryLocationInfo(false);
                //SearchRepertoryLocationId.Properties.DataSource = locationInfoTable;

                repLookUpRepertoryLocationId.DataSource = SearchRepertoryLocationId.Properties.DataSource;
                repLookUpRepertoryInfoId.DataSource     = commonDAO.QueryRepertoryInfo(false);
                repLookUpCreator.DataSource             = commonDAO.QueryUserInfo_OnlyColumn(false);
            }
            catch (Exception ex)
            {
                //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
                ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex);
            }
        }
Exemplo n.º 6
0
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWarehouseNowInfo_Bom_Load(object sender, EventArgs e)
        {
            try
            {
                ControlCommonInit ctlInit = new ControlCommonInit();
                ctlInit.SearchLookUpEdit_PartsCode(searchCodeFileName, false, "CodeFileName", "CodeFileName");
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true);
                SearchLocationId.EditValue = 0;

                //searchCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(false);
                lookUpRepertoryId.Properties.DataSource = commonDAO.QueryRepertoryInfo(true);
                lookUpRepertoryId.ItemIndex             = 0;
                //SearchLocationId.Properties.DataSource = commonDAO.QueryRepertoryLocationInfo(true);
                //SearchLocationId.EditValue = 0;

                repLookUpCatgName.DataSource = commonDAO.QueryPartNoCatg(false);
            }
            catch (Exception ex)
            {
                ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
            }
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        private void FrmWarehouseWarrantList_NoSettlement_Load(object sender, EventArgs e)
        {
            try
            {
                ControlCommonInit ctlInit = new ControlCommonInit();

                DateTime nowDate = BaseSQL.GetServerDateTime();
                dateWWDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays);
                dateWWDateEnd.DateTime   = nowDate.Date;

                DataTable departmentTable_t = commonDAO.QueryDepartment(true);
                DataTable bussInfoTable_t   = commonDAO.QueryBussinessBaseInfo(true);
                DataTable repertoryTable_t  = commonDAO.QueryRepertoryInfo(true);
                DataTable wwTypeTable_t     = wwDAO.QueryWarehouseWarrantType(true);

                lookUpReqDep.Properties.DataSource = departmentTable_t;
                lookUpReqDep.ItemIndex             = 0;
                searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t;
                searchLookUpBussinessBaseNo.Text        = "全部";
                lookUpRepertoryId.Properties.DataSource = repertoryTable_t;
                lookUpRepertoryId.ItemIndex             = 0;
                //SearchLocationId.Properties.DataSource = locationTable_t;
                //SearchLocationId.EditValue = 0;
                ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true);
                SearchLocationId.EditValue = 0;
                lookUpWarehouseWarrantTypeNo.Properties.DataSource = wwTypeTable_t;
                lookUpWarehouseWarrantTypeNo.ItemIndex             = 0;
                ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState, true);
                comboBoxWarehouseState.SelectedIndex = 0;
                //searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true);
                //searchLookUpProjectNo.Text = "全部";
                ctlInit.SearchLookUpEdit_ProjectList(searchLookUpProjectNo, true);
                searchLookUpProjectNo.Text = "全部";
                //searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true);
                //searchLookUpCodeFileName.EditValue = 0;
                ctlInit.SearchLookUpEdit_PartsCode(searchLookUpCodeFileName, true);
                searchLookUpCodeFileName.EditValue = 0;

                //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false);
                //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false);
                //repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false);
                //repLookUpRepertoryLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false);
                //repLookUpWWTypeNo.DataSource = wwDAO.QueryWarehouseWarrantType(false);
                repLookUpReqDep.DataSource              = departmentTable_t;
                repSearchBussinessBaseNo.DataSource     = bussInfoTable_t;
                repLookUpRepertoryId.DataSource         = repertoryTable_t;
                repLookUpRepertoryLocationId.DataSource = SearchLocationId.Properties.DataSource;
                repLookUpWWTypeNo.DataSource            = wwTypeTable_t;
                repLookUpShelfId.DataSource             = commonDAO.QueryShelfInfo(false);

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

                if (SystemInfo.DisableShelfInfo)
                {
                    colShelfId.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);
            }
        }