发表于 2009-1-5 19:48
| 
瀛樺偍杩囩▼涓皟鐢–#鍐欑殑DLL
鍙戝竷: 2008-6-30 10:12 | 浣滆: admin | 鏌ョ湅: 20娆
鏈杩戜竴涓」鐩腑閬囧埌涓涓浆鎹ileTime鐨勯棶棰.鏃堕棿鏄湪C#涓敤DateTime.ToFileTime鍐欏叆鏁版嵁搴撲腑,杩欏湪瀛樺偍杩囩▼涓垽鏂勾鍜屽搴︽垚浜嗛棶棰,鎬庝箞鏍锋墠鑳芥妸鏃堕棿杞崲涓烘甯哥殑鏃堕棿鏍煎紡鍛?Sql server涓張娌℃湁FromFileTime瀵瑰簲鐨勬柟娉?鍏跺疄寰堢畝鍗曠敤C#鍐欎竴涓浆鎹㈡椂闂寸殑Dll鐒跺悗鍦ㄥ瓨鍌ㄨ繃绋嬩腑璋冪敤灏卞彲浠ヤ簡.
杞崲鏃堕棿鐨勭被濡備笅:
[Guid("729ba6af-3eff-4b75-b43b-d951a190dbe6")]
public class FileTimeConvert
{
public FileTimeConvert()
{
}
public string ConvertTime(long fileTime)
{
string retVal = string.Empty;
if (fileTime > 0)
{
DateTime dt = DateTime.FromFileTime(fileTime);
retVal = dt.ToString();
}
return retVal;
}
}
娉ㄦ剰杩欎釜Guid鎴戜滑鍦ㄥ瓨鍌ㄨ繃绋嬩腑寮曠敤瑕佺敤鍒拌繖涓狦uid.
涓烘柟渚垮彲鑳藉湪澶氬闇瑕佽皟鐢,鎴戜滑涓撻棬鍐欎竴涓瓨鍌ㄨ繃绋
濡備笅:
CREATE PROCEDURE spu_ConvertFileTimeToNormal
@ticks BIGINT,
@returnval varchar(40) output
AS
DECLARE @src varchar(255)
DECLARE @desc varchar(255)
DECLARE @object int
DECLARE @hr int
EXEC @hr = sp_OACreate '{729ba6af-3eff-4b75-b43b-d951a190dbe6}',@object OUT
IF @hr = 0 --濡傛灉鍒涘缓瀵硅薄鎴愬姛
BEGIN
EXEC @hr = sp_OAMethod @object,'ConvertTime',@returnval OUT,@ticks
print @returnval
print @hr
if(@hr <> 0)
BEGIN
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
END
END
ELSE
BEGIN
--print @hr
print 'Create Object ConvertTime failed'
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
RETURN
END
EXEC @hr = sp_OADestroy @object
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @object
RETURN
END
GO
杩欎釜鏃跺欐垜浠繕宸渶鍚庝竴姝ユ敞鍐孌LL浜
鍦.net 鍛戒护琛屼笅杈撳叆 regasm -codebase path
濂戒簡,鐜板湪鎴戜滑灏卞彲浠ュ湪鍏朵粬瀛樺偍杩囩▼涓皟鐢ㄨ繖涓瓨鍌ㄨ繃绋嬭繑鍥炴甯哥殑鏃堕棿浜.
缁欎釜灏忎緥瀛:
EXEC spu_ConvertFileTimeToNormal @CreateTime,@NormalTime OUT
@CreateTime:FileTime鏍煎紡
@NormalTime :姝ｅ父鐨勬椂闂存牸寮忓瓧绗︿覆(spu_ConvertFileTimeToNormal 瀛樺偍杩囩▼杩斿洖鍊)
杩欎釜绠鍗曠殑灏忎緥瀛愯鏄庝簡鎴戜滑鎬庝箞鏍峰湪瀛樺偍杩囩▼涓皟鐢―LL
鏄笉鏄綘瑙ｅ喅闂鍙堝浜嗕竴涓夋嫨浜嗗憿?
http://ktgu.cnblogs.com/archive/2006/05/30/413352.html
