yilv_new/AA/YiLvRunFrom/Dal/TimeDal.cs

using cuidian.Sql;
using System;

namespace YiLvRunFrom.Dal
{
    public class TimeDal
    {

        public static DateTime GetLastTime(string entity)
        {
            string sql = string.Format("select lasttime from  transtime where entitytype='{0}'", entity);
            return Convert.ToDateTime(DbUtils.ExecuteScalar(sql, ConnectionUtils.Instance.GetConnection("TempDB")));
        }
        public static void SetLastTime(string time,string entity)
        {
            string sql = string.Format("update transtime set lasttime=DATEADD(SECOND,+1,'{0}') where entitytype='{1}'", time,entity);
            DbUtils.ExecuteNonQuery(sql, ConnectionUtils.Instance.GetConnection("TempDB"));
        }
        public static void deleteErr(string sysids)
        {
            string sql = string.Format("delete from WdtLogs where sysid in({0})",sysids);
            DbUtils.ExecuteNonQuery(sql,ConnectionUtils.Instance.GetConnection("TempDB"));
        }
    }
}