unitinoutdjqry.pas

仓储系统

{$A+,B-,C+,D+,E-,F-,G+,H+,I+,J-,K-,L+,M-,N+,O+,P+,Q-,R-,S-,T-,U-,V+,W-,X+,Y+,Z1}
{$MINSTACKSIZE $00004000}
{$MAXSTACKSIZE $00100000}
{$IMAGEBASE $00400000}
{$APPTYPE GUI}
unit UnitInOutDjQry;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, Grids, DBGrids, RXCtrls, ComCtrls, ExtCtrls,
  ImgList, DBTables, DB, ADODB, CurrEdit, Mask, ToolEdit, Menus, CheckLst;

type
  TfrmInOutDjQry = class(TForm)
    qry_1: TADOQuery;
    ds_1: TDataSource;
    qry_2: TADOQuery;
    ds_2: TDataSource;
    ds_3: TDataSource;
    qry_3: TADOQuery;
    ds_4: TDataSource;
    qry_4: TADOQuery;
    qry_5: TADOQuery;
    ds_5: TDataSource;
    ds_6: TDataSource;
    qry_6: TADOQuery;
    qry_7: TADOQuery;
    ds_7: TDataSource;
    ImageList1: TImageList;
    Panel1: TPanel;
    PageControl1: TPageControl;
    TabSheetCg_1: TTabSheet;
    TabSheetZz_1: TTabSheet;
    TabSheetProductIn_1: TTabSheet;
    TabSheetTL_1: TTabSheet;
    TabSheetProductOut_1: TTabSheet;
    TabSheetLy_1: TTabSheet;
    TabSheetBf_1: TTabSheet;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    Panel3: TPanel;
    Panel16: TPanel;
    Label66: TLabel;
    CListBox1: TCheckListBox;
    Panel4: TPanel;
    Panel19: TPanel;
    Label67: TLabel;
    CListBox2: TCheckListBox;
    Panel18: TPanel;
    RxLabel6: TRxLabel;
    lbl_2: TRxLabel;
    DBGrid2: TDBGrid;
    Panel5: TPanel;
    Panel21: TPanel;
    Label68: TLabel;
    CListBox3: TCheckListBox;
    Panel20: TPanel;
    RxLabel9: TRxLabel;
    lbl_3: TRxLabel;
    DBGrid3: TDBGrid;
    Panel8: TPanel;
    Panel23: TPanel;
    Label69: TLabel;
    CListBox4: TCheckListBox;
    Panel22: TPanel;
    RxLabel11: TRxLabel;
    lbl_4: TRxLabel;
    DBGrid4: TDBGrid;
    Panel9: TPanel;
    Panel25: TPanel;
    Label70: TLabel;
    CListBox5: TCheckListBox;
    Panel24: TPanel;
    RxLabel13: TRxLabel;
    lbl_5: TRxLabel;
    DBGrid5: TDBGrid;
    Panel10: TPanel;
    Panel27: TPanel;
    Label71: TLabel;
    CListBox6: TCheckListBox;
    Panel26: TPanel;
    RxLabel15: TRxLabel;
    lbl_6: TRxLabel;
    DBGrid6: TDBGrid;
    Panel11: TPanel;
    Panel29: TPanel;
    Label72: TLabel;
    CListBox7: TCheckListBox;
    Panel28: TPanel;
    RxLabel17: TRxLabel;
    lbl_7: TRxLabel;
    DBGrid7: TDBGrid;
    Panel17: TPanel;
    RxLabel7: TRxLabel;
    lbl_1: TRxLabel;
    DBGrid1: TDBGrid;
    PageControl2: TPageControl;
    TabSheetCg: TTabSheet;
    lblRkdh: TLabel;
    lblHtdh: TLabel;
    lblJhbh: TLabel;
    lblBm: TLabel;
    lblWlmc: TLabel;
    lblDj: TLabel;
    lblNum: TLabel;
    Label3: TLabel;
    lblJsr: TLabel;
    lblJyr: TLabel;
    lblType: TLabel;
    lblIn_date: TLabel;
    Label74: TLabel;
    Label75: TLabel;
    Label76: TLabel;
    edtRkdh: TEdit;
    edtHtbh: TEdit;
    edtJhbh: TEdit;
    edtWlbm: TEdit;
    edtWlmc: TEdit;
    edtJsr: TEdit;
    edtJyr: TEdit;
    edtType: TEdit;
    Panel2: TPanel;
    BitBtnCg: TBitBtn;
    BitBtnPrint1: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn20: TBitBtn;
    meStart_1: TMaskEdit;
    edtNum: TEdit;
    edtPrice: TEdit;
    edtTotalPrice: TEdit;
    meEnd_1: TMaskEdit;
    edtZdr_1: TEdit;
    cbbLb_1: TComboBox;
    TabSheetZz: TTabSheet;
    Label1: TLabel;
    Label2: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label77: TLabel;
    Label78: TLabel;
    Label79: TLabel;
    edtRkdh_2: TEdit;
    edtHtbh_2: TEdit;
    edtJhbh_2: TEdit;
    edtNum_2: TEdit;
    edtPrice_2: TEdit;
    edtTotalPrice_2: TEdit;
    edtWlbm_2: TEdit;
    edtWlmc_2: TEdit;
    edtType_2: TEdit;
    meStart_2: TMaskEdit;
    edtJsr_2: TEdit;
    edtJyr_2: TEdit;
    Panel6: TPanel;
    BitBtnZz: TBitBtn;
    BitBtnPrint2: TBitBtn;
    BitBtn21: TBitBtn;
    BitBtn22: TBitBtn;
    edtZdr_2: TEdit;
    meEnd_2: TMaskEdit;
    cbbLb_2: TComboBox;
    TabSheetProductIn: TTabSheet;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    lblPrice: TLabel;
    lblTotalPrice: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    lblZdr: TLabel;
    Label80: TLabel;
    Label81: TLabel;
    edtRkdh_3: TEdit;
    edtJhbh_3: TEdit;
    edtNum_3: TEdit;
    edtPrice_3: TEdit;
    edtTotalPrice_3: TEdit;
    edtWlbm_3: TEdit;
    edtWlmc_3: TEdit;
    edtType_3: TEdit;
    meStart_3: TMaskEdit;
    edtJsr_3: TEdit;
    edtJyr_3: TEdit;
    edtzdr_3: TEdit;
    Panel7: TPanel;
    BitBtnProductIn: TBitBtn;
    BitBtnPrint3: TBitBtn;
    BitBtn7: TBitBtn;
    BitBtn23: TBitBtn;
    meEnd_3: TMaskEdit;
    cbbLb_3: TComboBox;
    TabSheetTL: TTabSheet;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    Label26: TLabel;
    Label27: TLabel;
    Label28: TLabel;
    Label29: TLabel;
    Label30: TLabel;
    Label34: TLabel;
    Label35: TLabel;
    lblAudit: TLabel;
    Label31: TLabel;
    Label82: TLabel;
    Label83: TLabel;
    Label84: TLabel;
    edtRkdh_4: TEdit;
    edtJhbh_4: TEdit;
    edtNum_4: TEdit;
    edtPrice_4: TEdit;
    edtTotalPrice_4: TEdit;
    edtWlbm_4: TEdit;
    edtWlmc_4: TEdit;
    edtType_4: TEdit;
    edtJsr_4: TEdit;
    edtJyr_4: TEdit;
    edtAudit_4: TEdit;
    meStart_4: TMaskEdit;
    Panel12: TPanel;
    BitBtnTL: TBitBtn;
    BitBtnPrint4: TBitBtn;
    BitBtn10: TBitBtn;
    BitBtn24: TBitBtn;
    edtZdr_4: TEdit;
    meEnd_4: TMaskEdit;
    cbbLb_4: TComboBox;
    TabSheetProductOut: TTabSheet;
    Label32: TLabel;
    Label33: TLabel;
    Label36: TLabel;
    Label37: TLabel;
    Label38: TLabel;
    Label39: TLabel;
    Label40: TLabel;
    Label41: TLabel;
    Label42: TLabel;
    Label43: TLabel;
    Label44: TLabel;
    Label45: TLabel;
    Label73: TLabel;
    Label85: TLabel;
    edtCkdh_5: TEdit;
    edtJhbh_5: TEdit;
    edtNum_5: TEdit;
    edtPrice_5: TEdit;
    edtTotalPrice_5: TEdit;
    edtWlbm_5: TEdit;
    edtWlmc_5: TEdit;
    edtType_5: TEdit;
    edtJsr_5: TEdit;
    edtJyr_5: TEdit;
    edtZdr_5: TEdit;
    meStart_5: TMaskEdit;
    Panel13: TPanel;
    BitBtnProductOut: TBitBtn;
    BitBtnPrint5: TBitBtn;
    BitBtn13: TBitBtn;
    BitBtn25: TBitBtn;
    meEnd_5: TMaskEdit;
    cbbLb_5: TComboBox;
    TabSheetLy: TTabSheet;
    lblCkdh: TLabel;
    Label46: TLabel;
    Label47: TLabel;
    Label48: TLabel;
    Label49: TLabel;
    Label50: TLabel;
    Label51: TLabel;
    Label52: TLabel;
    Label53: TLabel;
    Label54: TLabel;
    Label55: TLabel;
    lblLy_date: TLabel;
    Label86: TLabel;
    Label87: TLabel;
    edtCkdh_6: TEdit;
    edtJhbh_6: TEdit;
    edtNum_6: TEdit;
    edtPrice_6: TEdit;
    edtTotalPrice_6: TEdit;
    edtWlbm_6: TEdit;
    edtWlmc_6: TEdit;
    edtType_6: TEdit;
    edtJsr_6: TEdit;
    edtJyr_6: TEdit;
    edtZdr_6: TEdit;
    meStart_6: TMaskEdit;
    Panel14: TPanel;
    BitBtnLy: TBitBtn;
    BitBtnPrint6: TBitBtn;
    BitBtn16: TBitBtn;
    BitBtn26: TBitBtn;
    meEnd_6: TMaskEdit;
    cbbLb_6: TComboBox;
    TabSheetBf: TTabSheet;
    lblBfdh: TLabel;
    Label56: TLabel;
    Label57: TLabel;
    Label58: TLabel;
    Label59: TLabel;
    Label60: TLabel;
    Label61: TLabel;
    Label62: TLabel;
    Label63: TLabel;
    Label64: TLabel;
    Label65: TLabel;
    lblBf_date: TLabel;
    Label88: TLabel;
    Label89: TLabel;
    Label90: TLabel;
    edtCkdh_7: TEdit;
    edtJhbh_7: TEdit;
    edtNum_7: TEdit;
    edtPrice_7: TEdit;
    edtTotalPrice_7: TEdit;
    edtWlbm_7: TEdit;
    edtWlmc_7: TEdit;
    edtType_7: TEdit;
    edtJyr_7: TEdit;
    edtZdr_7: TEdit;
    edtSpr_7: TEdit;
    meStart_7: TMaskEdit;
    Panel15: TPanel;
    BitBtnBf: TBitBtn;
    BitBtnPrint7: TBitBtn;
    BitBtn19: TBitBtn;
    BitBtn27: TBitBtn;
    meEnd_7: TMaskEdit;
    Edit11: TEdit;
    cbbLb_7: TComboBox;
    procedure Print(temp:string;query:Tquery;my:Tobject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Clear(form:TForm);
    procedure BitBtnCgClick(Sender: TObject);
    procedure meStart_1Exit(Sender: TObject);
    procedure BitBtn20Click(Sender: TObject);
    procedure BitBtnZzClick(Sender: TObject);
    procedure meStart_2Exit(Sender: TObject);
    procedure BitBtnProductInClick(Sender: TObject);
    procedure meStart_3Exit(Sender: TObject);
    procedure PageControl2Change(Sender: TObject);
    procedure BitBtnTLClick(Sender: TObject);
    procedure BitBtnProductOutClick(Sender: TObject);
    procedure BitBtnLyClick(Sender: TObject);
    procedure BitBtnBfClick(Sender: TObject);
    procedure meStart_4Exit(Sender: TObject);
    procedure meStart_5Exit(Sender: TObject);
    procedure meStart_6Exit(Sender: TObject);
    procedure meStart_7Exit(Sender: TObject);
    procedure BitBtnPrint1Click(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure BitBtnPrint2Click(Sender: TObject);
    procedure BitBtnPrint3Click(Sender: TObject);
    procedure BitBtnPrint4Click(Sender: TObject);
    procedure BitBtnPrint5Click(Sender: TObject);
    procedure BitBtnPrint6Click(Sender: TObject);
    procedure BitBtnPrint7Click(Sender: TObject);
    procedure edtRkdhKeyPrss(Sender: TObject; var Key: Char);
    procedure edtzdr_3KeyPress(Sender: TObject; var Key: Char);
    procedure edtJyr_4KeyPress(Sender: TObject; var Key: Char);
    procedure edtZdr_5KeyPress(Sender: TObject; var Key: Char);
    procedure edtZdr_6KeyPress(Sender: TObject; var Key: Char);
    procedure edtZdr_7KeyPress(Sender: TObject; var Key: Char);
    procedure FormCreate(Sender: TObject);
    procedure DBGrid1KeyPress(Sender: TObject; var Key: Char);
    procedure CListBox1Exit(Sender: TObject);
    procedure CListBox1ClickCheck(Sender: TObject);
    procedure CListBox2Exit(Sender: TObject);
    procedure CListBox2ClickCheck(Sender: TObject);
    procedure CListBox7Exit(Sender: TObject);
    procedure CListBox3Exit(Sender: TObject);
    procedure CListBox4Exit(Sender: TObject);
    procedure CListBox5Exit(Sender: TObject);
    procedure CListBox6Exit(Sender: TObject);
    procedure CListBox3ClickCheck(Sender: TObject);
    procedure CListBox4ClickCheck(Sender: TObject);
    procedure CListBox5ClickCheck(Sender: TObject);
    procedure CListBox6ClickCheck(Sender: TObject);
    procedure CListBox7ClickCheck(Sender: TObject);
    procedure meEnd_1Exit(Sender: TObject);
    procedure edtZdr_1KeyPress(Sender: TObject; var Key: Char);
    procedure meEnd_2Exit(Sender: TObject);
    procedure meEnd_3Exit(Sender: TObject);
    procedure meEnd_4Exit(Sender: TObject);
    procedure meEnd_5Exit(Sender: TObject);
    procedure meEnd_6Exit(Sender: TObject);
    procedure meEnd_7Exit(Sender: TObject);
    procedure edtZdr_2KeyPress(Sender: TObject; var Key: Char);
    procedure edtZdr_4KeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn22Click(Sender: TObject);
    procedure BitBtn23Click(Sender: TObject);
    procedure BitBtn24Click(Sender: TObject);
    procedure BitBtn25Click(Sender: TObject);
    procedure BitBtn26Click(Sender: TObject);
    procedure BitBtn27Click(Sender: TObject);
    procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure DBGrid2DrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
    procedure DBGrid3DrawColumnCell(Sender: TObject; const Rect: TRect;