public bool Update(T entity)
{
var type = typeof(T);
var sql = type.GenerateUpdateSqlString();
var rows = DbHelperSql.ExecuteSql(sql, AdoUtil.GetParameters(entity));
return(rows > 0);
}
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="id"></param>
/// <param name="objUpdate"></param>
/// <returns></returns>
public static bool UpdateById <T>(object id, object objUpdate) where T : class
{
var t = typeof(T);
var sql = t.GeneratePartialUpdateSqlById <T>(id, objUpdate);
var i = DbHelperSql.ExecuteSql(sql, AdoUtil.GetParameters(objUpdate).AppendParameters <T>(id));
return(i > 0);
}
public virtual int Insert(T entity)
{
var type = typeof(T);
var sql = type.GengerateInertSqlString();
var obj = DbHelperSql.GetSingle(sql, AdoUtil.GetParameters(entity));
return(obj == null ? 0 : Convert.ToInt32(obj));
}
public DateTime GetUniversialTime()
{
try
{
if (_differ != default(TimeSpan))
{
return(DateTime.Now.Subtract(_differ));
}
var result = (DateTime)AdoUtil.ExecuteScalar(string.Format("select getDate()"));
_differ = DateTime.Now - result;
return(result);
}
catch
{
return(DateTime.Now);
}
}
