unit U_GetDllForm; interface uses Windows, Messages, forms, OleCtnrs, DateUtils, SysUtils, ADODB,IniFiles, 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_KHInfo,U_ZdyAttachment,U_ZdyAttachGYS,U_ZdyAttachCP,U_CPKWlist,U_CPKWHZ, U_ZdyAttachCP10,U_ZdyAttachCP20,U_ZdyAttachCP_HX,U_ZdyAttachCP_ImageList,U_ZdyAttachCP30,U_ZdyAttachCP_ImageList10; ///////////////////////////////////////////////////////////////// // 功能说明:取Dll中得窗体 // // 参数说明:App>>调用应用程序; // // FormH>>调用窗口句柄 ; // // FormID>>窗口号; // // Language>>语言种类; // // WinStyle>>窗口类型; // ///////////////////////////////////////////////////////////////// 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 mnewHandle: hwnd; mstyle: TFormStyle; // 0:子窗口; 1:普通窗口 mstate: TWindowState; mborderstyle: TFormBorderStyle; begin mNewHandle:=0; DName:=GName; DCode:=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:='101.132.143.144,7781'; // dtbase:='123'; dtbase:='lanshanjydata'; user:='rtsa'; pswd:='rightsoft@5740'; DConString := 'Provider=SQLOLEDB.1;Password='+pswd+';Persist Security Info=True;User ID=' +user+';Initial Catalog='+dtbase+';Data Source='+server; IF trim(DataBaseStr)<>''then DConString := DataBaseStr; // DParameters1:='高权限'; // DParameters1:='1'; // DataBase:='加工厂'; // DataBase:=''; 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 1: //客户资料维护 begin if frmZdyAttachment=nil then begin frmZdyAttachment:= TfrmZdyAttachment.Create(application.MainForm); with frmZdyAttachment do begin caption:=Trim(Title); fkhType:=trim(DataBase); canshu1:=trim(DParameters1); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachment.BringToFront; //句柄 mNewHandle:=frmZdyAttachment.Handle; end ; 2: //供应商资料维护 begin if frmZdyAttachGYS=nil then begin frmZdyAttachGYS:= TfrmZdyAttachGYS.Create(application.MainForm); with frmZdyAttachGYS do begin caption:=Trim(Title); // fDEFstr5:=trim(''); fDEFstr5:=trim(DataBase); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachGYS.BringToFront; //句柄 mNewHandle:=frmZdyAttachGYS.Handle; end ; 3: //产品资料维护 begin if frmZdyAttachCP=nil then begin frmZdyAttachCP:= TfrmZdyAttachCP.Create(application.MainForm); with frmZdyAttachCP do begin caption:=Trim(Title); // fkhType:=''; fkhType:=trim(DataBase); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachCP.BringToFront; //句柄 mNewHandle:=frmZdyAttachCP.Handle; end ; 31: //产品资料维护 begin if frmZdyAttachCP10=nil then begin frmZdyAttachCP10:= TfrmZdyAttachCP10.Create(application.MainForm); with frmZdyAttachCP10 do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachCP10.BringToFront; //句柄 mNewHandle:=frmZdyAttachCP10.Handle; end ; 32: //产品目录 begin if frmZdyAttachCP20=nil then begin frmZdyAttachCP20:= TfrmZdyAttachCP20.Create(application.MainForm); with frmZdyAttachCP20 do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachCP20.BringToFront; //句柄 mNewHandle:=frmZdyAttachCP20.Handle; end ; 33: //产品目录 begin if frmZdyAttachCP30=nil then begin frmZdyAttachCP30:= TfrmZdyAttachCP30.Create(application.MainForm); with frmZdyAttachCP30 do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachCP30.BringToFront; //句柄 mNewHandle:=frmZdyAttachCP30.Handle; end ; 6: //库位信息 begin if frmCPKWList=nil then begin frmCPKWList:= TfrmCPKWList.Create(application.MainForm); with frmCPKWList do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmCPKWList.BringToFront; //句柄 mNewHandle:=frmCPKWList.Handle; end ; 61: //库位信息汇总 begin if frmCPKWHZ=nil then begin frmCPKWHZ:= TfrmCPKWHZ.Create(application.MainForm); with frmCPKWHZ do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmCPKWHZ.BringToFront; //句柄 mNewHandle:=frmCPKWHZ.Handle; end ; 7: //库位信息 begin if frmZdyAttachCP_HX=nil then begin frmZdyAttachCP_HX:= TfrmZdyAttachCP_HX.Create(application.MainForm); with frmZdyAttachCP_HX do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachCP_HX.BringToFront; //句柄 mNewHandle:=frmZdyAttachCP_HX.Handle; end ; 10: //库位信息 begin if frmZdyAttachCP_ImageList=nil then begin frmZdyAttachCP_ImageList:= TfrmZdyAttachCP_ImageList.Create(application.MainForm); with frmZdyAttachCP_ImageList do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachCP_ImageList.BringToFront; //句柄 mNewHandle:=frmZdyAttachCP_ImageList.Handle; end ; 11: //库位信息 begin if frmZdyAttachCP_ImageList10=nil then begin frmZdyAttachCP_ImageList10:= TfrmZdyAttachCP_ImageList10.Create(application.MainForm); with frmZdyAttachCP_ImageList10 do begin caption:=Trim(Title); FormStyle := mstyle ; windowState := mstate ; BorderStyle := mborderstyle; //show; end; end else frmZdyAttachCP_ImageList10.BringToFront; //句柄 mNewHandle:=frmZdyAttachCP_ImageList10.Handle; end ; end ; // end case Result:= mnewHandle; // NewDllApp:=Application ; end; //=========================================================== //建立数据库连接池 //=========================================================== function ConnData():Boolean; var IniFile: TIniFile; begin try IniFile := TIniFile.Create(ExtractFilePath(Application.ExeName) + 'SYSTEMSET.INI'); PicSvr := IniFile.ReadString('SERVER', '服务器地址','127.0.0.1'); UserDataFlag:=IniFile.ReadString('SERVER', '服务器地址类型','-1'); finally IniFile.Free; end; if not Assigned(DataLink_BaseInfo) then DataLink_BaseInfo:=TDataLink_BaseInfo.Create(Application); Try with DataLink_BaseInfo.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_BaseInfo.Free; application:=NewDllApp; dxUnitsLoader.Finalize; end.