u_math.pas

一个仓库管理软件包括,仓库入库,仓库出库,库存信息,单据审核,反审核等功能.

                  node[childlevel]:=node[currlevel+1];

                end;
                while not childquery.Eof do
                begin


                 pTD:=allocmem(sizeof(rTreedata));
                 PTD^.Code:=childquery.fieldbyname('childid').AsString;
                 pTD^.Name:=childquery.fieldbyname('ChilName').AsString;
                 pTD^.EndFlag:=True;

                 tvTree.Items.AddChildObject(node[childlevel],pTD^.Name,PTD) ;
                  childquery.Next;
                end;  }
               nodequery.Next;
             end;

          end;
          qurTree.Next;
      end;
  finally
    nodequery.Free;
  //  childquery.Free;
  end;
 node[0].Expand(False);//将首节点展开
end;

procedure createBomchild(tvTree:TTreeView;Fatherid:integer);
var
 childquery:Tquery;
begin

end;

function GetSerialNo(Typestr: string;var value:string):boolean;
var
  sp1:TStoredProc;
  TP1,TP2:TPARAM;

begin
  //业务类型从SYS_SYS_IDCT
  sp1:=TStoredProc.Create(nil);
  try
    sp1.DatabaseName:='dbmain';
    sp1.StoredProcName:='sp_GetSerialNo';
    tp1:=tparam.Create(sp1.Params,ptInput);
    tp2:=tparam.Create(sp1.Params,ptOutput);
    try
      try
        tp1.Name:='@TypeStr';
        tp1.DataType:=ftstring;
        tp1.ParamType:=ptInput;
        tp2.Name:='@str1';
        tp2.DataType:=ftstring;
        tp2.ParamType:=ptoutput;
        sp1.ParamByName('@TypeStr').AsString:=Typestr;
        sp1.ParamByName('@str1').AsString:=value;
        sp1.ExecProc;
        value:=sp1.ParamByName('@str1').value;
        result:=true;
      except
        result:=false;
      end
    finally
      tp1.free;
      tp2.Free;
    end;
  finally
    sp1.Active:=false;
    sp1.Free;
  end;
end;

function GetSANo (Typestr: string;var value:string):boolean; //业务流水号typestr ='SAOR'
var
  sp1:TStoredProc;
  TP1,TP2:TPARAM;

begin
  //业务类型从SYS_SYS_IDCT
  sp1:=TStoredProc.Create(nil);
  try
    sp1.DatabaseName:='dbmain';
    sp1.StoredProcName:='sp_GetSANo';
    tp1:=tparam.Create(sp1.Params,ptInput);
    tp2:=tparam.Create(sp1.Params,ptOutput);
    try
      try
        tp1.Name:='@TypeStr';
        tp1.DataType:=ftstring;
        tp1.ParamType:=ptInput;
        tp2.Name:='@str1';
        tp2.DataType:=ftstring;
        tp2.ParamType:=ptoutput;
        sp1.ParamByName('@TypeStr').AsString:=Typestr;
        sp1.ParamByName('@str1').AsString:=value;
        sp1.ExecProc;
        value:=sp1.ParamByName('@str1').value;
        result:=true;
      except
        result:=false;
      end
    finally
      tp1.free;
      tp2.Free;
    end;
  finally
    sp1.Active:=false;
    sp1.Free;
  end;
end;
procedure Check_EditChar(Sender:tobject;len:integer;var key:char);
begin
   If Not (key in['0'..'9','-','a'..'z','A'..'Z',chr(VK_BACK),#13]) Then  key:=#0  ;
 if (Len>0) and (Length(TEdit(Sender).text)>=len) and (key<>chr(VK_BACK)) then key:=#0;

end;
function CheckBomNewNode( AFatherID :integer; ANewNodeID :integer;var Flag:integer):boolean;//检查新增BomNode
var
  sp1:TStoredProc;
  TP1,TP2,TP3:TPARAM;

begin

  sp1:=TStoredProc.Create(nil);
  try
    sp1.DatabaseName:='dbmain';
    sp1.StoredProcName:='sp_CheckBomNode';
    tp1:=tparam.Create(sp1.Params,ptInput);
    TP2:=tparam.Create(sp1.Params,ptInput);
    tp3:=tparam.Create(sp1.Params,ptOutput);
    try
      try
        tp1.Name:='@AFatherID';
        tp1.DataType:=ftInteger;
        tp1.ParamType:=ptInput;
        tp2.Name:='@ANewNodeID';
        tp2.DataType:=ftInteger;
        tp2.ParamType:=ptInput;
        tp3.Name:='@Flag';
        tp3.DataType:=ftInteger;
        tp3.ParamType:=ptoutput;
        sp1.ParamByName('@AFatherID').asinteger:=AFatherID;
        sp1.ParamByName('@ANewNodeID').asinteger:=ANewNodeID;
        sp1.ExecProc;
        Flag:=sp1.ParamByName('@Flag').value;
        if Flag=0 then
        result:=true;
      except
        result:=false;
      end
    finally
      tp1.free;
      tp2.Free;
      tp3.Free;
    end;
  finally
    sp1.Active:=false;
    sp1.Free;
  end;
end;

{function checkbtn(modcode:string):boolean;
var
  qurchk:Tquery;
begin
  try
    qurchk:=Tquery.Create(nil);
    qurchk.DatabaseName:='dbmain';
    qurchk.Close;
    qurchk.SQL.Clear;
    qurchk.sql.Add('select * from sys_purview where oprcode=:oprcode and modcode=:modcode');
    qurchk.ParamByName('oprcode').AsString:=rOpertor.OprCode;
    qurchk.ParamByName('modcode').AsString:=modcode;
    qurchk.Open;
    if qurchk.Eof then result:=false;
  except
    qurchk.Free;
    result:=false;
  end;
end;  }

// 显示提示窗口

procedure InfoDlg(Mess: string; Caption: string; Flags: Integer);
begin
  Application.MessageBox(PChar(Mess), PChar(Caption), Flags);
end;

// 显示提示确认窗口

function InfoOk(Mess: string; Caption: string): Boolean;
begin
  Result := Application.MessageBox(PChar(Mess), PChar(Caption),
    MB_OK + MB_ICONINFORMATION) = IDOK;
end;

// 显示错误窗口

procedure ErrorDlg(Mess: string; Caption: string);
begin
  Application.MessageBox(PChar(Mess), PChar(Caption), MB_OK + MB_ICONSTOP);
end;

// 显示警告窗口

procedure WarningDlg(Mess: string; Caption: string);
begin
  Application.MessageBox(PChar(Mess), PChar(Caption), MB_OK + MB_ICONWARNING);
end;

// 显示查询是否窗口

function QueryDlg(Mess: string; DefaultNo: Boolean; Caption: string): Boolean;
const
  Defaults: array[Boolean] of DWORD = (0, MB_DEFBUTTON2);
begin
  Result := Application.MessageBox(PChar(Mess), PChar(Caption),
    MB_YESNO + MB_ICONQUESTION + Defaults[DefaultNo]) = IDYES;
end;

// 显示是否取消窗口  -1取消 1是 0否
function MsgDlg(Mess: string; DefaultNo: Boolean; Caption: string): Integer;
const
  Defaults: array[Boolean] of DWORD = (0, MB_DEFBUTTON3);
var Res: Integer;
begin
  //2取消 6是 7否
  Res := Application.MessageBox(PChar(Mess), PChar(Caption),
    MB_YESNOCANCEL + MB_ICONQUESTION + Defaults[DefaultNo]);
  case Res of
    2: Res:=-1;
    6: Res:=1;
    7: Res:=0;
    else Res:=2;
  end;
  Result := Res;
end;


//权限显示
//输入 原按钮可用性，库中权限
//输出 现有权限
function ShowEnable(OldButton, DataButton: Boolean): Boolean;
begin
  Result := OldButton and DataButton;
end;

//--------------------------------------
// 获取硬盘系列号
//--------------------------------------

function GetIdeSerialNumber: pchar;
  const IDENTIFY_BUFFER_SIZE = 512;
type
   TIDERegs = packed record
     bFeaturesReg: BYTE; // Used for specifying SMART "commands".
     bSectorCountReg: BYTE; // IDE sector count register
     bSectorNumberReg: BYTE; // IDE sector number register
     bCylLowReg: BYTE; // IDE low order cylinder value
     bCylHighReg: BYTE; // IDE high order cylinder value
     bDriveHeadReg: BYTE; // IDE drive/head register
     bCommandReg: BYTE; // Actual IDE command.
     bReserved: BYTE; // reserved for future use. Must be zero.
  end;
  TSendCmdInParams = packed record
    // Buffer size in bytes
    cBufferSize: DWORD;
    // Structure with drive register values.
    irDriveRegs: TIDERegs;
    // Physical drive number to send command to (0,1,2,3).
    bDriveNumber: BYTE;
    bReserved: array[0..2] of Byte;
    dwReserved: array[0..3] of DWORD;
    bBuffer: array[0..0] of Byte; // Input buffer.
  end;
  TIdSector = packed record
    wGenConfig: Word;
    wNumCyls: Word;
    wReserved: Word;
    wNumHeads: Word;
    wBytesPerTrack: Word;
    wBytesPerSector: Word;
    wSectorsPerTrack: Word;
    wVendorUnique: array[0..2] of Word;
    sSerialNumber: array[0..19] of CHAR;
    wBufferType: Word;
    wBufferSize: Word;
    wECCSize: Word;
    sFirmwareRev: array[0..7] of Char;
    sModelNumber: array[0..39] of Char;
    wMoreVendorUnique: Word;
    wDoubleWordIO: Word;
    wCapabilities: Word;
    wReserved1: Word;
    wPIOTiming: Word;
    wDMATiming: Word;
    wBS: Word;
    wNumCurrentCyls: Word;
    wNumCurrentHeads: Word;
    wNumCurrentSectorsPerTrack: Word;
    ulCurrentSectorCapacity: DWORD;
    wMultSectorStuff: Word;
    ulTotalAddressableSectors: DWORD;
    wSingleWordDMA: Word;
    wMultiWordDMA: Word;
    bReserved: array[0..127] of BYTE;
  end;
  PIdSector = ^TIdSector;
  TDriverStatus = packed record
    // 驱动器返回的错误代码，无错则返回0
    bDriverError: Byte;
    // IDE出错寄存器的内容，只有当bDriverError 为 SMART_IDE_ERROR 时有效
    bIDEStatus: Byte;
    bReserved: array[0..1] of Byte;
    dwReserved: array[0..1] of DWORD;
  end;
  TSendCmdOutParams = packed record
    // bBuffer的大小
    cBufferSize: DWORD;
    // 驱动器状态
    DriverStatus: TDriverStatus;
    // 用于保存从驱动器读出的数据的缓冲区，实际长度由cBufferSize决定
    bBuffer: array[0..0] of BYTE;
  end;
var
  hDevice: Thandle;
  cbBytesReturned: DWORD;
  SCIP: TSendCmdInParams;
  aIdOutCmd: array[0..(SizeOf(TSendCmdOutParams) + IDENTIFY_BUFFER_SIZE-1)-1] of Byte;
  IdOutCmd: TSendCmdOutParams absolute aIdOutCmd;
  procedure ChangeByteOrder(var Data; Size: Integer);
  var
    ptr: Pchar;
    i: Integer;
    c: Char;
  begin
    ptr := @Data;
    for I := 0 to (Size shr 1) - 1 do begin
      c := ptr^;
      ptr^ := (ptr + 1)^;
      (ptr + 1)^ := c;
      Inc(ptr, 2);
    end;
  end;
begin
  Result := ''; // 如果出错则返回空串
  if SysUtils.Win32Platform = VER_PLATFORM_WIN32_NT then begin // Windows NT, Windows 2000
  // 提示! 改变名称可适用于其它驱动器，如第二个驱动器： '\\.\PhysicalDrive1\'
  hDevice := CreateFile('\\.\PhysicalDrive0', GENERIC_READ or GENERIC_WRITE,
  FILE_SHARE_READ or FILE_SHARE_WRITE, nil, OPEN_EXISTING, 0, 0);
  end else // Version Windows 95 OSR2, Windows 98
  hDevice := CreateFile('\\.\SMARTVSD', 0, 0, nil, CREATE_NEW, 0, 0);
  if hDevice = INVALID_HANDLE_VALUE then Exit;
  try
    FillChar(SCIP, SizeOf(TSendCmdInParams) - 1, #0);
    FillChar(aIdOutCmd, SizeOf(aIdOutCmd), #0);
    cbBytesReturned := 0;
    // Set up data structures for IDENTIFY command.
    with SCIP do begin
      cBufferSize := IDENTIFY_BUFFER_SIZE;
      // bDriveNumber := 0;
      with irDriveRegs do begin
        bSectorCountReg := 1;
        bSectorNumberReg := 1;
        // if Win32Platform=VER_PLATFORM_WIN32_NT then bDriveHeadReg := $A0
        // else bDriveHeadReg := $A0 or ((bDriveNum and 1) shl 4);
        bDriveHeadReg := $A0;
        bCommandReg := $EC;
      end;
    end;
    if not DeviceIoControl(hDevice, $0007C088, @SCIP, SizeOf(TSendCmdInParams) - 1,
    @aIdOutCmd, SizeOf(aIdOutCmd), cbBytesReturned, nil) then Exit;
  finally
    CloseHandle(hDevice);
  end;
  with PIdSector(@IdOutCmd.bBuffer)^ do begin
    ChangeByteOrder(sSerialNumber, SizeOf(sSerialNumber));
    (Pchar(@sSerialNumber) + SizeOf(sSerialNumber))^:= #0;
    Result := Pchar(@sSerialNumber);
  end;
end;

//--------------------------------------
// 加解密函数实现
//--------------------------------------

function TransChar(AChar: Char): Integer;
begin
  if AChar in ['0'..'9'] then
    Result := Ord(AChar) - Ord('0')
  else
    Result := 10 + Ord(AChar) - Ord('A');
end;

function StrToHex(AStr: string): string;
var
  I: Integer;
begin
  Result := '';
  for I := 1 to Length(AStr) do
    Result := Result + IntToHex(Byte(AStr[I]), 2);
end;

function HexToStr(AStr: string): string;
var
  I: Integer;
  CharValue: Word;
begin
  Result := '';
  for I := 1 to Trunc(Length(Astr) / 2) do
  begin
    Result := Result + ' ';
    CharValue := TransChar(AStr[2 * I - 1]) * 16 + TransChar(AStr[2 * I]);
    Result[I] := Char(CharValue);
  end;
end;


function Encrypt(const S: string): string;
var
  I: Integer;
  AKey: Word;
  LockKey, BegKey, EndKey: integer;
begin
  LockKey := 13;
  BegKey := 53523;
  EndKey := 32768;

        //得到加密字符
  AKey := LockKey;