62,065
社区成员
发帖
与我相关
我的任务
分享
// 根据[A-Z][a-z]取得汉字范围
private static string GetCN(string AZChar)
{
string ascFrom = "", ascTo = "";
switch (AZChar.ToUpper())
{
case "A": ascFrom = "45217"; ascTo = "45252"; break;
case "B": ascFrom = "45253"; ascTo = "45760"; break;
case "C": ascFrom = "45761"; ascTo = "46317"; break;
case "D": ascFrom = "46318"; ascTo = "46825"; break;
case "E": ascFrom = "46826"; ascTo = "47009"; break;
case "F": ascFrom = "47010"; ascTo = "47296"; break;
case "G": ascFrom = "47297"; ascTo = "47613"; break;
case "H": ascFrom = "47614"; ascTo = "48118"; break;
case "J": ascFrom = "48119"; ascTo = "49061"; break;
case "K": ascFrom = "49062"; ascTo = "49323"; break;
case "L": ascFrom = "49324"; ascTo = "49895"; break;
case "M": ascFrom = "49896"; ascTo = "50370"; break;
case "N": ascFrom = "50371"; ascTo = "50613"; break;
case "O": ascFrom = "50614"; ascTo = "50621"; break;
case "P": ascFrom = "50622"; ascTo = "50905"; break;
case "Q": ascFrom = "50906"; ascTo = "51386"; break;
case "R": ascFrom = "51387"; ascTo = "51445"; break;
case "S": ascFrom = "51446"; ascTo = "52217"; break;
case "T": ascFrom = "52218"; ascTo = "52697"; break;
case "W": ascFrom = "52698"; ascTo = "52979"; break;
case "X": ascFrom = "52980"; ascTo = "53640"; break;
case "Y": ascFrom = "53689"; ascTo = "54480"; break;
case "Z": ascFrom = "54481"; ascTo = "55289"; break;
default: break;
}
return AscToCN(ascFrom) + " - " + AscToCN(ascTo);
}
public static string AscToCN(string asc)
{
int i = Convert.ToInt32(asc);
byte[] array = new byte[2];
array[0] = (byte)((int)(i / 256));
array[1] = (byte)((int)(i % 256));
return System.Text.Encoding.Default.GetString(array);
}
// 测试用例
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show(GetCN("Z"));
}
--创建取拼音函数
create function fGetPy(@Str varchar(500)='')
returns varchar(500)
as
begin
declare @strlen int,@return varchar(500),@ii int
declare @n int,@c char(1),@chn nchar(1)
select @strlen=len(@str),@return='',@ii=0
set @ii=0
while @ii<@strlen
begin
select @ii=@ii+1,@n=63,@chn=substring(@str,@ii,1)
if @chn>'z'
select @n = @n +1
,@c = case chn when @chn then char(@n) else @c end
from(
select top 27 * from (
select chn = '吖'
union all select '八'
union all select '嚓'
union all select '咑'
union all select '妸'
union all select '发'
union all select '旮'
union all select '铪'
union all select '丌' --because have no 'i'
union all select '丌'
union all select '咔'
union all select '垃'
union all select '嘸'
union all select '拏'
union all select '噢'
union all select '妑'
union all select '七'
union all select '呥'
union all select '仨'
union all select '他'
union all select '屲' --no 'u'
union all select '屲' --no 'v'
union all select '屲'
union all select '夕'
union all select '丫'
union all select '帀'
union all select @chn) as a
order by chn COLLATE Chinese_PRC_CI_AS
) as b
else set @c='a'
set @return=@return+@c
end
return(@return)
end
go
--创建汉字拼音库
create table YingShe(CHR char(2),PY varchar(10))
insert YingShe
select '长','chang'
union all select '长','zhang'
union all select '城','cheng'
union all select '科','kel'
union all select '技','ji'
union all select '金','jin'
union all select '立','li'
union all select '章','zhang'
union all select '公','gong'
union all select '司','si'
/*--下面是两个函数,一个以表的形式返回某个字符串的全部拼音,一个返回某某个字符串的其中一个拼音
--*/
--获取汉字拼音的函数--返回所有的拼音
create function f_getpy_tb(@str varchar(100))
returns @tb table(re varchar(8000))
as
begin
declare @re table(id int,re varchar(8000)) --数据处理中间表
declare @i int,@ilen int,@splitchr varchar(1)
select @splitchr=' ' --两个拼音之间的分隔符(目的是为了通用性考虑)
,@i=1,@ilen=len(@str)
insert into @re select @i,py from YingShe where chr=substring(@str,@i,1)
while @i<@ilen
begin
set @i=@i+1
insert into @re select @i,re+@splitchr+py from @re a,YingShe b
where a.id=@i-1 and b.chr=substring(@str,@i,1)
end
insert into @tb select re from @re where id=@i
return
end
go
--获取汉字拼音的函数--返回汉字的某一个拼音
create function f_getpy(@str varchar(100))
returns varchar(8000)
as
begin
declare @re varchar(8000)
declare @i int,@ilen int,@splitchr varchar(1)
select @splitchr=' ' --两个拼音之间的分隔符(目的是为了通用性考虑)
,@i=1,@ilen=len(@str)
select @re=py from YingShe where chr=substring(@str,@i,1)
while @i<@ilen
begin
set @i=@i+1
select top 1 @re=@re+@splitchr+py
from YingShe where chr=substring(@str,@i,1)
end
return(@re)
end
go
--测试
--返回'长城'的所有可能拼音
select * from dbo.f_getpy_tb('长城')
--返回'长城'的拼音
select dbo.f_getpy('长城')
--删除拼音函数
drop function f_getpy,f_getpy_tb
// 得到一个汉字的拼音第一个字母,如果是一个英文字母则直接返回大写字母
private static string GetCharSpellCode(string CnChar)
{
long iCnChar;
byte[] ZW = System.Text.Encoding.Default.GetBytes(CnChar);
// (1) 如果是字母,则直接返回
if (ZW.Length == 1) return CnChar.ToUpper();
else
{
int i1 = (short)(ZW[0]);
int i2 = (short)(ZW[1]);
iCnChar = i1 * 256 + i2;
}
// (2) 汉字处理
if ((iCnChar >= 45217) && (iCnChar <= 45252)) return "A";
else if ((iCnChar >= 45253) && (iCnChar <= 45760)) return "B";
else if ((iCnChar >= 45761) && (iCnChar <= 46317)) return "C";
else if ((iCnChar >= 46318) && (iCnChar <= 46825)) return "D";
else if ((iCnChar >= 46826) && (iCnChar <= 47009)) return "E";
else if ((iCnChar >= 47010) && (iCnChar <= 47296)) return "F";
else if ((iCnChar >= 47297) && (iCnChar <= 47613)) return "G";
else if ((iCnChar >= 47614) && (iCnChar <= 48118)) return "H";
else if ((iCnChar >= 48119) && (iCnChar <= 49061)) return "J";
else if ((iCnChar >= 49062) && (iCnChar <= 49323)) return "K";
else if ((iCnChar >= 49324) && (iCnChar <= 49895)) return "L";
else if ((iCnChar >= 49896) && (iCnChar <= 50370)) return "M";
else if ((iCnChar >= 50371) && (iCnChar <= 50613)) return "N";
else if ((iCnChar >= 50614) && (iCnChar <= 50621)) return "O";
else if ((iCnChar >= 50622) && (iCnChar <= 50905)) return "P";
else if ((iCnChar >= 50906) && (iCnChar <= 51386)) return "Q";
else if ((iCnChar >= 51387) && (iCnChar <= 51445)) return "R";
else if ((iCnChar >= 51446) && (iCnChar <= 52217)) return "S";
else if ((iCnChar >= 52218) && (iCnChar <= 52697)) return "T";
else if ((iCnChar >= 52698) && (iCnChar <= 52979)) return "W";
else if ((iCnChar >= 52980) && (iCnChar <= 53640)) return "X";
else if ((iCnChar >= 53689) && (iCnChar <= 54480)) return "Y";
else if ((iCnChar >= 54481) && (iCnChar <= 55289)) return "Z";
else return ("?");
}
// 测试用例
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show(GetCharSpellCode("张"));
}