/// <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); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmPrReqList_Overplus_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateReqDateEnd.DateTime = nowDate.Date; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(true); lookUpPurCategory.ItemIndex = 0; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(true); searchLookUpProjectNo.Text = "全部"; searchLookUpCodeFileName.Properties.DataSource = commonDAO.QueryPartsCode(true); searchLookUpCodeFileName.Text = "全部"; comboBoxReqState.SelectedIndex = 0; repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); repLookUpProjectNo.DataSource = commonDAO.QueryProjectList(false); gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex); } }
/// <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); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmSettleAccountsQuery_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateSADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DefaultDays); dateSADateEnd.DateTime = nowDate.Date; searchLookUpBussinessBaseNo.Properties.DataSource = commonDAO.QueryBussinessBaseInfo(true); searchLookUpBussinessBaseNo.Text = "全部"; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(true); lookUpReqDep.ItemIndex = 0; lookUpPrepared.Properties.DataSource = commonDAO.QueryUserInfo(true); lookUpPrepared.EditValue = SystemInfo.user.EmpName; repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); gridBottomOrderHead.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <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); } }
private void FrmTest_WF3_Load(object sender, EventArgs e) { try { gridControl1.DataSource = commonDAO.QueryDepartment(true); dt2 = commonDAO.QueryDepartment(true); dt2.Rows.Clear(); gridControl2.DataSource = dt2; } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <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); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmSettleAccountsQuery_Load(object sender, EventArgs e) { try { DateTime nowDate = BaseSQL.GetServerDateTime(); dateSADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateSADateEnd.DateTime = nowDate.Date; DataTable bussInfoTable_t = commonDAO.QueryBussinessBaseInfo(true); DataTable departmentTable_t = commonDAO.QueryDepartment(true); searchLookUpBussinessBaseNo.Properties.DataSource = bussInfoTable_t; searchLookUpBussinessBaseNo.Text = "全部"; lookUpReqDep.Properties.DataSource = departmentTable_t; lookUpReqDep.ItemIndex = 0; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; //repSearchBussinessBaseNo.DataSource = commonDAO.QueryBussinessBaseInfo(false); //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); repSearchBussinessBaseNo.DataSource = bussInfoTable_t; repLookUpReqDep.DataSource = departmentTable_t; 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 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 FrmInventoryAdjustmentsQuery_Load(object sender, EventArgs e) { try { ControlCommonInit ctlInit = new ControlCommonInit(); DateTime nowDate = BaseSQL.GetServerDateTime(); dateIADateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateIADateEnd.DateTime = nowDate.Date; DataTable departmentTable_t = commonDAO.QueryDepartment(true); DataTable repertoryTable_t = commonDAO.QueryRepertoryInfo(true); lookUpReqDep.Properties.DataSource = departmentTable_t; lookUpReqDep.ItemIndex = 0; lookUpRepertoryId.Properties.DataSource = repertoryTable_t; lookUpRepertoryId.ItemIndex = 0; //SearchLocationId.Properties.DataSource = locationTable_t; //SearchLocationId.EditValue = 0; ctlInit.SearchLookUpEdit_RepertoryLocationInfo(SearchLocationId, true); SearchLocationId.EditValue = 0; //searchProjectNo.Properties.DataSource = projectTable_t; //searchProjectNo.Text = "全部"; ctlInit.SearchLookUpEdit_ProjectList(searchProjectNo, true); searchProjectNo.Text = "全部"; ctlInit.ComboBoxEdit_WarehouseState(comboBoxWarehouseState); comboBoxWarehouseState.SelectedIndex = 0; ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); //repLookUpRepertoryId.DataSource = commonDAO.QueryRepertoryInfo(false); //repLookUpLocationId.DataSource = commonDAO.QueryRepertoryLocationInfo(false); //repSearchProjectNo.DataSource = commonDAO.QueryProjectList(false); repLookUpReqDep.DataSource = departmentTable_t; repLookUpRepertoryId.DataSource = repertoryTable_t; repLookUpLocationId.DataSource = SearchLocationId.Properties.DataSource; repSearchProjectNo.DataSource = searchProjectNo.Properties.DataSource; repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; repLookUpApprovalType.DataSource = commonDAO.QueryApprovalType(false); if (SystemInfo.DisableProjectNo) { labProjectNo.Visible = false; searchProjectNo.Visible = false; colProjectNo.Visible = 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); } }
/// <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 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 FrmPrReqQuery_Load(object sender, EventArgs e) { try { 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; ControlCommonInit ctlInit = new ControlCommonInit(); ctlInit.SearchLookUpEdit_UserInfo_ValueMember_AutoId(searchLookUpCreator); searchLookUpCreator.EditValue = SystemInfo.user.AutoId; ctlInit.ComboBoxEdit_OrderState_Submit(comboBoxReqState); comboBoxReqState.SelectedIndex = 0; //repLookUpReqDep.DataSource = commonDAO.QueryDepartment(false); //repLookUpPurCategory.DataSource = commonDAO.QueryPurCategory(false); repLookUpReqDep.DataSource = departmentTable_t; repLookUpPurCategory.DataSource = purCateTable_t; repLookUpCreator.DataSource = searchLookUpCreator.Properties.DataSource; DateTime nowDate = BaseSQL.GetServerDateTime(); dateReqDateBegin.DateTime = nowDate.Date.AddDays(-SystemInfo.OrderQueryDate_DateIntervalDays); dateReqDateEnd.DateTime = nowDate.Date; if (SystemInfo.DisableProjectNo) { colProjectNo.Visible = false; colStnNo.Visible = false; } gridBottomPrReq.pageRowCount = SystemInfo.OrderQueryGrid_PageRowCount; btnQuery_Click(null, null); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCt.Text, ex); } }
/// <summary> /// 窗体加载事件 /// </summary> private void FrmPSBomToPrReq_Load(object sender, EventArgs e) { try { textPbBomNo.Text = pbBomNoStr; lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment(false); lookUpReqDep.EditValue = SystemInfo.user.DepartmentNo; searchLookUpProjectNo.Properties.DataSource = commonDAO.QueryProjectList(false); searchLookUpProjectNo.Text = projectNoStr; DataTable tempTable = commonDAO.QueryStnList(projectNoStr); searchLookUpStnNo.Properties.DataSource = tempTable; if (tempTable.Rows.Count > 0) { searchLookUpStnNo.EditValue = tempTable.Rows[0]["StnNo"]; } lookUpPurCategory.Properties.DataSource = commonDAO.QueryPurCategory(false); lookUpPurCategory.ItemIndex = 0; lookUpEditApprovalType.Properties.DataSource = commonDAO.QueryApprovalType(false); lookUpEditApprovalType.ItemIndex = 0; DataTable psBomTable = PStoPRDAO.Query_NoPr_PSBom(pbBomNoStr, bomListAutoIdInt); gridControlPSBom.DataSource = psBomTable; if (psBomTable.Rows.Count == 0) { MessageHandler.ShowMessageBox("当前选中的制作Bom信息没有生产计划,不能生成请购单。"); this.Close(); return; } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); } }
/// <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); } }