13,825
社区成员
发帖
与我相关
我的任务
分享
void __fastcall TForm1::Button3Click(TObject *Sender)
{
ProcCheckLMacWMac->Parameters->Clear();
ProcCheckLMacWMac->Close();
ProcCheckLMacWMac->Connection=ADOConnection1;
ProcCheckLMacWMac->Prepared=true;
ProcCheckLMacWMac->ProcedureName="SP_TestGetSNData;1";
ProcCheckLMacWMac->Parameters->CreateParameter("@SN",ftString,pdInput,50,OleVariant(0));
ProcCheckLMacWMac->Parameters->CreateParameter("@DataType",ftString,pdInput,50,OleVariant(0));
ProcCheckLMacWMac->Parameters->ParamByName("@SN")->Value="ANK1E2H19JW0001";
ProcCheckLMacWMac->Parameters->ParamByName("@DataType")->Value="PreMac";
ProcCheckLMacWMac->ExecProc();
//Sleep(5000);
AnsiString s1=ProcCheckLMacWMac->FieldByName("@Measured")->AsString;
Edit1->Text=s1;
}
ProcGetSNData->Close();
ProcGetSNData->Parameters->Items[1]->Value = "ANK1E2H19J20001";
ProcGetSNData->Parameters->Items[2]->Value = "PreMac";
ProcGetSNData->Open();
AnsiString xx = ProcGetSNData->FieldByName("Measured")->AsString;
Edit2->Text = xx;
ProcCheckLMacWMac->Close();
ProcCheckLMacWMac->Connection = ADOConnection1;
ProcCheckLMacWMac->Prepared = true;
ProcCheckLMacWMac->SQL->Text = String().sprintf(
TEXT("exec SP_TestGetSNData ")
TEXT("@SN=:SN,")
TEXT("@DataType=:DataType"));
ProcCheckLMacWMac->Parameters->Items[0]->Value = String("ANK1E2H19JW0001");
ProcCheckLMacWMac->Parameters->Items[1]->Value = String("PreMac");
ProcCheckLMacWMac->Open();
AnsiString str = ProcCheckLMacWMac->FieldByName("@Measured")->AsString;
Edit1->Text = str;
USE [SMT]
GO
/****** Object: StoredProcedure [dbo].[SP_TestGetSNData] Script Date: 09/20/2011 11:20:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--exec SP_TestGetSNData @SN='ATN4S01500GX',@DataType='LCMID'
ALTER procedure [dbo].[SP_TestGetSNData]
(
@SN varchar(50),
@DataType varchar(50)=''
)
As
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--*Program*: <Function Test>
--*Programer*:<Udall>
--*Date*:<2009/09/14>
--*Unify*:<UY>
--*Description*:<应用于程测试序,工程测试直接Call存储>
--########## Parameter Description Begin ##########
--@SN: 序号
--########## Parameter Description End # ##########
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
set nocount on
Declare @MAC varchar(50)
Declare @Modelname varchar(30)
Declare @WO varchar(30)
select @Modelname=isnull(ModelName,''),@WO=WorkOrder from SMT_SP with(nolock) where SerialNumber=@SN
if @DataType='PreMac'
begin
select Measured from SMT_FVS where
SerialNumber=@sn and Tstation='PreUI'
end
if @DataType='PINCode'
begin
set @MAC=''
select @MAC=isnull(MAC,'') from SN_MAC with(nolock) where SN=@SN
if @MAC<>''
begin
select isnull(MAC,'') as MAC,isnull(PINCode,'') as PINCode from MAC_PINCode with(nolock) where MAC=@MAC
end
else
begin
select '' as MAC,'' as PINCode
end
return
end
if @DataType='Mac'
begin
set @MAC=''
select @MAC=ISNULL(Mac,'') from SN_Mac with(nolock) where SN=@SN
select @MAC Mac
return
end
if @DataType='LCMID'
begin
Declare @LCD varchar(1000)
declare @split varchar(10)
select @LCD=Value from ModelName_Data where ModelName=@Modelname and FuncType='LCMID' and Item='LCMID'
set @split=';'
select a LCD from func_split(@LCD,@split)
end
if @DataType='ModelDesc'
begin
if @Modelname<>''
begin
select 'OK' Result,ISNULL(ModelDesc,'') as ModelDesc from ModelName where ModelName=@Modelname
return
end
else
begin
select 'Fail' Result,'' as ModelDesc
return
end
end
if @DataType='SAP_WO_List'
begin
select * from SAP_WO_LIST where WO=@WO
return
end
USE [SMT]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[SP_TestGetSNData]
@SN = 'ANK1E2H19JW0001',
@DataType = 'PreMac'
SELECT 'Return Value' = @return_value
GO
ProcGetSNData->Close();
ProcGetSNData->Parameters->Items[1]->Value = "ANK1E2H19J20001";
ProcGetSNData->Parameters->Items[2]->Value = "PreMac";
ProcGetSNData->Open();
AnsiString xx = ProcGetSNData->FieldByName("Measured")->AsString;
Edit2->Text = xx;
}