/// <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); } }
/// <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); } }
/// <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); } }
/// <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); } }
/// <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); } }
/// <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); } }