bjsj_un.dfm

手机进销存系统Delphi源码,管理手机的进货还有销售方面的功能

      DefaultFont.Name = 'Arial'
      DefaultFont.Style = []
      DefaultWidth = 0
      DefaultHeight = 20
      ButtonMode = True
      SkinData = bsSkinData1
      SkinDataName = 'buttonedit'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = 14
      Font.Name = 'Arial'
      Font.Style = []
      MaxLength = 10
      ParentFont = False
      TabOrder = 1
    end
    object bsSkinDBLookupComboBox4: TbsSkinDBLookupComboBox
      Left = 312
      Top = 53
      Width = 73
      Height = 20
      TabOrder = 2
      SkinData = bsSkinData1
      SkinDataName = 'combobox'
      DefaultFont.Charset = DEFAULT_CHARSET
      DefaultFont.Color = clWindowText
      DefaultFont.Height = 14
      DefaultFont.Name = 'Arial'
      DefaultFont.Style = []
      DefaultWidth = 0
      DefaultHeight = 20
      UseSkinFont = True
      ListBoxDefaultItemHeight = 20
      ListBoxUseSkinFont = True
      ListBoxUseSkinItemHeight = True
      KeyField = 'fid'
      ListField = 'fna'
      ListSource = ds_sjcs
    end
    object bsSkinDBLookupComboBox3: TbsSkinDBLookupComboBox
      Left = 312
      Top = 81
      Width = 73
      Height = 20
      TabOrder = 3
      SkinData = bsSkinData1
      SkinDataName = 'combobox'
      DefaultFont.Charset = DEFAULT_CHARSET
      DefaultFont.Color = clWindowText
      DefaultFont.Height = 14
      DefaultFont.Name = 'Arial'
      DefaultFont.Style = []
      DefaultWidth = 0
      DefaultHeight = 20
      UseSkinFont = True
      ListBoxDefaultItemHeight = 20
      ListBoxUseSkinFont = True
      ListBoxUseSkinItemHeight = True
      KeyField = 'fid'
      ListField = 'fmodel'
      ListSource = ds_sjxh
    end
  end
  inherited bsBusinessSkinForm1: TbsBusinessSkinForm
    Left = 440
  end
  inherited bsSkinData1: TbsSkinData
    Left = 472
  end
  inherited ALToolbar: TActionList
    Left = 408
    Top = 8
  end
  inherited spsave: TADOStoredProc
    ProcedureName = 'pSjbjAct;1'
    Parameters = <
      item
        Name = '@RETURN_VALUE'
        DataType = ftInteger
        Direction = pdReturnValue
        Precision = 10
      end
      item
        Name = '@val'
        Attributes = [paNullable]
        DataType = ftBCD
        Precision = 19
      end
      item
        Name = '@ffdate'
        Attributes = [paNullable]
        DataType = ftDateTime
      end
      item
        Name = '@fedate'
        Attributes = [paNullable]
        DataType = ftDateTime
      end
      item
        Name = '@fadate'
        Attributes = [paNullable]
        DataType = ftDateTime
      end
      item
        Name = '@fsjxh'
        Attributes = [paNullable]
        DataType = ftString
        Size = 5
      end>
    Left = 368
    Top = 216
  end
  inherited spdisp: TADOStoredProc
    CursorType = ctStatic
    AfterOpen = spdispAfterOpen
    ProcedureName = 'pViewAllBjSj;1'
    Parameters = <
      item
        Name = '@RETURN_VALUE'
        DataType = ftInteger
        Direction = pdReturnValue
        Precision = 10
        Value = 0
      end
      item
        Name = '@act'
        Attributes = [paNullable]
        DataType = ftInteger
        Precision = 10
        Value = Null
      end
      item
        Name = '@id'
        Attributes = [paNullable]
        DataType = ftString
        Size = 12
        Value = Null
      end>
    Left = 176
    Top = 224
  end
  inherited ds_disp: TDataSource
    Left = 136
    Top = 224
  end
  object sp_search: TADOStoredProc
    Connection = dm.ADOConnection1
    ProcedureName = 'pSearchAllBjSj;1'
    Parameters = <
      item
        Name = '@RETURN_VALUE'
        DataType = ftInteger
        Direction = pdReturnValue
        Precision = 10
        Value = Null
      end
      item
        Name = '@fdate'
        Attributes = [paNullable]
        DataType = ftDateTime
        Value = Null
      end
      item
        Name = '@edate'
        Attributes = [paNullable]
        DataType = ftDateTime
        Value = Null
      end
      item
        Name = '@sjxh'
        Attributes = [paNullable]
        DataType = ftString
        Size = 5
        Value = Null
      end>
    Left = 240
    Top = 56
  end
  object ds_search: TDataSource
    DataSet = sp_search
    OnStateChange = ds_dispStateChange
    OnDataChange = ds_dispDataChange
    Left = 200
    Top = 56
  end
  object ds_sjxh: TDataSource
    DataSet = tbl_sjxh
    Left = 384
    Top = 73
  end
  object ds_sjcs: TDataSource
    DataSet = tbl_sjcs
    Left = 384
    Top = 41
  end
  object tbl_sjcs: TADOQuery
    Connection = dm.ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from tsjcs'
      'where tsjcs.fuse='#39'T'#39)
    Left = 424
    Top = 41
  end
  object tbl_sjxh: TADOTable
    Connection = dm.ADOConnection1
    IndexFieldNames = 'fsjcs'
    MasterFields = 'fid'
    MasterSource = ds_sjcs
    TableName = 'tsjxh'
    Left = 424
    Top = 73
  end
  object RMReport1: TRMReport
    SaveReportOptions.UseRegistry = True
    SaveReportOptions.RegistryPath = 'ReportMachine\ReportSettings\'
    InitialZoom = pzDefault
    ModifyPrepared = False
    PreviewButtons = [pbZoom, pbLoad, pbSave, pbPrint, pbFind, pbPageSetup, pbExit, pbSaveToXLS]
    StoreInDFM = True
    Left = 97
    Top = 319
    ReportForm = {
      2B000000211000002B000B1A005265706F72744D616368696E65205265706F72
      742046696C651A00010000000000000000000000000000000000000000000000
      00000000000F0044656661756C74205072696E74657200FF000400466F726D00
      0500506167653100DC000000B40000007C0100002C0100000F0000FF03040900
      00005034030028880400983A0000204E0000983A0000204E0000000000000000
      0000000000FFFF000000000000A90000000000000000000000FFFFFFFFFFFFFF
      FF0002004E0100000B0050616765466F6F74657231000A000000000002040000
      1A03000012000000300400000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000003000200000002000000
      FFFFFF1F0000000000000000000000000000000000FFFF000000000000000014
      00000001000000C800000000000000000203000000000200E30100000C005265
      706F72745469746C6531000A00000000004C0000001A0300002A000000300400
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000200000002000000FFFFFF1F00000000000000
      00000000000000000000FFFF00000000000000001400000001000000C8000000
      00000000000203000000000200790200000D004D617374657248656164657231
      000A0000000000BD0000001A0300001200000030040000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0004000200000002000000FFFFFF1F0000000000000000000000000000000000
      FFFF00000000000000001400000001000000C800000000000000000203000000
      000200190300000B004D61737465724461746131000A0000000000ED0000001A
      0300001200000030040000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000005000200000002000000FF
      FFFF1F00000000000C00524D4442446174615365743100000000000000000000
      FFFF00000000000000001400000001000000C800000000000000000203000000
      000000D403000005004D656D6F33000A0C3F0000000204000060000000120000
      00480C00000000000000000000E8030000000000000000E80300000000000000
      00E8030000000000000000E803000000000200000002000000FFFFFF1F002E02
      000000000001001200CAD6BBFAD3AACFFACFB5CDB3B2E2CAD4B0E60000000000
      0000FFFF00000000000400CBCECCE50008000000000000000000000000008600
      020000000000FFFFFF0000000000000000020000000000000000000000009604
      000005004D656D6F36000A0CD7030000A60000009000000012000000480C0000
      0000000000000000E8030000000000000000E8030000000000000000E8030000
      000000000000E803000000000200000002000000FFFFFF1F002E020000000000
      01001900C8EDBCFED6A7B3D6B5E7BBB0A3BA3133303835343137373731000000
      00000000FFFF00000000000400CBCECCE5000800000000000000000000000000
      8600020000000000FFFFFF000000000000000002000000000000000000000000
      5805000005004D656D6F32000A0C780000004C0000001802000012000000400C
      00000000000000000000E8030000000000000000E8030000000000000000E803
      0000000000000000E803000000000200000002000000FFFFFF1F002E02000000
      0000010019005B736A78685D5B202B205DB1A3BCDBCAD6BBFAD0C5CFA2B1ED00
      000000000000FFFF00000000000400CBCECCE5000A0000000000000000000A00
      00008600020000000000FFFFFF00000000000000000200000000000000000000
      00001606000005004D656D6F34000A0C3C00000068000000980000000C000000
      480C00000000000000000000E8030000000000000000E8030000000000000000
      E8030000000000000000E803000000000200000002000000FFFFFF1F002E0200
      0000000001001500B4F2D3A1CAB1BCE4A3BA5B4461746554696D65235D000000
      00000000FFFF00000000000400C1A5CAE9000800000000000000000008000000
      8600020000000000FFFFFF000000000000000002000000000000000000000000
      C706000005004D656D6F35000A0C48000000BD0000007800000012000000400C
      00000000010000000000E8030000010000000000E8030000010000000000E803
      0000010000000000E803000000000200000002000000FFFFFF1F002E02000000
      000001000800CAD6BBFAB4AEBAC500000000000000FFFF00000000000400CBCE
      CCE5000A0000000000000000000A0000008600020000000000FFFFFF00000000
      00000000020000000000000000000000007807000005004D656D6F37000A0CC0
      000000BD0000004600000012000000400C00000000010000000000E803000001
      0000000000E8030000010000000000E8030000010000000000E8030000000002
      00000002000000FFFFFF1F002E02000000000001000800CAD6BBFAD1D5C9AB00
      000000000000FFFF00000000000400CBCECCE5000A0000000000000000000A00
      00008600020000000000FFFFFF00000000000000000200000000000000000000
      00002908000005004D656D6F38000A0C06010000BD0000004600000012000000
      400C00000000010000000000E8030000010000000000E8030000010000000000
      E8030000010000000000E803000000000200000002000000FFFFFF1F002E0200
      0000000001000800BBF9B1BEC5E4D6C300000000000000FFFF00000000000400
      CBCECCE5000A0000000000000000000A0000008600020000000000FFFFFF0000
      00000000000002000000000000000000000000DC08000005004D656D6F39000A
      0C1E020000BD000000AA00000012000000400C00000000010000000000E80300
      00010000000000E8030000010000000000E8030000010000000000E803000000
      000200000002000000FFFFFF1F002E02000000000001000A00B5B1C7B0CBF9D4
      DAB5D800000000000000FFFF00000000000400CBCECCE5000A00000000000000
      0000080000008600020000000000FFFFFF000000000000000002000000000000
      0000000000008E09000006004D656D6F3130000A0C4C010000BD000000460000
      0012000000400C00000000010000000000E8030000010000000000E803000001
      0000000000E8030000010000000000E803000000000200000002000000FFFFFF
      1F002E02000000000001000800BBF5D4B4C0E0D0CD00000000000000FFFF0000
      0000000400CBCECCE5000A0000000000000000000A0000008600020000000000
      FFFFFF000000000000000002000000000000000000000000470A000006004D65
      6D6F3131000A0C48000000ED0000007800000012000000400C00000000010000
      000000E8030000010000000000E8030000010000000000E80300000100000000
      00E803000000000200000002000000FFFFFF1F002E02000000000001000F005B
      7472696D285B22666E6F225D295D00000000000000FFFF00000000000400CBCE
      CCE5000A0000000000000000000A0000008600020000000000FFFFFF00000000
      0000000002000000000000000000000000030B000006004D656D6F3132000A0C
      C0000000ED0000004600000012000000400C00000000010000000000E8030000
      010000000000E8030000010000000000E8030000010000000000E80300000000
      0200000002000000FFFFFF1F002E020000000000010012005B7472696D285B22
      66636F6C6F72225D295D00000000000000FFFF00000000000400CBCECCE5000A
      0000000000000000000A0000008600020000000000FFFFFF0000000000000000
      02000000000000000000000000BE0B000006004D656D6F3133000A0C06010000
      ED0000004600000012000000400C00000000010000000000E803000001000000
      0000E8030000010000000000E8030000010000000000E8030000000002000000
      02000000FFFFFF1F002E020000000000010011005B7472696D285B22666A6270
      7A225D295D00000000000000FFFF00000000000400CBCECCE5000A0000000000
      000000000A0000008600020000000000FFFFFF00000000000000000200000000
      00000000000000007A0C000006004D656D6F3134000A0C92010000ED00000046
      00000012000000400C00000000010000000000E8030000010000000000E80300
      00010000000000E8030000010000000000E803000000000200000002000000FF
      FFFF1F002E020000000000010012005B7472696D285B22666A686D6F6E225D29
      5D00000000000000FFFF00000000000400CBCECCE5000A000000000000000000
      0A0000008600020000000000FFFFFF0000000000000000020000000000000000
      00000000350D000006004D656D6F3135000A0C4C010000ED0000004600000012
      000000400C00000000010000000000E8030000010000000000E8030000010000
      000000E8030000010000000000E803000000000200000002000000FFFFFF1F00
      2E020000000000010011005B7472696D285B226668796C78225D295D00000000
      000000FFFF00000000000400CBCECCE5000A0000000000000000000A00000086
      00020000000000FFFFFF000000000000000002000000000000000000000000E7
      0D000006004D656D6F3136000A0C92010000BD0000004600000012000000400C
      00000000010000000000E8030000010000000000E8030000010000000000E803
      0000010000000000E803000000000200000002000000FFFFFF1F002E02000000
      000001000800BDF8BBF5BCDBB8F100000000000000FFFF00000000000400CBCE
      CCE5000A0000000000000000000A0000008600020000000000FFFFFF00000000
      0000000002000000000000000000000000990E000006004D656D6F3137000A0C
      D8010000BD0000004600000012000000400C00000000010000000000E8030000
      010000000000E8030000010000000000E8030000010000000000E80300000000
      0200000002000000FFFFFF1F002E02000000000001000800BDF8BBF5C8D5C6DA
      00000000000000FFFF00000000000400CBCECCE5000A0000000000000000000A
      0000008600020000000000FFFFFF000000000000000002000000000000000000
      000000560F000006004D656D6F3138000A0CD8010000ED000000460000001200
      0000400C00000000010000000000E8030000010000000000E803000001000000
      0000E8030000010000000000E803000000000200000002000000FFFFFF1F002E
      020000000000010013005B7472696D285B22666A6864617465225D295D000000
      00000000FFFF00000000000400CBCECCE5000A0000000000000000000A000000
      8600020000000000FFFFFF000000000000000002000000000000000000000000
      1210000006004D656D6F3139000A0C1E020000ED000000AA0000001200000040
      0C00000000010000000000E8030000010000000000E8030000010000000000E8
      030000010000000000E803000000000200000002000000FFFFFF1F002E020000
      000000010012005B7472696D285B22667768657265225D295D00000000000000
      FFFF00000000000400CBCECCE5000A0000000000000000000800000086000200
      00000000FFFFFF00000000000000000200000000000000000000FC0100000000
      000000000000000000}
  end
  object RMXLSExport1: TRMXLSExport
    ShowExcel = True
    ShowAfterExport = True
    MultiSheet = False
    Left = 185
    Top = 327
  end
  object RMDBDataSet1: TRMDBDataSet
    DataSource = ds_disp
    Left = 169
    Top = 303
  end
  object ADOCommand1: TADOCommand
    CommandText = 'delete from tpztemp'
    Connection = dm.ADOConnection1
    Parameters = <>
    Left = 89
    Top = 217
  end
end