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); } }