总结

using System.Security.Cryptography;

namespace Wicresoft.Common.Utility
{
    public static class StringHelper
    {
        public static string GetMD5Str(string str)
        {
            MD5 md5 = new MD5CryptoServiceProvider();
            byte[] byteArray = md5.ComputeHash(Encoding.UTF8.GetBytes(str));
            return Convert.ToBase64String(byteArray);
        }
    }
}

 

Enum.GetName(typeof(UsercontrolType), UcTypes)

 

 

ALTER trigger [dbo].[lockDay_salesDaily]
    on [dbo].[sales_daily]
    after insert,update
as 
begin
        declare @dayId int;
        set @dayId=(select i.day_Id from Inserted i);
        if not exists(select null from lock_day where day_id=@dayId and tableName='sales_daily')
        begin
            insert into lock_day(day_id,tableName) values (@dayId,'sales_daily')
        end    
end