{"id":285,"date":"2007-11-15T21:49:00","date_gmt":"2007-11-15T21:49:00","guid":{"rendered":"http:\/\/www.sincebirth.cn\/?p=285"},"modified":"2007-11-15T21:49:00","modified_gmt":"2007-11-15T21:49:00","slug":"subsonic%e7%9a%84%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/sincebirth.space\/?p=285","title":{"rendered":"SubSonic\u7684\u5b58\u50a8\u8fc7\u7a0b\u64cd\u4f5c"},"content":{"rendered":"
\n

\u4e00\u4e2a\u4e0d\u751a\u5b8c\u5584\u7684\u5b58\u50a8\u8fc7\u7a0b\uff1a<\/p>\n

———————————–\u5b58\u50a8\u8fc7\u7a0b\u4ee3\u7801\u5f00\u59cb————————————<\/p>\n

— ================================================
\n— \u4f5c\u7528\u662f\u4ee3\u66ff\u81ea\u52a8\u589e\u957f\u578b\u7684ID\uff0c\u8fd9\u6837\u4fbf\u4e8e\u5206\u8868\u7684\u7ef4\u62a4
\n— ================================================<\/p>\n

set ANSI_NULLS ON
\nset QUOTED_IDENTIFIER ON
\ngo<\/p>\n

ALTER PROCEDURE [dbo].[GenerateRUID]<\/p>\n

@tblName varchar(50),
\n @currentnumber int OUTPUT<\/p>\n

AS
\n SET NOCOUNT ON
\n Declare @tempnumber int<\/p>\n

Begin<\/p>\n

SELECT @tempnumber= CurrentNumber
\n FROM Ruid
\n WHERE (TableName = @tblName) <\/p>\n

SET @tempnumber=@tempnumber+1
\n  
\n Update Ruid
\n SET CurrentNumber=@tempnumber
\n Where TableName=@tblName<\/p>\n

SET @currentnumber=@tempnumber
\nEND<\/p>\n

———————————–\u5b58\u50a8\u8fc7\u7a0b\u4ee3\u7801\u7ed3\u675f————————————<\/p>\n

\u4ee5\u4e0b\u662f\u5229\u7528SubSonic2.0\u4f7f\u7528\u8be5\u5b58\u50a8\u8fc7\u7a0b\u7684\u4ee3\u7801\uff1a<\/p>\n

———————————–\u4ee3\u7801\u5f00\u59cb————————————<\/p>\n

public static int GetRUID(string tblName)
\n        {
\n            StoredProcedure spd = new StoredProcedure("GenerateRUID");
\n            spd.Command.AddParameter("@tblName", tblName);
\n            spd.Command.AddOutputParameter("@currentnumber");
\n            spd.Execute();
\n            int currentnumber = int.Parse(spd.OutputValues[0].ToString());
\n            return currentnumber;
\n        }<\/p>\n

———————————–\u4ee3\u7801\u7ed3\u675f————————————<\/p>\n

www.subsonicproject.com<\/a><\/p>\n

\u5f15\u7528\uff1ahttp:\/\/www.sim-zone.cn\/?uid-6-action-viewspace-itemid-548<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u4e00\u4e2a\u4e0d\u751a\u5b8c\u5584\u7684\u5b58\u50a8\u8fc7\u7a0b\uff1a —————— … \u7ee7\u7eed\u9605\u8bfb\u201cSubSonic\u7684\u5b58\u50a8\u8fc7\u7a0b\u64cd\u4f5c\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-285","post","type-post","status-publish","format-standard","hentry","category-all"],"views":1082,"_links":{"self":[{"href":"https:\/\/sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts\/285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sincebirth.space\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sincebirth.space\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=285"}],"version-history":[{"count":0,"href":"https:\/\/sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts\/285\/revisions"}],"wp:attachment":[{"href":"https:\/\/sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}