/// <summary> /// 表:T 的修改方法||表描述:臂长操作 /// </summary> /// <param name="model">T 实例</param> /// <param name="transaction">数据库事务对象</param> /// <returns>返回结果:0(修改错误),>0(修改成功)</returns> public int Update(T model, SqlTransaction transaction) { var sqlClause = string.Format(UpdateSqlClause, TableName); var parameters = GetParameters(model, true); return (DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters)); }
/// <summary> /// 表:d_ArmLenOperate的删除方法||表描述:臂长操作 /// </summary> /// <param name="id">主键ID</param> /// <param name="transaction">数据库事务对象</param> /// <returns>返回结果:0(删除错误),>0(删除成功)</returns> public int Delete(int id, SqlTransaction transaction) { var sqlClause = string.Format("DELETE FROM {0} WHERE {1} =@Id", TableName, PrimaryKeyName); var parameters = new[] { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = id; return (DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters)); }
public virtual int Update(int id, string fieldname, object fieldValue) { var sqlClause = string.Format("UPDATE SET {2}='{3}' {0} WHERE {1} =@Id", TableName, PrimaryKeyName, fieldname, fieldValue); var parameters = new[] { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = id; return (DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters)); }
/// <summary> /// 根据黑匣子编号删除记录 /// </summary> /// <param name="fieldValue"></param> /// <param name="transaction"></param> /// <param name="fieldname"></param> public void DeleteByField <TElement>(string fieldname, T fieldValue, SqlTransaction transaction) { var sqlClause = string.Format("DELETE FROM {0} WHERE {1} =@{1}", TableName, fieldname); SqlDbType sqlDbType = SqlDbType.BigInt; int size = 0; if (typeof(TElement) == typeof(int)) { sqlDbType = SqlDbType.Int; size = 4; } else if (typeof(TElement) == typeof(Int64)) { sqlDbType = SqlDbType.BigInt; size = 8; } else if (typeof(TElement) == typeof(Guid)) { sqlDbType = SqlDbType.UniqueIdentifier; size = 16; } else if (typeof(TElement) == typeof(DateTime)) { sqlDbType = SqlDbType.DateTime; size = 16; } else if (typeof(TElement) == typeof(string)) { sqlDbType = SqlDbType.NVarChar; size = (fieldValue.ToString()).Length; } else { return; } var parameters = new[] { new SqlParameter(string.Format("@{0}", fieldValue), sqlDbType, size) }; parameters[0].Value = fieldValue; DbHelperSql.ExecuteSql(ConnectionString, sqlClause, parameters); }
public void Execute(string sqlClause) { DbHelperSql.ExecuteSql(this.ConnectionString, sqlClause); }