【信息系统分析与设计】之Matlab设计信息系统

0.销售订单管理系统

0.1 功能：

打开文件
查询订单
插入订单
订单统计
系统退出

0.2 数据库：

数据文件Excel

0.3 字段：

编号(E111)
客户(王小明)
金额(23453.33)

1.系统设计

1.1 查询订单页面

查询条件：订单编号

输出内容：客户姓名、金额

1.2 插入订单页面

输入内容：订单编号、客户姓名、金额

按钮内容：确定、重置、返回

1.3 订单统计页面

输出内容：订单总额、大写金额(元)、订单交易数(个)

按钮内容：查询、重置、返回

2.分析设计准备

2.1 如何实现系统功能

2.1.1 模块Module

组成系统的基本单元
由内部属性和外部属性组成
内部属性：算法(函数体)、内部变量(局部变量)
外部属性：功能(函数名)、输入输出数据(参数)

2.2 Matlab存取Excel文件数据

函数：

xlsfinfo()
[data, textdata] = xlsread(filename,sheet,range)
[status,message] = xlswrite(filename,sheet,range)

2.3 Matlab Graphics User Interface

练习

向execl中写入文件，金额转换成大写。
完整代码第一部分：向execl中写入文件

页面如下(页面中的读取函数在第一部分的代码中未写)：

【信息系统分析与设计】之Matlab设计信息系统

Test.m：

关键代码：

% --- Executes on button press in pushbutton1.
function pushbutton1_Callback(hObject, eventdata, handles)
% hObject    handle to pushbutton1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
global num txt
[num,txt] = xlsread('YH.xlsx');
numy = get(handles.edit1,'string');
num2 = {numy};
namey = get(handles.edit2,'string');
name2 = {namey};
money = get(handles.edit3,'string');
% money2 = {money};
money2 = str2num(money);
len = size(txt,1)+1;
range = num2str(len);
if isempty(numy)==1
        msgbox('订单编号为空，请重新输入');
end
if isempty(namey)==1
    msgbox('客户姓名为空，请重新输入');
end
if isempty(money)==1
    msgbox('金额为空，请重新输入');
end
if isempty(numy)==0 && isempty(namey)==0 && isempty(money2)==0
    xlswrite('YH.xlsx',num2,'sheet1',['B',range]);
    xlswrite('YH.xlsx',name2,'sheet1',['A',range]);
    xlswrite('YH.xlsx',money2,'sheet1',['C',range]);
    msgbox('插入成功');
end

完整代码（冗长可略过）：

function varargout = Test(varargin)
% TEST MATLAB code for Test.fig
%      TEST, by itself, creates a new TEST or raises the existing
%      singleton*.
%
%      H = TEST returns the handle to a new TEST or the handle to
%      the existing singleton*.
%
%      TEST('CALLBACK',hObject,eventData,handles,...) calls the local
%      function named CALLBACK in TEST.M with the given input arguments.
%
%      TEST('Property','Value',...) creates a new TEST or raises the
%      existing singleton*.  Starting from the left, property value pairs are
%      applied to the GUI before Test_OpeningFcn gets called.  An
%      unrecognized property name or invalid value makes property application
%      stop.  All inputs are passed to Test_OpeningFcn via varargin.
%
%      *See GUI Options on GUIDE's Tools menu.  Choose "GUI allows only one
%      instance to run (singleton)".
%
% See also: GUIDE, GUIDATA, GUIHANDLES

% Edit the above text to modify the response to help Test

% Last Modified by GUIDE v2.5 22-Nov-2019 11:25:59

% Begin initialization code - DO NOT EDIT
gui_Singleton = 1;
gui_State = struct('gui_Name',       mfilename, ...
                   'gui_Singleton',  gui_Singleton, ...
                   'gui_OpeningFcn', @Test_OpeningFcn, ...
                   'gui_OutputFcn',  @Test_OutputFcn, ...
                   'gui_LayoutFcn',  [] , ...
                   'gui_Callback',   []);
if nargin && ischar(varargin{1})
    gui_State.gui_Callback = str2func(varargin{1});
end

if nargout
    [varargout{1:nargout}] = gui_mainfcn(gui_State, varargin{:});
else
    gui_mainfcn(gui_State, varargin{:});
end
% End initialization code - DO NOT EDIT


% --- Executes just before Test is made visible.
function Test_OpeningFcn(hObject, eventdata, handles, varargin)
% This function has no output args, see OutputFcn.
% hObject    handle to figure
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
% varargin   command line arguments to Test (see VARARGIN)

% Choose default command line output for Test
handles.output = hObject;

% Update handles structure
guidata(hObject, handles);

% UIWAIT makes Test wait for user response (see UIRESUME)
% uiwait(handles.figure1);


% --- Outputs from this function are returned to the command line.
function varargout = Test_OutputFcn(hObject, eventdata, handles) 
% varargout  cell array for returning output args (see VARARGOUT);
% hObject    handle to figure
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

% Get default command line output from handles structure
varargout{1} = handles.output;



function edit1_Callback(hObject, eventdata, handles)
% hObject    handle to edit1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

% Hints: get(hObject,'String') returns contents of edit1 as text
%        str2double(get(hObject,'String')) returns contents of edit1 as a double


% --- Executes during object creation, after setting all properties.
function edit1_CreateFcn(hObject, eventdata, handles)
% hObject    handle to edit1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    empty - handles not created until after all CreateFcns called

% Hint: edit controls usually have a white background on Windows.
%       See ISPC and COMPUTER.
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
    set(hObject,'BackgroundColor','white');
end



function edit2_Callback(hObject, eventdata, handles)
% hObject    handle to edit2 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

% Hints: get(hObject,'String') returns contents of edit2 as text
%        str2double(get(hObject,'String')) returns contents of edit2 as a double


% --- Executes during object creation, after setting all properties.
function edit2_CreateFcn(hObject, eventdata, handles)
% hObject    handle to edit2 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    empty - handles not created until after all CreateFcns called

% Hint: edit controls usually have a white background on Windows.
%       See ISPC and COMPUTER.
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
    set(hObject,'BackgroundColor','white');
end


% --- Executes on button press in pushbutton1.
function pushbutton1_Callback(hObject, eventdata, handles)
% hObject    handle to pushbutton1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
global num txt
[num,txt] = xlsread('YH.xlsx');
numy = get(handles.edit1,'string');
num2 = {numy};
namey = get(handles.edit2,'string');
name2 = {namey};
money = get(handles.edit3,'string');
% money2 = {money};
money2 = str2num(money);
len = size(txt,1)+1;
range = num2str(len);
if isempty(numy)==1
        msgbox('订单编号为空，请重新输入');
end
if isempty(namey)==1
    msgbox('客户姓名为空，请重新输入');
end
if isempty(money)==1
    msgbox('金额为空，请重新输入');
end
if isempty(numy)==0 && isempty(namey)==0 && isempty(money2)==0
    xlswrite('YH.xlsx',num2,'sheet1',['B',range]);
    xlswrite('YH.xlsx',name2,'sheet1',['A',range]);
    xlswrite('YH.xlsx',money2,'sheet1',['C',range]);
    msgbox('插入成功');
end


% --- Executes on button press in pushbutton2.
function pushbutton2_Callback(hObject, eventdata, handles)
% hObject    handle to pushbutton2 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
a1 = get(handles.edit1,'string');
set(handles.edit2,'string',strcat('def',a1));



function edit3_Callback(hObject, eventdata, handles)
% hObject    handle to edit3 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

% Hints: get(hObject,'String') returns contents of edit3 as text
%        str2double(get(hObject,'String')) returns contents of edit3 as a double


% --- Executes during object creation, after setting all properties.
function edit3_CreateFcn(hObject, eventdata, handles)
% hObject    handle to edit3 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    empty - handles not created until after all CreateFcns called

% Hint: edit controls usually have a white background on Windows.
%       See ISPC and COMPUTER.
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
    set(hObject,'BackgroundColor','white');
end


% --------------------------------------------------------------------
function file_Callback(hObject, eventdata, handles)
% hObject    handle to file (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function edit_Callback(hObject, eventdata, handles)
% hObject    handle to edit (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function tools_Callback(hObject, eventdata, handles)
% hObject    handle to tools (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function help_Callback(hObject, eventdata, handles)
% hObject    handle to help (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function new_Callback(hObject, eventdata, handles)
% hObject    handle to new (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function open_Callback(hObject, eventdata, handles)
% hObject    handle to open (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function save_Callback(hObject, eventdata, handles)
% hObject    handle to save (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function Untitled_8_Callback(hObject, eventdata, handles)
% hObject    handle to Untitled_8 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)


% --------------------------------------------------------------------
function close_Callback(hObject, eventdata, handles)
% hObject    handle to close (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

【信息系统分析与设计】之Matlab设计信息系统

0.销售订单管理系统

0.1 功能：

0.2 数据库：

0.3 字段：

1.系统设计

1.1 查询订单页面

1.2 插入订单页面

1.3 订单统计页面

2.分析设计准备

2.1 如何实现系统功能

2.2 Matlab存取Excel文件数据

2.3 Matlab Graphics User Interface

练习

继续阅读

【重学Matlab】Note4 矩阵相关

Tkinter设置消息框、对话框

数学建模浅谈

建模：数学建模

数学建模——层次分析法（Matlab）【评价类问题】建立递阶层次结构构造判断矩阵一致性检验计算总权重并排序

数学建模智能优化算法之神经网络案例附Matlab代码

simulink bus总线创建方法

拉格朗日插值 matlab

Lagrange插值函数及其Matlab代码

使用自相关函数的纹理图像周期计算

2018年高教社杯A题高温作业专用服装设计

JDBC连接数据库（statement）

图像压缩编码码matlab实现——行程编码

【可靠性评估】电力系统可靠性评估matlab仿真1.软件版本2.本算法理论知识

MATLAB:非线性规划fmincon