/// <summary> /// 窗体加载事件 /// </summary> private void FrmReturnedGoodsReportQuery_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateRGRDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateRGRDateEnd.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; comboBoxWarehouseState.SelectedIndex = 0; lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpPrepared.EditValue = SystemInfo.user.EmpName; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpRepertoryNo.DataSource = commonDAO.QueryRepertoryInfo(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); } }
/// <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); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmSalesOrder_NoSettle_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateSalesOrderDateEnd.DateTime = nowDate.Date; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; //searchProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); //searchProjectNo.Text = "全部"; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; ctlInit.SearchLookUpEdit_ProjectList(searchProjectNo, true); searchProjectNo.Text = "全部"; repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpCollectionTypeNo.DataSource = commonDAO.QueryCollectionType(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <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 FrmQuotationApply_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateRecordDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateRecordDateEnd.DateTime = nowDate.Date; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = 0; repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; repLookUpCurrencyCate.DataSource = commonDAO.QueryCurrencyCate(false); btnQuery_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <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); } }
/// <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; repLookUpCurrencyCate.DataSource = currencyCateTable; repItemCORBussinessBaseNo.DataSource = bussBaseTable; repItemCORCurrencyCate.DataSource = currencyCateTable; DateTime nowDate = BaseSQL.GetServerDateTime(); dateRecordDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateRecordDateEnd.DateTime = nowDate.Date; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable; repLookUpQState.DataSource = CommonHandler.GetQuotationInfoStateTable(false); Set_ButtonEditGrid_State(true); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmQuotationInfoQuery_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateRecordDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateRecordDateEnd.DateTime = nowDate.Date; DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t; searchLookUpBussinessBaseNo.Text = "全部"; lookUpQState.Properties.DataSource = CommonHandler.GetQuotationInfoStateTable(true); lookUpQState.ItemIndex = 0; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repSearchBussinessBaseNo.DataSource = bussInfoTable_t; repLookUpQState.DataSource = CommonHandler.GetQuotationInfoStateTable(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件错误 /// </summary> private void FrmOrderArrivalQuery_Load(object sender, EventArgs e) { try { 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; 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; //searchLookUpProjectNo.Properties.DataSource = projectTable_t; //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; //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); //repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); //repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); repLookUpReqDep.DataSource = departmentTable_t; repSearchBussinessBaseNo.DataSource = bussInfoTable_t; repLookUpPurCategory.DataSource = purCateTable_t; repSearchProjectNo.DataSource = searchLookUpProjectNo.Properties.DataSource; if (SystemInfo.DisableProjectNo) { labProjectNo.Visible = false; searchLookUpProjectNo.Visible = false; colProjectNo.Visible = false; colStnNo.Visible = false; } gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmWarehouseWarrantHead_Load(object sender, EventArgs e) { try { ControlHandler.DevExpressStyle_ChangeControlLocation(checkAll.LookAndFeel.ActiveSkinName, new List <Control> { checkAll }); 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; lookUpApprover.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpApprover.ItemIndex = -1; 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); repSearchCodeFileName.DataSource = commonDAO.QueryPartsCode(false); if (textCommon.Text == "") { wwDAO.QueryWarehouseWarrantHead(dataSet_WW.Tables[0], "", "", "", "", "", "", 0, "", -1, "", true); wwDAO.QueryWarehouseWarrantList(dataSet_WW.Tables[1], "", true); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <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_DateIntervalDays); 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; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; repSearchBussinessBaseNo.DataSource = bussBaseTable; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; repLookUpCurrencyCate.DataSource = commonDAO.QueryCurrencyCate(false); dateSODateBegin.DateTime = dateSADateBegin.DateTime; dateSODateEnd.DateTime = dateSADateEnd.DateTime; searchBussinessBaseNo.Properties.DataSource = bussBaseAddAllTable; searchBussinessBaseNo.Text = "全部"; repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable; repLookUpProjectLeaderId.DataSource = searchLookUpCreator.Properties.DataSource; if (querySettleAccountNo == "") { saDAO.QuerySettleAccountsHead(dataSet_SettleAccounts.Tables[0], "", "", "", "", 0, "", true); saDAO.QuerySettlementList(dataSet_SettleAccounts.Tables[1], "", true); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <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); ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId_NoAll(searchLookUpProjectLeaderId); searchLookUpProjectLeaderId.EditValue = SystemInfo.user.AutoId; LookUpCreator.Properties.DataSource = searchLookUpProjectLeaderId.Properties.DataSource; LookUpModifierId.Properties.DataSource = searchLookUpProjectLeaderId.Properties.DataSource; ctlInit.SearchLookUpEdit_ProjectList(searchProjectName, false); DateTime nowDate = BaseSQL.GetServerDateTime(); repSearchBussinessBaseNo.DataSource = bussBaseTable; repLookUpCreator.DataSource = searchLookUpProjectLeaderId.Properties.DataSource; dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateSalesOrderDateEnd.DateTime = nowDate.Date; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; repSearchLookUpBussinessBaseNo.DataSource = bussBaseTable; repItemLookUpCreator.DataSource = searchLookUpProjectLeaderId.Properties.DataSource; if (queryAutoSalesOrderNoStr == "") { dataSet_SalesOrder.Tables[0].Clear(); soDAO.QuerySalesOrder(dataSet_SalesOrder.Tables[0], "", "", "", "", 0, "", true); Set_ButtonEditGrid_State(true); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// SearchLookUpEdit往来方信息控件初始化 怕以后各个模块的往来方名称不一样,暂时未启用 /// </summary> public void SearchLookUpEdit_BussinessBaseInfo(SearchLookUpEdit searchLookUp, 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 = "BussinessBaseNo"; grdColLoginId.Name = "grdColBussinessBaseNo"; grdColLoginId.Visible = true; grdColLoginId.VisibleIndex = 0; GridColumn grdColEmpName = new GridColumn(); grdColEmpName.Caption = "往来方名称"; grdColEmpName.FieldName = "BussinessBaseText"; grdColEmpName.Name = "grdColBussinessBaseText"; grdColEmpName.Visible = true; grdColEmpName.VisibleIndex = 1; GridColumn grdColBussinessCategoryText = new GridColumn(); grdColEmpName.Caption = "往来方类别"; grdColEmpName.FieldName = "BussinessCategoryText"; grdColEmpName.Name = "grdColBussinessCategoryText"; grdColEmpName.Visible = true; grdColEmpName.VisibleIndex = 2; searchLookUp.Properties.View.Columns.AddRange(new GridColumn[] { grdColAutoId, grdColLoginId, grdColBussinessCategoryText }); searchLookUp.Properties.NullText = ""; searchLookUp.EnterMoveNextControl = true; searchLookUp.Properties.DisplayMember = "BussinessBaseText"; searchLookUp.Properties.ValueMember = "BussinessBaseNo"; if (bussInfoTable_True == null) { bussInfoTable_True = commonDAO.QueryBussinessBaseInfo(addAllItem); } searchLookUp.Properties.DataSource = bussInfoTable_True; searchLookUp.Properties.View.IndicatorWidth = 60; searchLookUp.Properties.View.CustomDrawRowIndicator += searchLookUpView_CustomDrawRowIndicator; searchLookUp.Properties.View.Tag = "Init"; }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmWarehouseWarrantQuery_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; 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); //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; 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); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <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); } }
/// <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); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmSettlementQuery_Load(object sender, EventArgs e) { try { ControlCommonInit ctlInit = new ControlCommonInit(); DateTime nowDate = BaseSQL.GetServerDateTime(); dateSettlementDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateSettlementDateEnd.DateTime = nowDate.Date; datePayDateBegin.DateTime = nowDate.Date; datePayDateEnd.DateTime = nowDate.Date.AddDays(SystemInfo.OrderQueryDate_DateIntervalDays); checkPayDate.Checked = false; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState, true); comboBoxWarehouseState.SelectedIndex = 0; ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; if (textCommon.Text == "") { btnQuery_Click(null, null); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCtjz.Text, ex); } }
/// <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_DateIntervalDays); dateOrderDateEnd.DateTime = nowDate.Date; checkOrderDate.Checked = false; DataTable departmentTable_t = commonDAO.QueryDepartment(true); DataTable purCateTable_t = commonDAO.QueryPurCategory(true); DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true); lookUpReqDep.Properties.DataSource = departmentTable_t; lookUpReqDep.ItemIndex = 0; lookUpPurCategory.Properties.DataSource = purCateTable_t; lookUpPurCategory.ItemIndex = 0; searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t; searchLookUpBussinessBaseNo.Text = "全部"; //searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); //searchLookUpProjectNo.Text = "全部"; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = 0; ctlInit.SearchLookUpEdit_ProjectList(searchLookUpProjectNo, true); searchLookUpProjectNo.Text = "全部"; //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); //repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpReqDep.DataSource = departmentTable_t; repLookUpPurCategory.DataSource = purCateTable_t; repSearchBussinessBaseNo.DataSource = bussInfoTable_t; repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; if (SystemInfo.DisableProjectNo) { labProjectNo.Visible = false; searchLookUpProjectNo.Visible = false; colProjectName.Visible = false; colStnNo.Visible = false; } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <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); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmSelectQuotationInfo_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateSalesOrderDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateSalesOrderDateEnd.DateTime = nowDate.Date; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; repSearchLookUpBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpQState.DataSource = CommonHandler.GetQuotationInfoStateTable(false); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <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); } }
/// <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); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmProjectList_Load(object sender, EventArgs e) { try { searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(false); if (editForm == null) { editForm = new FrmBaseEdit(); editForm.FormBorderStyle = FormBorderStyle.None; editForm.TopLevel = false; editForm.TableName = "BS_ProjectList"; editForm.TableCaption = "项目号"; editForm.Sql = "select BS_ProjectList.*, BS_BussinessBaseInfo.BussinessBaseText from BS_ProjectList left join BS_BussinessBaseInfo on BS_ProjectList.BussinessBaseNo=BS_BussinessBaseInfo.BussinessBaseNo order by BS_ProjectList.AutoId"; editForm.PrimaryKeyColumn = "ProjectNo"; editForm.MasterDataSet = dSProjectList; editForm.MasterBindingSource = bSProjectList; editForm.MasterEditPanel = pnlEdit; editForm.PrimaryKeyControl = textProjectNo; editForm.OtherNoChangeControl = new List <Control>() { textProjectName }; editForm.BrowseXtraGridView = gridViewProjectList; editForm.CheckControl += CheckControl; editForm.ButtonList.Add(btnStnList); this.pnlToolBar.Controls.Add(editForm); editForm.Dock = DockStyle.Fill; editForm.Show(); stnList = new FrmStnList("", ""); stnList.Show(this.dockPanelStn); stnList.Dock = DockStyle.Fill; stnList.TopLevel = false; stnList.FormBorderStyle = FormBorderStyle.None; this.dockPanelStn.Text = stnList.Text; this.dockPanelStn.TabText = stnList.Text; this.dockPanelStn.Controls.Add(stnList); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmQuotationInfo_Load(object sender, EventArgs e) { try { ControlHandler.DevExpressStyle_ChangeControlLocation(btnListAdd.LookAndFeel.ActiveSkinName, new List <Control> { btnListAdd }); searchBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpCurrencyCate.DataSource = commonDAO.QueryCurrencyCate(false); btnRefresh_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmProjectList_Load(object sender, EventArgs e) { try { searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(false); lookUpProjectStatusId.Properties.DataSource = statusDAO.QueryProjectStatus(false); //searchLookUpLeaderId.Properties.DataSource = projectDAO.QueryUserInfo(false); ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId_NoAll(searchLookUpLeaderId); repLookUpProjectStatusId.DataSource = statusDAO.QueryProjectStatus(false); repLookUpLeaderId.DataSource = searchLookUpLeaderId.Properties.DataSource; stnList = new FrmStnList("", ""); stnList.Show(this.PageStnInfo); stnList.Dock = DockStyle.Fill; stnList.TopLevel = false; stnList.FormBorderStyle = FormBorderStyle.None; //this.PageStnInfo.Text = stnList.Text; this.dockPanelInfo.Text = "项目其他信息"; this.dockPanelInfo.TabText = this.dockPanelInfo.Text; this.PageStnInfo.Controls.Add(stnList); if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, btnStnList, false)) { PageStnInfo.Enabled = false; } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.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); } }