📄 main.pas
字号:
unit main;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
StdCtrls, Menus, Db, DBTables, ExtCtrls, ComCtrls, ImgList, Grids,
DBGrids, Buttons, jpeg, printers, Qrctrls, QuickRpt,Shellapi, OutlookBtn;
type
Tmainfm = class(TForm)
Label1: TLabel;
Panel1: TPanel;
Panel2: TPanel;
TreeView1: TTreeView;
Notebook1: TNotebook;
ImageList1: TImageList;
Query1: TQuery;
DataSource2: TDataSource;
DataSource1: TDataSource;
Query2: TQuery;
Panel9: TPanel;
SpeedButton9: TSpeedButton;
SpeedButton10: TSpeedButton;
SpeedButton11: TSpeedButton;
SpeedButton13: TSpeedButton;
Table1: TTable;
Table1ijCode: TIntegerField;
Table1Msum: TFloatField;
Table1Mcashsum: TFloatField;
Table1Mbillsum: TFloatField;
Table1Mcardsum: TFloatField;
Table1Mothsum: TFloatField;
Table1Ibillnum: TSmallintField;
Table1Icardnum: TSmallintField;
Table1Iothnum: TSmallintField;
Table1Ipart: TSmallintField;
Table1Cpname: TStringField;
Table1Dptime: TDateTimeField;
Table1Crname: TStringField;
Table1Drtime: TDateTimeField;
Table1Cmemo: TStringField;
Query5: TQuery;
DataSource5: TDataSource;
Query3: TQuery;
DataSource3: TDataSource;
Table2: TTable;
DataSource4: TDataSource;
Query4: TQuery;
Panel15: TPanel;
Bevel4: TBevel;
Label18: TLabel;
Image6: TImage;
Label20: TLabel;
Label21: TLabel;
Panel17: TPanel;
Bevel5: TBevel;
Label24: TLabel;
Label25: TLabel;
Image7: TImage;
Label26: TLabel;
Label27: TLabel;
Panel18: TPanel;
DBGrid5: TDBGrid;
Panel19: TPanel;
Bevel6: TBevel;
Label28: TLabel;
Label29: TLabel;
Image8: TImage;
Label30: TLabel;
Label31: TLabel;
Panel20: TPanel;
Panel21: TPanel;
Bevel7: TBevel;
Label32: TLabel;
Label33: TLabel;
Image9: TImage;
Label34: TLabel;
Label35: TLabel;
Panel22: TPanel;
Bevel8: TBevel;
Label36: TLabel;
Label37: TLabel;
Image10: TImage;
Label38: TLabel;
Label39: TLabel;
Panel23: TPanel;
Bevel9: TBevel;
Label40: TLabel;
Label41: TLabel;
Image11: TImage;
Label42: TLabel;
Label43: TLabel;
dbgdepappend: TDBGrid;
Panel24: TPanel;
DBGrid6: TDBGrid;
Panel25: TPanel;
DBGrid7: TDBGrid;
Label44: TLabel;
Label49: TLabel;
Panel26: TPanel;
DBGrid8: TDBGrid;
Panel27: TPanel;
SpeedButton20: TSpeedButton;
Panel28: TPanel;
sbutchanges: TSpeedButton;
Panel29: TPanel;
sbutchange: TSpeedButton;
Panel31: TPanel;
Edit34: TEdit;
SpeedButton26: TSpeedButton;
Querygoodsflow: TQuery;
dsgoodsflow: TDataSource;
Panel30: TPanel;
dsgoodsquery: TDataSource;
Label45: TLabel;
Edit20: TEdit;
Edit21: TEdit;
Label46: TLabel;
Label47: TLabel;
Edit22: TEdit;
Label48: TLabel;
Edit23: TEdit;
Label50: TLabel;
Label51: TLabel;
Edit25: TEdit;
Label52: TLabel;
Edit26: TEdit;
Label53: TLabel;
Edit27: TEdit;
Label54: TLabel;
Edit28: TEdit;
Edit30: TEdit;
Label62: TLabel;
DateTimePicker5: TDateTimePicker;
Label63: TLabel;
Edit31: TEdit;
SpeedButton22: TSpeedButton;
GroupBox6: TGroupBox;
RadioButton7: TRadioButton;
RadioButton8: TRadioButton;
Edit24: TEdit;
SpeedButton23: TSpeedButton;
SpeedButton24: TSpeedButton;
Panel16: TPanel;
tmpQuery: TQuery;
tabdepappend: TTable;
dasdepappend: TDataSource;
Table3: TTable;
DataSource6: TDataSource;
tabdepback: TTable;
dasdepback: TDataSource;
tabdelgoods: TTable;
dsdelgoods: TDataSource;
Querygoodsquery: TQuery;
GroupBox7: TGroupBox;
Edit29: TEdit;
GroupBox8: TGroupBox;
DateTimePicker6: TDateTimePicker;
Query1ijCode: TIntegerField;
Query1Msum: TFloatField;
Query1Mcashsum: TFloatField;
Query1Mbillsum: TFloatField;
Query1Mcardsum: TFloatField;
Query1Mothsum: TFloatField;
Query1Ipart: TStringField;
Query1Cpname: TStringField;
Query1Dptime: TDateTimeField;
Query1Crname: TStringField;
Query1Drtime: TDateTimeField;
Query1Cmemo: TStringField;
Query2izCode: TIntegerField;
Query2ijcode: TIntegerField;
Query2igoods: TIntegerField;
Query2Msum: TFloatField;
Query2Mcashsum: TFloatField;
Query2Mbillsum: TFloatField;
Query2Mcardsum: TFloatField;
Query2Mothsum: TFloatField;
Query2Isource: TSmallintField;
Query2Caim: TStringField;
Query2Ireason: TSmallintField;
Query2Iinhand: TSmallintField;
Query2Cpname: TStringField;
Query2Dptime: TDateTimeField;
Query2Crname: TStringField;
Query2Drtime: TDateTimeField;
Query2Cmemo: TStringField;
Query3izCode: TIntegerField;
Query3ijcode: TIntegerField;
Query3igoods: TIntegerField;
Query3Msum: TFloatField;
Query3Mcashsum: TFloatField;
Query3Mbillsum: TFloatField;
Query3Mcardsum: TFloatField;
Query3Mothsum: TFloatField;
Query3Isource: TSmallintField;
Query3Caim: TStringField;
Query3Ireason: TSmallintField;
Query3Iinhand: TSmallintField;
Query3Cpname: TStringField;
Query3Dptime: TDateTimeField;
Query3Crname: TStringField;
Query3Drtime: TDateTimeField;
Query3Cmemo: TStringField;
Table2izCode: TIntegerField;
Table2ijcode: TIntegerField;
Table2igoods: TIntegerField;
Table2Msum: TFloatField;
Table2Mcashsum: TFloatField;
Table2Mbillsum: TFloatField;
Table2Mcardsum: TFloatField;
Table2Mothsum: TFloatField;
Table2Isource: TSmallintField;
Table2Caim: TStringField;
Table2Ireason: TSmallintField;
Table2Iinhand: TSmallintField;
Table2Cpname: TStringField;
Table2Dptime: TDateTimeField;
Table2Crname: TStringField;
Table2Drtime: TDateTimeField;
Table2Cmemo: TStringField;
Table2resum: TFloatField;
Splitter2: TSplitter;
Splitter1: TSplitter;
DayrepDataSource: TDataSource;
Dayreptab: TTable;
Table4: TTable;
Queryrefresh: TQuery;
DataSource7: TDataSource;
DBGrid11: TDBGrid;
Querysupplier: TQuery;
dssupplier: TDataSource;
SpeedButton21: TSpeedButton;
SpeedButton34: TSpeedButton;
SpeedButton33: TSpeedButton;
SpeedButton35: TSpeedButton;
Database1: TDatabase;
Sbstorquery: TSpeedButton;
Label2: TLabel;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
sbstoreoutquery: TSpeedButton;
sbpurchquery: TSpeedButton;
DBGrid1: TDBGrid;
Edit1: TEdit;
Edit2: TEdit;
Edit3: TEdit;
Edit4: TEdit;
DataSource8: TDataSource;
Querystorequery: TQuery;
OutlookBtn1: TOutlookBtn;
DBGrid2: TDBGrid;
Querystory: TQuery;
DataSource9: TDataSource;
SpeedButton1: TSpeedButton;
DBGrid3: TDBGrid;
QuerySell: TQuery;
DataSource10: TDataSource;
Image1: TImage;
Label6: TLabel;
edchukudanhao: TEdit;
Panel3: TPanel;
Label7: TLabel;
Edit5: TEdit;
Label8: TLabel;
Label9: TLabel;
Label10: TLabel;
Edit6: TEdit;
Edit7: TEdit;
Edit8: TEdit;
GroupBox1: TGroupBox;
SpeedButton2: TSpeedButton;
SpeedButton3: TSpeedButton;
SpeedButton4: TSpeedButton;
SpeedButton5: TSpeedButton;
DBGrid4: TDBGrid;
DataSource11: TDataSource;
StockQuery: TQuery;
TempQuery: TQuery;
Query: TQuery;
Label11: TLabel;
ComboBoxdep: TComboBox;
editsup: TEdit;
Label12: TLabel;
editname: TEdit;
Label13: TLabel;
Label14: TLabel;
editcode: TEdit;
BitBtn1: TBitBtn;
Label15: TLabel;
ComboBox1: TComboBox;
Label16: TLabel;
Label17: TLabel;
Edit9: TEdit;
Label19: TLabel;
Edit10: TEdit;
Edit11: TEdit;
BitBtn2: TBitBtn;
Label22: TLabel;
Label23: TLabel;
Edit12: TEdit;
Edit13: TEdit;
BitBtn3: TBitBtn;
Label55: TLabel;
Label56: TLabel;
Label57: TLabel;
Label58: TLabel;
Edit14: TEdit;
Edit15: TEdit;
Edit16: TEdit;
ComboBox2: TComboBox;
BitBtn4: TBitBtn;
GroupBox2: TGroupBox;
Edit17: TEdit;
Edit18: TEdit;
Label59: TLabel;
Label60: TLabel;
Edit19: TEdit;
SButxianjinjinhuo: TSpeedButton;
procedure TreeView1Change(Sender: TObject; Node: TTreeNode);
procedure RadioButton7Click(Sender: TObject);
procedure RadioButton8Click(Sender: TObject);
procedure sbutchangeposClick(Sender: TObject);
procedure SpeedButton20Click(Sender: TObject);
procedure SpeedButton3Click(Sender: TObject);
procedure SpeedButton5Click(Sender: TObject);
procedure DBGrid2KeyDown(Sender: TObject; var Key: Word;
Shift: TShiftState);
procedure SpeedButton13Click(Sender: TObject);
procedure TreeView1Click(Sender: TObject);
procedure SpeedButton12Click(Sender: TObject);
procedure Table2CalcFields(DataSet: TDataSet);
procedure FormCreate(Sender: TObject);
procedure SpeedButton26Click(Sender: TObject);
procedure sbutchangesClick(Sender: TObject);
procedure sbutchangeClick(Sender: TObject);
procedure SpeedButton22Click(Sender: TObject);
procedure SpeedButton23Click(Sender: TObject);
procedure SpeedButton2Click(Sender: TObject);
procedure SpeedButton7Click(Sender: TObject);
procedure SpeedButton9Click(Sender: TObject);
procedure SpeedButton21Click(Sender: TObject);
procedure SpeedButton25Click(Sender: TObject);
procedure SpeedButton27Click(Sender: TObject);
procedure SpeedButton28Click(Sender: TObject);
procedure SpeedButton29Click(Sender: TObject);
procedure SbutrefreshClick(Sender: TObject);
procedure SpeedButton32Click(Sender: TObject);
procedure SpeedButton30Click(Sender: TObject);
procedure SpeedButton34Click(Sender: TObject);
procedure SpeedButton35Click(Sender: TObject);
procedure SpeedButton33Click(Sender: TObject);
procedure SpeedButton10Click(Sender: TObject);
procedure SpeedButton11Click(Sender: TObject);
procedure SbstorqueryClick(Sender: TObject);
procedure sbstoreoutqueryClick(Sender: TObject);
procedure sbpurchqueryClick(Sender: TObject);
procedure OutlookBtn1Click(Sender: TObject);
procedure SpeedButton1Click(Sender: TObject);
procedure SpeedButton4Click(Sender: TObject);
function checkpass(code:string;promiseright:integer; var soperator:string):integer;
procedure BitBtn1Click(Sender: TObject);
procedure BitBtn2Click(Sender: TObject);
procedure BitBtn3Click(Sender: TObject);
procedure BitBtn4Click(Sender: TObject);
procedure SButxianjinjinhuoClick(Sender: TObject);
private
{ Private declarations }
public
tempint,shenheint: integer;
tmpsqls,tmpchangjia:string;
flag1:integer;
selecttabname,selectname:string;
operator: array [1..100] of string[10];
operatorcode:array[1..100] of string[10];
operatorright:array[1..100] of integer;
tmpqueryspe2,tmpqueryspe1,tmpqueryspe : tquery;
{ Public declarations }
end;
var
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -