：--drop procedure ChineseCode;
----------一
create procedure ChineseCode(@strkey varchar(30),@rekeysPY varchar(30) output,
@rekeysWB varchar(30) output)
as
declare @keylength int
declare @nowstep int
declare @temppy varchar(20)
declare @tempwb varchar(20)
declare @tempkey varchar(4)
declare @strpy varchar(30)
declare @strwb varchar(30)
set @keylength=len(@strkey)
set @nowstep=1
set @strpy=''
set @strwb=''
begin
while (@nowstep<=@keylength)
begin
set @tempkey=substring(@strkey,@nowstep,1)
set @nowstep=@nowstep+1
If Ascii(@tempkey) > 32 And Ascii(@tempkey) < 127
begin
set @temppy=@tempkey
set @tempwb=@tempkey
end
else
begin
select @temppy=pycode,@tempwb=wbcode from words where word=@tempkey
end
set @strpy=@strpy+substring(@temppy,1,1)
set @strwb=@strwb+substring(@tempwb,1,1)
end
set @rekeysPY=@strpy
set @rekeysWB=@strwb
print @rekeysPY+'--'+@rekeysWB
end
GO
--------------------二
--drop procedure ChineseCode;
create procedure ChineseCode
(
@strkey varchar(30) ,
@rekeysPY varchar(30) output,
@rekeysWB varchar(30) output)
as
declare @keylength int
declare @i int
declare @temppy varchar(10)
declare @tempwb varchar(10)
declare @tempkey varchar(2)
set @keylength=len(@strkey)
set @i=1
set @temppy=''
set @tempwb=''
set @rekeysPY=''
set @rekeysWB=''
begin
while (@i<=@keylength)
begin
set @tempkey=substring(@strkey,@i,1)
set @i=@i+1
If Ascii(@tempkey) > 32 And Ascii(@tempkey) < 127
begin
set @rekeysPY=@rekeysPY+@tempkey
set @rekeysWB=@rekeysWB+@tempkey
continue
end
select @temppy=pycode,@tempwb=wbcode from words where word=@tempkey
set @rekeysPY=@rekeysPY+substring(@temppy,1,1)
set @rekeysWB=@rekeysWB+substring(@tempwb,1,1)
end
set @rekeysPY=@rekeysPY
set @rekeysWB=@rekeysWB
print @rekeysPY+'--'+@rekeysWB
end
GO
----------------三 c#代码
PubClass.ContSql db = new MilkDisPatchingManage.PubClass.ContSql();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.CommandText = "ChineseCode";
sqlcmd.Parameters.Add("@strkey", SqlDbType.VarChar, 30);
sqlcmd.Parameters["@strkey"].Value=this.textBox1.Text.Trim();//.Direction=ParameterDirection.Input;
sqlcmd.Parameters.Add("@rekeysPY", SqlDbType.VarChar,30);
sqlcmd.Parameters["@rekeysPY"].Direction = ParameterDirection.Output;
sqlcmd.Parameters.Add("@rekeysWB", SqlDbType.VarChar,30);
sqlcmd.Parameters["@rekeysWB"].Direction = ParameterDirection.Output;
int i= db.ExtCom(sqlcmd);
this.textBox2.Text = sqlcmd.Parameters["@rekeysPY"].Value.ToString();
this.textBox3.Text = sqlcmd.Parameters["@rekeysWB"].Value.ToString();
db.CloseCon();
