unit U_GetDllForm; interface uses Windows, Messages, forms, OleCtnrs, DateUtils, SysUtils, ADODB, dxCore, ActiveX; function GetDllForm(App: Tapplication; FormH: hwnd; FormID: integer; Language: integer; WinStyle: integer; GCode: Pchar; GName: Pchar; DataBase: Pchar; Title: PChar; Parameters1: PChar; Parameters2: PChar; Parameters3: PChar; Parameters4: PChar; Parameters5: PChar; Parameters6: PChar; Parameters7: PChar; Parameters8: PChar; Parameters9: PChar; Parameters10: PChar; DataBaseStr: PChar): hwnd; export; stdcall; function ConnData(): Boolean; implementation uses U_DataLink, U_FHSQList, U_PBOutHZList, U_SQSMCK, U_SMPK, U_FHSQListXH, U_SQSMCKXH, U_SXKCCK, U_ProductOrderNewList_TC, U_THSQSMTH, U_DYSQList, U_FHSQListCX, U_CWOutHZList, U_THMXList; ///////////////////////////////////////////////////////////////// // 功能说明:取Dll中得窗体 // // 参数说明:App>>调用应用程序; // // FormH>>调用窗口句柄 ; // // FormID>>窗口号; // // Language>>语言种类; // // WinStyle>>窗口类型; // ///////////////////////////////////////////////////////////////// var frmFHSQListLR, frmFHSQListGQX, frmFHSQListChk, frmFHSQListChkWX: TfrmFHSQList; frmPBOutHZListGL, frmPBOutHZListCX, frmPBOutHZListCXD: TfrmPBOutHZList; frmFHSQListXHLR, frmFHSQListXHGQX, frmFHSQListXHChk: TfrmFHSQListXH; frmProductTCLR, frmProductTCJL, frmProductTCGL, frmProductTCQR, frmProductTCCX, frmProductTCXG: TfrmProductOrderNewList_TC; frmDYSQListLR, frmDYSQListGQX, frmDYSQListChk: TfrmDYSQList; function GetDllForm(App: Tapplication; FormH: hwnd; FormID: integer; Language: integer; WinStyle: integer; GCode: Pchar; GName: Pchar; DataBase: Pchar; Title: PChar; Parameters1: PChar; Parameters2: PChar; Parameters3: PChar; Parameters4: PChar; Parameters5: PChar; Parameters6: PChar; Parameters7: PChar; Parameters8: PChar; Parameters9: PChar; Parameters10: PChar; DataBaseStr: PChar): hwnd; var i: Integer; bFound: Boolean; mnewHandle: hwnd; mstyle: TFormStyle; // 0:子窗口; 1:普通窗口 mstate: TWindowState; mborderstyle: TFormBorderStyle; begin mnewHandle := 0; DName := PChar(GName); DCode := PChar(GCode); DdataBase := DataBase; DTitCaption := Title; DParameters1 := Parameters1; DParameters2 := Parameters2; DParameters3 := Parameters3; DParameters4 := Parameters4; DParameters5 := Parameters5; DParameters6 := Parameters6; DParameters7 := Parameters7; DParameters8 := Parameters8; DParameters9 := Parameters9; DParameters10 := Parameters10; MainApplication := App; DCurHandle := FormH; IsDelphiLanguage := Language; Application := TApplication(App); DCurHandle := 0; //赋值链接字符串 SetLength(server, 255); SetLength(dtbase, 255); SetLength(user, 255); SetLength(pswd, 255); server := '47.103.192.8,7781'; // server := '.'; dtbase := 'yushangdata'; user := 'yushangsa'; // user := 'sa'; pswd := 'rightsoft@7112'; // pswd := 'rightsoft'; DConString := 'Provider=SQLOLEDB.1;Password=' + pswd + ';Persist Security Info=True;User ID=' + user + ';Initial Catalog=' + dtbase + ';Data Source=' + server; DConString := DataBaseStr; // DName := '程媛'; // DParameters1:='高权限'; //DParameters3:='1'; if not ConnData() then begin result := 0; exit; end; // 定义窗口类型 、状态 if WinStyle = 0 then begin mstyle := fsMDIChild; mstate := wsMaximized; mborderstyle := bsSizeable; end else begin mstyle := fsNormal; mstate := wsNormal; mborderstyle := bsSizeable; end; ///////////////////// //调用子模块窗口 case FormID of 111: //发货申请 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '发货申请录入' then begin BringWindowToTop(frmFHSQListLR.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmFHSQListLR := TfrmFHSQList.Create(application.MainForm); with frmFHSQListLR do begin Title := '发货申请录入'; canshu1 := '录入'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmFHSQListLR.BringToFront; //句柄 mnewHandle := frmFHSQListLR.Handle; end; 112: //发货申请(高权限) begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '发货申请(高权限)' then begin BringWindowToTop(frmFHSQListGQX.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmFHSQListGQX := TfrmFHSQList.Create(application.MainForm); with frmFHSQListGQX do begin Title := '发货申请(高权限)'; canshu1 := '高权限'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmFHSQListGQX.BringToFront; //句柄 mnewHandle := frmFHSQListGQX.Handle; end; 113: //发货申请审核 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '发货申请审核' then begin BringWindowToTop(frmFHSQListChk.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmFHSQListChk := TfrmFHSQList.Create(application.MainForm); with frmFHSQListChk do begin Title := '发货申请审核'; canshu1 := '高权限'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmFHSQListChk.BringToFront; //句柄 mnewHandle := frmFHSQListChk.Handle; end; { 202: //扫描出库选库存 begin if frmSXKCCK = nil then begin frmSXKCCK := TfrmSXKCCK.Create(application.MainForm); with frmSXKCCK do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmSXKCCK.BringToFront; //句柄 mnewHandle := frmSXKCCK.Handle; end; } 114: //物流发货进度 begin if frmFHSQListCX = nil then begin frmFHSQListCX := TfrmFHSQListCX.Create(application.MainForm); with frmFHSQListCX do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmFHSQListCX.BringToFront; //句柄 mnewHandle := frmFHSQListCX.Handle; end; 201: //扫描出库 begin if frmSQSMCK = nil then begin frmSQSMCK := TfrmSQSMCK.Create(application.MainForm); with frmSQSMCK do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmSQSMCK.BringToFront; //句柄 mnewHandle := frmSQSMCK.Handle; end; 121: //码单打印 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '码单打印' then begin BringWindowToTop(frmPBOutHZListGL.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmPBOutHZListGL := TfrmPBOutHZList.Create(application.MainForm); with frmPBOutHZListGL do begin Title := '码单打印'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmPBOutHZListGL.BringToFront; //句柄 mnewHandle := frmPBOutHZListGL.Handle; end; 122: //码单查询 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '码单查询' then begin BringWindowToTop(frmPBOutHZListCX.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmPBOutHZListCX := TfrmPBOutHZList.Create(application.MainForm); with frmPBOutHZListCX do begin Title := '码单查询'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmPBOutHZListCX.BringToFront; //句柄 mnewHandle := frmPBOutHZListCX.Handle; end; 123: //码单查询(低) begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '码单查询(低)' then begin BringWindowToTop(frmPBOutHZListCXD.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmPBOutHZListCXD := TfrmPBOutHZList.Create(application.MainForm); with frmPBOutHZListCXD do begin Title := '码单查询(低)'; CANSHU1 := '查询'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmPBOutHZListCXD.BringToFront; //句柄 mnewHandle := frmPBOutHZListCXD.Handle; end; 125: //财务码单打印 begin if frmCWOutHZList = nil then begin frmCWOutHZList := TfrmCWOutHZList.Create(application.MainForm); with frmCWOutHZList do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmCWOutHZList.BringToFront; //句柄 mnewHandle := frmCWOutHZList.Handle; end; 411: //生产发货申请 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '生产发货申请录入' then begin BringWindowToTop(frmFHSQListXHLR.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmFHSQListXHLR := TfrmFHSQListXH.Create(application.MainForm); with frmFHSQListXHLR do begin Title := '生产发货申请录入'; canshu1 := '录入'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmFHSQListXHLR.BringToFront; //句柄 mnewHandle := frmFHSQListXHLR.Handle; end; 412: //现货发货申请(高权限) begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '生产发货申请(高权限)' then begin BringWindowToTop(frmFHSQListXHGQX.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmFHSQListXHGQX := TfrmFHSQListXH.Create(application.MainForm); with frmFHSQListXHGQX do begin Title := '生产发货申请(高权限)'; canshu1 := '高权限'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmFHSQListXHGQX.BringToFront; //句柄 mnewHandle := frmFHSQListXHGQX.Handle; end; 413: //生产发货申请审核 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '生产发货申请审核' then begin BringWindowToTop(frmFHSQListXHChk.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmFHSQListXHChk := TfrmFHSQListXH.Create(application.MainForm); with frmFHSQListXHChk do begin Title := '生产发货申请审核'; canshu1 := '高权限'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmFHSQListXHChk.BringToFront; //句柄 mnewHandle := frmFHSQListXHChk.Handle; end; 421: //现货扫描出库 begin if frmSQSMCKXH = nil then begin frmSQSMCKXH := TfrmSQSMCKXH.Create(application.MainForm); with frmSQSMCKXH do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmSQSMCKXH.BringToFront; //句柄 mnewHandle := frmSQSMCKXH.Handle; end; 311: //扫描盘库 begin if frmSMPK = nil then begin frmSMPK := TfrmSMPK.Create(application.MainForm); with frmSMPK do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmSMPK.BringToFront; //句柄 mnewHandle := frmSMPK.Handle; end; 510: //退货申请查询 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '退货申请查询' then begin BringWindowToTop(frmProductTCCX.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmProductTCCX := TfrmProductOrderNewList_TC.Create(application.MainForm); with frmProductTCCX do begin Title := '退货申请查询'; canshu1 := '查询'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmProductTCCX.BringToFront; //句柄 mnewHandle := frmProductTCCX.Handle; end; 511: //退货申请 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '退货申请录入' then begin BringWindowToTop(frmProductTCLR.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmProductTCLR := TfrmProductOrderNewList_TC.Create(application.MainForm); with frmProductTCLR do begin Title := '退货申请录入'; canshu1 := '录入'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmProductTCLR.BringToFront; //句柄 mnewHandle := frmProductTCLR.Handle; end; 512: //退货申请管理 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '退货申请管理' then begin BringWindowToTop(frmProductTCGL.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmProductTCGL := TfrmProductOrderNewList_TC.Create(application.MainForm); with frmProductTCGL do begin Title := '退货申请管理'; canshu1 := '高权限'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmProductTCGL.BringToFront; //句柄 mnewHandle := frmProductTCGL.Handle; end; 513: //财务退仓确认 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '财务退仓确认' then begin BringWindowToTop(frmProductTCQR.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmProductTCQR := TfrmProductOrderNewList_TC.Create(application.MainForm); with frmProductTCQR do begin Title := '财务退仓确认'; canshu1 := '财务'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmProductTCQR.BringToFront; //句柄 mnewHandle := frmProductTCQR.Handle; end; 515: //退仓调度 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '退仓信息修改' then begin BringWindowToTop(frmProductTCXG.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmProductTCXG := TfrmProductOrderNewList_TC.Create(application.MainForm); with frmProductTCXG do begin Title := '退仓信息修改'; canshu1 := '调度'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmProductTCXG.BringToFront; //句柄 mnewHandle := frmProductTCXG.Handle; end; 516: //退仓经理审核 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '退仓经理审核' then begin BringWindowToTop(frmProductTCJL.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmProductTCJL := TfrmProductOrderNewList_TC.Create(application.MainForm); with frmProductTCJL do begin Title := '退仓经理审核'; canshu1 := '经理'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmProductTCJL.BringToFront; //句柄 mnewHandle := frmProductTCJL.Handle; end; 514: //退货明细查询 begin if frmTHMXList = nil then begin frmTHMXList := TfrmTHMXList.Create(application.MainForm); with frmTHMXList do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmTHMXList.BringToFront; //句柄 mnewHandle := frmTHMXList.Handle; end; 521: //扫描退货 begin if frmTHSQSMTH = nil then begin frmTHSQSMTH := TfrmTHSQSMTH.Create(application.MainForm); with frmTHSQSMTH do begin caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmTHSQSMTH.BringToFront; //句柄 mnewHandle := frmTHSQSMTH.Handle; end; 611: //板房调样申请 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '板房调样申请录入' then begin BringWindowToTop(frmDYSQListLR.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmDYSQListLR := TfrmDYSQList.Create(application.MainForm); with frmDYSQListLR do begin Title := '板房调样申请录入'; canshu1 := '录入'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmDYSQListLR.BringToFront; //句柄 mnewHandle := frmDYSQListLR.Handle; end; 612: //板房调样申请(高权限) begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '板房调样申请(高权限)' then begin BringWindowToTop(frmDYSQListGQX.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmDYSQListGQX := TfrmDYSQList.Create(application.MainForm); with frmDYSQListGQX do begin Title := '板房调样申请(高权限)'; canshu1 := '高权限'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmDYSQListGQX.BringToFront; //句柄 mnewHandle := frmDYSQListGQX.Handle; end; 613: //板房调样申请审核 begin bFound := FALSE; for i := (App.MainForm.MDIChildCount - 1) downto 0 do begin if App.MainForm.MDIChildren[i].Caption = '板房调样申请审核' then begin BringWindowToTop(frmDYSQListChk.Handle); bFound := TRUE; Break; end; end; if not bFound then begin frmDYSQListChk := TfrmDYSQList.Create(application.MainForm); with frmDYSQListChk do begin Title := '板房调样申请审核'; canshu1 := '高权限'; caption := Trim(Title); FormStyle := mstyle; windowState := mstate; BorderStyle := mborderstyle; //show; end; end else frmDYSQListChk.BringToFront; //句柄 mnewHandle := frmDYSQListChk.Handle; end; end; Result := mnewHandle; end; //=========================================================== //建立数据库连接池 //=========================================================== function ConnData(): Boolean; begin if not Assigned(DataLink_ShipmentRequest) then DataLink_ShipmentRequest := TDataLink_ShipmentRequest.Create(Application); try with DataLink_ShipmentRequest.ADOLink do begin //if not Connected then begin Connected := false; ConnectionString := DConString; LoginPrompt := false; Connected := true; end; end; Result := true; except Result := false; application.MessageBox('数据库连接失败!', '错误', mb_Ok + MB_ICONERROR); end; end; initialization CoInitialize(nil); dxUnitsLoader.Initialize; finalization DataLink_ShipmentRequest.Free; application := NewDllApp; dxUnitsLoader.Finalize; end.